HI, Jez

ok, thank you for reply

Could u please suggest me,

what care we should take while writing queris using joins and sub-queries.. etc.,

in case we have huge data in the...

Hi,

thanQ for quick reply

could u please suggest is there any other options... rather than tuning the query,

coz, it is a very big SP and the execution plan also very...

Hi friends,

For me also the same problem, I am very new to SSIS. we need to transfer data from AS400 to SQL2005 on every week end.

I have installed...

Actually i am not storing the resultant query in the any table.

I am directly running the query to generate the report.

------------

Finally i got the solution for this,

I achieved the...

Yes, it has to work, but it is not working... in my prod db

it is working in the my local SQL 2000 also.

i dont y it is not working in...

Hi Preethiviraj,

thank you for your reply,

Actuall My requirement is to Calculate the User Performance i.e how much time he took to complete one task based on Business hours.

For this i...