GSquared (4/20/2009)
That's not part of the addition. That's just setting up a framework to run it. Run the query without that, with the numbers directly in the Where clause, instead of using variables, you'll be fine.If you truly want addition without any mathematical, logical, etc., arguments, here you go:
Question: "What's some number added to another number?" (Can't have assignments in there, so you can't actually state what numbers you want to add.)
Answer: "A number."
It's a correct answer! Woot! 🙂
I was gonna suggest sp_Abacus, but your solution runs faster.
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."