February 3, 2009 at 1:32 am
My SP gives 4 columns in the result set and i need to insert only one of the resultant columns into the table. Please help me out as to how to do it...
February 3, 2009 at 8:45 am
We need much more info to answer this question. Where is the temp table created, structure etc
Cheers
Andy
February 3, 2009 at 9:25 am
Assuming you are doing an:
Insert Into
EXEC [procedure]
There is no way to do limit the columns returned by the procedure unless you add a parameter to the procedure, check it's value and change the columns output by the procedure based on the parameter.
It definitely would be easier to help if you provide code and what you are trying to accomplish.
Check out the links in my signature line.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 3, 2009 at 7:54 pm
Thanks Jack... That is what i needed. I got the answer from your reply.
Thanks once again...
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply