I have done this recently. The way I did it was to use a execute sql task. in this task I buillt a sql variable of all I wanted the...

I'll give the stored procedure thing a go in a test report and let you know how i get on

🙂

Thanks

I think I tried that and it doesnt like it?

just did the basic exec

is there another way to do this?

Sorry I've been banging my head against the wall...

Yes I potentially could but the reason for the query is to populate an SSRS report and I'm not sure that SSRS allows dynamic sql?

Thank you for the response again.

Your response is part way towards what I need.

the next stage, and this is where I am stuggling, is that I need basicsally the result...

Hi thanks for the quick response.

Basically the data looks like below:

PersonID Question Answer

123 ...