any suggestions??

is there some thing in order i am misssing?

Hi,

I tried with double quotes in all places, but same error.

also the bcp is working for pipe delimted file,

but when i do for tab delimited it is giving me the...

HI,

I used double quotes, still same error.

Hi,

DO we have any other alternate solution, other than using the sp_transform to get this results.

As , i want to use some other alternate way.

I tried the above index creation...

Thanks, i tried the change u asked me to use 101 instead of 12.

still the same issue.

i am pasting the final statement generated from sp_transform for display.

SELECT RepName, UserID,

SELECT...

Thanks for responding.i tried with the change u gave , but same issue .....

Even if we dont put aggreate='SUM', it is defaulted to SUM.

The issue is the effectivedates are not...

As suggested i have placed the code used for this issue.

Since the date is genrated dynamically based on the specified date for next 6 months or so, we need...

Hello,

How can we get the month names in order based on dynamic generation using the above method.

Any help is greatly appreciated

hi,

The business rule is to run all the steps,so i canot stop the job.

this is for monitoring purpose for us to know which steps failed and react.

thank you all for the response.

i used the pivot and it worked great!

kudos to forum members..

thanks a lot guys for directing me.

it helped.

also, i made up the dummy data ,but date field is date type only in my table and not varchar.(thanks for the advice...