Viewing 15 posts - 61 through 75 (of 726 total)
Jason Selburg (10/20/2007)
Man, my eyes are going bad too! Now correct me if I'm wrong, but wouldn't the statement fail without having the Committed_Fund_Item_ID in the GROUP BY? :hehe:
Not in...
October 20, 2007 at 12:29 pm
Jeff Moden (10/19/2007)
You've already run into one of my best friends on this forum and I should warn newbies like you about folks like him... he has absolutely no manners,...
October 19, 2007 at 9:01 pm
Sergiy (10/19/2007)
😉
SQL 2k5 made for programming tools users having no math background, just like you.
As...
October 19, 2007 at 8:43 pm
Jack Corbett (10/19/2007)
October 19, 2007 at 8:34 pm
Keep in mind that many of these solutions handle negative numbers differently, so until the OP comes back to comment, there's no telling which method will work for him. He...
October 19, 2007 at 2:47 pm
Sergiy
Probably 2k5 is more comfortable for procedural language programmers, but for those who understand relational model and use to operate with datasets it's useless.
While I'm on board with the "set...
October 19, 2007 at 1:50 pm
In addition to what mrpolecat stated, a far more typical option in your environment would be to actually let the report use the resultset from the stored proc, instead of...
October 19, 2007 at 10:22 am
And if we do end up doing this for you (again), let us know what grade we got, even though "it's not homework".
Actually, I take it back. I can't speak...
October 19, 2007 at 10:19 am
The answer probably depends greatly on what you want to do with it once it's there, how many times you'll do this, etc.
October 9, 2007 at 2:33 pm
As with any dynamic SQL solution, I always highly recommend that you print out the string to execute long before you actually execute it. You can take the printed version,...
September 25, 2007 at 10:16 am
It sets that property in 2000 (if my ancient brain cells are remembering correctly). It can also be set in other ways, but that is still a moderately well-known undocumented proc.
September 21, 2007 at 11:48 am
It's also useful for ad hoc results, as cleaning up databases is a pain when you have to determine whether a given table is really needed or not. It's sort...
September 21, 2007 at 11:46 am
Have you checked how it's stored in the table? If it's 5.5 there, the problem is in formatting the value in the app itself. If it's 6 in there, the problem...
September 20, 2007 at 2:03 pm
While Antares686 is likely correct as to your specific problem, the way I attack these types of things is start at the app to find out what populates the column...
September 20, 2007 at 1:01 pm
Viewing 15 posts - 61 through 75 (of 726 total)