Viewing 15 posts - 2,251 through 2,265 (of 4,080 total)
I am a developer, but even if I weren't my opinion about the urgency of these questions still stands.
Understand, I am not saying the OP doesn't have a right to...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 12, 2009 at 10:52 am
Your way would definitely save a few CPU cycles, but shouldn't it be
GROUP BY DATEADD(month,datediff(month,0,cv.Dischargedtm),0)
??
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 12, 2009 at 10:40 am
European or African swallow?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 12, 2009 at 8:35 am
GROUP BY convert(varchar(6),getdate(),112)
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 12, 2009 at 8:15 am
I believe this is the third question which I have seen marked "urgent" from this particular OP.
Obviously, it's all urgent to him. But...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 12, 2009 at 8:06 am
Because his homework assignment is due in the morning?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 12, 2009 at 7:54 am
The Thread is like a Zen koan.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 12, 2009 at 7:42 am
Why was this urgent?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 10, 2009 at 6:29 pm
Gail is right. However neither cubes nor summary tables in SQL get automatically updated when values are changed. You have to rebuild them. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 10, 2009 at 6:17 pm
If the data is static, just take the results of the query and store them in a table, then query THAT table.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 10, 2009 at 12:02 pm
First, test performance by writing to a temp table, not displaying on a screen. Screen display of thousands of rows adds overhead that has nothing to do...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 10, 2009 at 7:51 am
I have to ask: Why is this being done with a cursor? It is terribly inefficient, as is populating each variable with a separate query to the...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 9, 2009 at 1:54 pm
You're welcome, Mike.
Mark, the articles are very worthwhile and you will find tally tables an enormously useful (and FAST) technique. Take the...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 8, 2009 at 12:19 pm
Mark, it's time you learned about tally tables to replace while loops and save a few cpu cycles. 🙂
Some good articles
http://www.sqlservercentral.com/articles/T-SQL/62867/
http://www.sqlservercentral.com/articles/T-SQL/67899/
An example for parsing:
declare @input varchar(100)
set @input = '|1|2|3|a|b|c|delta|bravo|#|@|'
;with...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 8, 2009 at 10:33 am
No problem. It's not *that* big a deal, but you're welcome.
CTEs are our friends. 😉
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
October 7, 2009 at 2:38 pm
Viewing 15 posts - 2,251 through 2,265 (of 4,080 total)