Create a table with select statment values from store procedure

Question

Viewing 2 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

Madhivanan-208264 SSCertifiable Points: 7516 More actions · Answer 1

ggraber (11/13/2008)
That's not going to work.
He needs two pivots.
One for TotalPackages and one for TotalCost.

Thanks

I didnt notice OP wants it for two columns

Madhivanan

Failing to plan is Planning to fail

Goldie Lesser SSCertifiable Points: 6155 More actions · Answer 2

this is not what I need, I don't want hard code the data, I need results inserted in a table .Is there way to do it?

Using SELECT INTO will get you what you need.