Sorry it's taken so long to...

Jeff Moden (10/22/2010)

---

Quirky Update would win this one Jeff, by a factor of about 7 - we both know that 🙂

I don't think...

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...

Maxedout

Breaktime 🙂

Jack Corbett (5/14/2010)

---

Chris Morris-439714 (5/14/2010)

---

Paul White NZ (5/14/2010)

---

You would have loved my first draft reply 😉

Celko is undoubtedly a reasonably...

Edit: code removed, valuable lesson in progress. Sorry guys, I worked on this for a while and posted without looking for responses.

SELECT *

FROM EMPLOYEES

WHERE @empid IS NULL OR empid IN (SELECT iEmpid FROM @tblEmpid)

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...

John Rowan (4/23/2010)

---

Chris Morris-439714 (4/23/2010)

---

Sunny here in England, very pleasant 18C or so.

Shooting all weekend, there's a competition in Chepstow on sunday for the first time in several centuries...

Tom.Thomson (4/23/2010)

---

Oh ghu! I'm flying back in a couple of days and I don't think I can stand it...

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.

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...

Miguel Ramirez-454354 (3/17/2010)

---

Sorry, I look very readable on word doc but when I tried to clean it up it posted it. I am looking for option: (3) get the...

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...

Plugging Monty Python? Got a packet of wafer-thin mints here,...