Nov 16, 2007 #1 sodakotahusker Programmer Joined Mar 15, 2001 Messages 601 Is there a way to select the results from a stored procedure so a sort order can be specified?
Nov 16, 2007 #2 gmmastros Programmer Joined Feb 15, 2005 Messages 14,912 Location US You can insert/exec the stored procedure in to a temp table and then select from the temp table with a sort order. Let me know if you have any trouble implementing this. -George "The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom Upvote 0 Downvote
You can insert/exec the stored procedure in to a temp table and then select from the temp table with a sort order. Let me know if you have any trouble implementing this. -George "The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
Nov 16, 2007 Thread starter #3 sodakotahusker Programmer Joined Mar 15, 2001 Messages 601 I was not aware you could do that! I muddled through it and now this is doing what I wanted. Thanks a million! Don Upvote 0 Downvote
I was not aware you could do that! I muddled through it and now this is doing what I wanted. Thanks a million! Don
Nov 16, 2007 #4 gmmastros Programmer Joined Feb 15, 2005 Messages 14,912 Location US I'm glad that my advice was helpful. -George "The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom Upvote 0 Downvote
I'm glad that my advice was helpful. -George "The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom