Viewing 15 posts - 961 through 975 (of 3,957 total)
ChrisM@Work (1/2/2014)
... for now we've got a rusty car wheel, a piece of lime green chalk and a small fish!
No small fish allowed.
January 2, 2014 at 6:16 pm
Luis Cazares (1/2/2014)
This code is a modification from Dwain Camps' Pattern-based splitter.
First of all, let's give credit where credit is due. That fast code came out of Chris Morris...
January 2, 2014 at 6:10 pm
WayneS (1/2/2014)
Hi Dwain,Thanks for your kind remark. And thanks again for responding to these questions.
You're welcome. I was hoping you wouldn't mind too much if I had your back...
January 2, 2014 at 5:06 pm
I believe that this may be an alternate solution.
SELECT Name
,[MAX(starttime)]=MAX(CASE WHEN rn = c THEN starttime END)
,[MIN(STARTTIME)]=MIN(CASE WHEN rn = 1 THEN...
January 1, 2014 at 11:11 pm
j-1064772 (1/19/2012)
How do the newfangled Analytics functions compare with the Quirky Update method used for - among other things - creating running totals in term of performance ?
I haven't tested...
January 1, 2014 at 9:03 pm
First of all Wayne, this is a great primer on using the new SQL 2012 analytic functions, and I know I for one will be referring folks to it if...
January 1, 2014 at 8:59 pm
homebrew01 (12/26/2013)
When giving a helpful reply, throw in a few comments to explain some of the less obvious SQL statements. It can make a world of...
January 1, 2014 at 6:28 pm
ChrisM@home (1/1/2014)
First some sample data:
SELECT TOP (50000)
ID = ROW_NUMBER() OVER (ORDER BY (SELECT NULL)),
[Version] = 'CTCAE v4.03 (MedDRAv12.0)',
Grade = 1+ABS(CHECKSUM(NEWID()))%5
INTO Data
FROM SYSCOLUMNS a, SYSCOLUMNS...
January 1, 2014 at 6:06 pm
Jeff Moden (1/1/2014)
Sean Lange (12/20/2013)
Last name is "Camps" so possessive would be Camps' 😀
Doh!!! Sorry about getting your name wrong. :blush:
Dwain must have been "camping out" just waiting for you...
January 1, 2014 at 5:55 pm
ChrisM@Work (12/31/2013)
Stefan Krzywicki (12/30/2013)
wolfkillj (12/30/2013)
Stefan Krzywicki (12/30/2013)
wolfkillj (12/30/2013)
GilaMonster (12/30/2013)
wolfkillj (12/30/2013)
December 31, 2013 at 4:15 am
I hate to be the bearer of bad tidings during this holiday season, but this just came to my attention this morning.
Steven Willis, whom some of you may know by...
December 26, 2013 at 6:13 pm
And here is (I think) another way to do it in SQL 2005 that avoids the self-join:
SELECT ScheduleID, PersonID, startDate, durationDays
,row2StartDate, CalculatedEndDate, datedifference
...
December 25, 2013 at 12:08 am
SQL 2012 makes pretty short work of this type of problem:
WITH PartitionedSchedules AS
(
SELECT ScheduleID, PersonID, startDate, durationDays
,CalculatedEndDate=DATEADD(day, durationDays,...
December 24, 2013 at 11:02 pm
sharonsql2013 (12/24/2013)
No worried .. I figured it out:)Its
Sum (case .... then 1 else 0)
I think you meant:
Sum (case .... then 1 else 0 end)
If you're counting, it might be...
December 24, 2013 at 9:27 pm
rocky_498 (12/24/2013)
Yes DOB in my DB is DATETIME, In my sample data i created, i am using varchar for DOB. I will change it to datetime for DOB....
Why do you...
December 24, 2013 at 9:16 pm
Viewing 15 posts - 961 through 975 (of 3,957 total)