Viewing 15 posts - 2,281 through 2,295 (of 2,443 total)
rbarryyoung (10/15/2008)
Sorry, I was using programmer's slang (not even jargon, really).
Isn't jargon just a fancy word for slang? 😛
---------------------------------------------------------
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."
October 15, 2008 at 8:15 am
MrBaseball34 (10/15/2008)
rbarryyoung (10/14/2008)
Have you in-lined the functions yet?HUH?
He means stripping the time directly in your query, rather than calling the UDF you posted earlier to do it for you.
---------------------------------------------------------
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."
October 15, 2008 at 7:58 am
Seankerr - can I ask why you're doing this? If you're just keeping duplicate data from existing in the table, it'd be better to add a constraint to the column.
---------------------------------------------------------
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."
October 14, 2008 at 10:53 am
(off-topic) Chris, curious, how are you formatting your code? Are you using something to help (I think I remember from other posts there's an add-on or something that formats it),...
---------------------------------------------------------
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."
October 14, 2008 at 10:51 am
The whole thing boils down to the stock market just being insane. The problem with the model, more data or no, is that trading is based on the perception of...
---------------------------------------------------------
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."
October 14, 2008 at 10:41 am
Here's a prettied-up version, commas, hyphenation and casing:
--============================================================================================
-- Create and populate a Tally table
--By Jeff Moden, 2008/05/07 http://www.sqlservercentral.com/articles/TSQL/62867/
--============================================================================================
--===== Conditionally drop and create the table/Primary...
---------------------------------------------------------
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."
October 13, 2008 at 9:34 am
All that good info, and the only thing that really jumped out at me was "the first half of 2010, which is 18 months away."
Dear God, I'm getting old ....
---------------------------------------------------------
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."
October 13, 2008 at 7:40 am
You're forgetting that all such courses have an agenda. Depending on the curriculum, the 'right' answer may change. If I'm teaching you about C++, then I'm going to tell you...
---------------------------------------------------------
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."
October 10, 2008 at 5:33 am
Just curious, if you are working in an environment where DBA's DON'T know not to use sp_, is there another way to filter out the system procs and keep the...
---------------------------------------------------------
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."
October 10, 2008 at 5:10 am
Ewan Hampson (10/9/2008)
project managment as a bureaucracy instead of a methodology
Now there's a dissertation waiting to be written. Sounds like an anti-pattern.
I agree. Maybe a "good PM" simply...
---------------------------------------------------------
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."
October 9, 2008 at 7:49 am
ggraber (10/8/2008)
I just presented this concept at work using your split csv example.
I was just trying to think what other examples...
---------------------------------------------------------
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."
October 8, 2008 at 7:57 am
Jeff Moden (10/6/2008)
This forum is a bit odd... it sometimes turns left parenthesis into smiley faces.
I'm sorry, is that one statement or two? 😀
---------------------------------------------------------
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."
October 7, 2008 at 12:31 pm
Just curious Clint, if your date ranges are going to change, how are you going to handle the changes without using variables?
---------------------------------------------------------
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."
October 7, 2008 at 12:30 pm
An article would be fun, I've already seen several uses I haven't tried yet.
Karthik, you were first to suggest it (within this thread anyway). You going to write us...
---------------------------------------------------------
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."
October 7, 2008 at 7:50 am
True, sorry, bad example. I was just thinking that it would be better to create the month names on the fly and sum up the amounts within the months...
---------------------------------------------------------
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."
October 6, 2008 at 10:30 am
Viewing 15 posts - 2,281 through 2,295 (of 2,443 total)