Viewing 15 posts - 1,126 through 1,140 (of 5,590 total)
SQLkiwi (7/14/2011)
Wayne, you can avoid the join:
:blush: I should have seen that. (Coding when tired...)
Okay, I've tried these three different methods:
-- DENALI CTP3 Running Totals with enhanced over clause (cte).
;
WITH...
July 15, 2011 at 11:40 am
FYI:
I just compared this Quirky Update code to the newest enhancements in the next version of SQL Server (code named "Denali") CTP3 and found that the Quirky Update performs far...
July 14, 2011 at 9:20 am
Gianluca Sartori (7/12/2011)
What is the robbing of a bank compared to the FOUNDING of a bank?– Bertolt Brecht
The "robbing" just takes your money, without having to deal with the regulations...
July 12, 2011 at 8:39 am
Fal (7/8/2011)
Brandie Tarvin (7/8/2011)
GilaMonster (7/8/2011)
Craig Farrell (7/8/2011)Saturday's article: Why some DBAs are Nincompoops. Sunday's article: Retraction of previous article with editing: Why ALL DBAs are Nincompoops.
Monday's article: Why...
July 9, 2011 at 7:35 am
mtillman-921105 (7/8/2011)
Stefan Krzywicki (7/8/2011)
Nah, we're using "Classic SQL"
Just remember how well "New" worked for Coke.
OK, good point about New Coke.
But these days, everyone knows "classic" is just a euphemism for...
July 8, 2011 at 3:17 pm
Steve Jones - SSC Editor (7/8/2011)
TGIFActually not so much. Leaving for the UK on Sunday, will be out of touch for most of the next week. Behave.
Does this mean that...
July 8, 2011 at 11:10 am
GilaMonster (7/6/2011)
Kit G (7/6/2011)
GilaMonster (7/6/2011)
Kit G (7/6/2011)
Fal (7/6/2011)
anyone with a minor dose of manners and a sense of humor is invited.
Please,...
July 8, 2011 at 8:07 am
I added some more sample data for testing purposes. This seems to handle what you want it to do. Please note that recursive CTEs are not necessarily the best performing...
July 6, 2011 at 2:38 pm
Tom,
So, are you happy with what you coded, or would you still like for someone to look into it further?
July 6, 2011 at 2:13 pm
First, make that sample data usable.
-- See how you start off by actually creating a table and then
-- inserting the data into it? Your doing this makes it a...
July 6, 2011 at 10:36 am
Hey Jeff... I came into this thread expecting to point to your dynamic cross tab article... after reading the thread, I come to find you're recommending my article (which does...
July 5, 2011 at 10:08 pm
Tom,
For the sample data and expected results that you provided, the following code works. However, there are no checks going on with the beginning/ending MEAS values. Would you like to...
July 5, 2011 at 9:54 pm
Not sure if this will work for all the platforms that you desire, but VisualSVN is pretty nice, and is relatively cheap to boot.
July 5, 2011 at 9:37 pm
You know, the people that help out here are all un-paid volunteers, so please HELP US HELP YOU. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables...
July 5, 2011 at 4:39 pm
Viewing 15 posts - 1,126 through 1,140 (of 5,590 total)