Hi

I was able to work with the code you provided for dynamic pivot successfully,inside my SP using a temp table to store the results using INTO statement

like this:

(MY_TEMP07)

--Create complete SQL...

Hey Thanks...

Let me modify my SP and give it a Try...

Will comment soon..

Thanks again

Wow...

Works like a gem...

Thanks a lot...

but one question..

as I am running the statement inside a S tored procedure and it will populate a temp table in my SP..

Will the EXEC...

Hi,

No , I can't do this, as its been called from a DOT NET program and they are just passing parameters and calling it...

Any other way to handle the optional...

Thank You Sir Luis ..

Your code works ...I did implement it ...

Thanks

Thanks a lot..

but If I had to add CTE and temp table I could have done this ,Can you suggest any simple way to just add a third column...

Thanks a lot for the reply...works like a charm

Thanks a lot...it works too...

thank you both of you..................

SSIS sequence and spell check is correct but the failure is caused by > 100 rows recursion..

Error:

(109 row(s) affected)

Msg 530, Level 16, State 1, Line 11

The statement terminated. The maximum...

There is a problem but when the data exceeds 100 rows it fails ( my file contains 80,000 rows)

INSERT into @tab(data)

...

@phil.

I am directly using ssis to dump the file data into tables...

@cold coffee...Thanks a lot ...it works ............

its a raw data coming from old source file..

this is my source ...no PK is defined here in the file

Here is the create and insert script

create table TEST

(

Name varchar(100)

)

insert into test

select 'StartDocument' union all

select 'PETER' union all

select '123 AVE' union all

select 'NJ' ...

Works like Charm...Thanks man roryp 96873...

Thanks again