Agree with pulling the logic into a cursor

Post #429,931 by crazy 7/22/19 6:14:18 PM 7/22/19 6:14:18 PM Reply	Agree with pulling the logic into a cursor Sql sucks for that type of logic. Far better to write some clean understandable code than torture sql to do it.
Post #429,934 by lincoln 7/22/19 8:14:52 PM 7/22/19 8:14:52 PM Reply	can't do it in code the subroutine calls the stored procedure, then builds an html representation of an Excel spreadsheet and binds the returned resultset to it. I did what I wanted to avoid - use a cursor and insert the variables into a table variable. That way I can check the userid for each record returned from the query, then check the awardstatus fields to determine if they need modifying. My version of the stored proc takes about 1 second longer than the original. They'll just have to live with it. Satan (impatiently) to Newcomer: The trouble with you Chicago people is, that you think you are the best people down here; whereas you are merely the most numerous. - - - Mark Twain, "Pudd'nhead Wilson's New Calendar" 1897
Post #429,938 by scoenye 7/23/19 7:58:59 AM 7/23/19 7:58:59 AM Reply	No clean way out without doing TBLUserProgramPlan over Those columns smell as if something that should have been a set of values in a table was serialized instead. Depending on the overall circumstances and permissions, could you build a function to tear it apart in to the necessary temp tables and use those to clean up the query in the current stored procedure?
Post #429,939 by drook 7/23/19 8:22:28 AM 7/23/19 8:22:28 AM Reply	Agreed, that table structure gives me the willies -- Drew
Post #429,942 by lincoln 7/23/19 10:02:20 AM 7/23/19 10:02:20 AM Reply	that table has been around for years so I've learned, and columns have been added to it since it was created. Plus numerous programs access it so I can't do anything to it (after all, I'm just a contractor, not an employee). Even better, the woman who wrote most of the ASP.Net applications and designed all of the tables in the database over a 12 year period left a few months before I was brought in, and the guy who her responsibilities dumped on him is still learning how all of the apps work. It makes it tough to ask a question to someone who may not even have touched that program yet. Satan (impatiently) to Newcomer: The trouble with you Chicago people is, that you think you are the best people down here; whereas you are merely the most numerous. - - - Mark Twain, "Pudd'nhead Wilson's New Calendar" 1897
Post #429,947 by Ashton 7/23/19 4:02:54 PM 7/23/19 4:02:54 PM Reply	(This sounds a lot like a metaphor for the 'post-Drumpf-Era'); savor the comparo, eh? ;^>
Post #429,948 by drook 7/23/19 5:29:08 PM 7/23/19 5:29:08 PM Reply	I'm just savoring the idea of the 'post-Drumpf-Era' -- Drew

Welcome to IWETHEY!