Oh hell yes! I'm a professional pork chop launcher! 😛

Oh yeah... meant to ask. Barry, do you remember what you did a search on? I did one on the error message itself and got just about everything...

Heh... we're running Lotus Notes so not sure any of the servers are running Exchange. I'll take a look, though.

It would really be cool if Barry's suggestion were all...

Properly cut pork chops only have 3 sides... well, until they hit... 🙂

Heh... it's the only way he could get the eyeholes on the helmet right. 😛

I agree... there's nothing in the data presented that identifies which row in the first table goes with which row in the second table other than physical order listed... and...

Crud... I was just reaching for the bucket o' fresh pork chops... 😛

Matt Whitfield (1/6/2009)

---

Jeff Moden (1/5/2009)

---

A clustered index and a PK, clustered or not, can both have multiple columns. As you well know (just saying it for folks who may...

Grant Fritchey (1/5/2009)

---

WITH RECOMPILE was...

sqlblue (1/5/2009)

---

Can I do batch insert or update with a set of rows at a time(does not have to be in order of any kind), and have it automatically go...

First, I'd give Peso's code a whirl.

Second, if you really must do the Null conversion to 0, use ISNULL instead of COALESCE... ISNULL is actually quite a bit faster the...

RBarryYoung (1/5/2009)

---

Sorry...

pavankumarh2 (1/5/2009)

---

Dear Friends ,

I am moving to work on Production support as DBA ,plz any tell me any body what are the common responsibilities of...

My very strong recommendation would be that both queries are wrong simply because of the use of BETWEEN. In the first query, you miss out on a whole second...

My general rule of thumb is to never use table variables unless the system forces me to. That means the ONLY place I use them is in UDF's.

The reason...