Thanks a lot for your suggestion .

Can  you please  elaborate more on this "If the updates/deletes are sporadic, select the updated date into a new column store...

Thank you 🙂

Ya right its a huge topic , its just for my knowledge purpose and I wanted to give a seminar on how Data base evolution started and where...

HI,

Thanks for your reply , But am working only on MSSQL server or Data base development activity not DBA and SSIS not SSAS or Data warehouse .

So sql+ssis combination I...

Hi,

Thank you very much for the response and solution as well .

Will try to implement .

Regards,

Ravindra

HI,

Thanks for reply ... as you said if we have same result set then it works . But i have 3 different result set with different data type as...

You mean There is no other no possibility to capture more than one result set in proc2 with out modifying Proc1 . ?

But i cant modify proc1 .. i can do any changes in proc2 but not the proc1 which has 3 result set.

yes you can, but how will you do that ?

HI Am also having the same requirment.

I tried to follow the steps you have specified but didnt worked.

Its giving error . "late bound resolution for dts".

Can you please...

Thanks for the quick reply. yes file names will be dynamic and need to fetch specific file names only which has some format in a floder .

Cool ...Many Thanks 🙂

Thanks for the quick response 🙂

Tons of thanks

it works very well 🙂

Hi All,

Thank you for your valuble reply .. finally am able to over come my prob .. here is the query

Declare @date Datetime='2013-06-16 00:00:00.000'

select REPLACE(Convert(Varchar(25),CASE...