Viewing 15 posts - 1,081 through 1,095 (of 1,228 total)
Jeff Moden (10/22/2010)
... we'll have a drag race. 🙂
Quirky Update would win this one Jeff, by a factor of about 7 - we both know that 🙂
I don't think...
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
October 24, 2010 at 9:44 am
Comment out the last four lines
AND (
SELECT S.State_ID FROM dbo.States S INNER JOIN dbo.CMD_Staging_Providers CSP
ON S.State_Abbr = CSP.Provider_State
WHERE S.State_ID NOT IN ( SELECT State_ID FROM dbo.Provider_Addresses ))
then run the...
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
October 12, 2010 at 2:55 pm
Paul White NZ (5/26/2010)
MAXDOP 512
Maxedout
Breaktime 🙂
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
May 26, 2010 at 2:02 pm
Jack Corbett (5/14/2010)
Chris Morris-439714 (5/14/2010)
Paul White NZ (5/14/2010)
CirquedeSQLeil (5/13/2010)
Thanks Gianluca. I particularly like how Paul handled this...
You would have loved my first draft reply 😉
Celko is undoubtedly a reasonably...
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
May 14, 2010 at 1:14 pm
Edit: code removed, valuable lesson in progress. Sorry guys, I worked on this for a while and posted without looking for responses.
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
May 7, 2010 at 1:46 pm
SELECT *
FROM EMPLOYEES
WHERE @empid IS NULL OR empid IN (SELECT iEmpid FROM @tblEmpid)
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
May 3, 2010 at 12:29 am
John Rowan (4/23/2010)
I have several close friends who bow hunt. I'm not sure what traditional archers think about compound bows, but I've had the chance to shoot...
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
April 23, 2010 at 3:04 pm
John Rowan (4/23/2010)
Chris Morris-439714 (4/23/2010)
Shooting all weekend, there's a competition in Chepstow on sunday for the first time in several centuries...
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
April 23, 2010 at 12:29 pm
Tom.Thomson (4/23/2010)
Chris Morris-439714 (4/23/2010)
Sunny here in England, very pleasant 18C or so.
Oh ghu! I'm flying back in a couple of days and I don't think I can stand it...
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
April 23, 2010 at 12:28 pm
Jabberwocky.
Had to look up coolats, which are known as culottes here. They're revolting, talk about the worst of both worlds!
Gödellian too. Meh. Must read more.
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
April 13, 2010 at 1:00 pm
Ensure that reportID, roleID are indexed on table #tbl.
Follow Lynn's advice, because there's almost certainly a faster way of doing this - providing sufficient detail will enable folks to figure...
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
April 13, 2010 at 12:53 pm
Miguel Ramirez-454354 (3/17/2010)
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
March 17, 2010 at 4:29 pm
bitbucket-25253 (3/15/2010)
All you young whipper snappers .... hope you last as long if not longer than myself ... (born April 18, 1932) .. no major aches, no major pains, one...
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
March 15, 2010 at 2:00 pm
CirquedeSQLeil (3/14/2010)
Steve Jones - Editor (3/14/2010)
Congrats, Paul and Jason.Err - just Paul. Not sure what Jason has done for Congrats.
Plugging Monty Python? Got a packet of wafer-thin mints here,...
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
March 14, 2010 at 12:44 pm
Paul White (3/14/2010)
Where have all the questions gone? Seems very quiet...perhaps too quiet...
Ah, that will be why your recent posts have been given a full designer makeover then!
For better assistance in answering your questions, please read this[/url].
Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
March 14, 2010 at 8:53 am
Viewing 15 posts - 1,081 through 1,095 (of 1,228 total)