May 28, 2014 at 8:34 am
There are about 10 select statements in a store procedure.
All select statements are need.
Is it possible to output only the result of last select statement?
May 28, 2014 at 9:03 am
adonetok (5/28/2014)
There are about 10 select statements in a store procedure.All select statements are need.
Is it possible to output only the result of last select statement?
Remove the other select statements?
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
May 28, 2014 at 9:08 am
Are the other select statements doing anything other than just returning values? If not then I can't see why they are needed.
I'm having trouble picturing why statements that are returning values are needed in the stored procedure when all you want is the result from just one of them.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply