Chad Crawford (1/20/2010)

---

Lynn Pettis (1/19/2010)

---

Totally different subject UNRELATED to questions getting worse. Last week I started working on setting up linked servers on our new blade servers (x64)...

Two weeks ago including time, or two weeks ago starting from midnight?

For example,

Today = 2010-01-20 08:53:07.907

2 Weeks ago = 2010-01-06 08:53:07.907

or

Today...

Brnbngls (1/20/2010)

---

I certainly dont' want to get into a criticizing of the QoTD. I have learned much from them. But being what I consider to be a SQL...

Okay,...

jswong05 (1/20/2010)

---

The original choices do not contain correct answers. Please verify the Q/A before it is published.

Imagine you take a GRE special topic test that involes world wide thousands of...

I'm sure most of you complaining would have preferred to have seen this as the code:

declare @i int, @j-2 int

set @i = 1

while (@i<=5)

begin

begin try

...

nomlad (1/20/2010)

---

It was fairly easy to see the concept which was being put across here regarding try/catch blocks - not exactly a new one for most developers these days I...

Actually, the best format to convert the date to is yyyymmdd. SQL will interpret this correctly regardless of the current language setting.

To all those who are expecting PRECISELY CORRECT ANSWERS, how about putting yourself out there and submit some questions. The answers may not have been precise, but I don't...

mzz3lh (1/20/2010)

---

I have to agree here. None of the answers match what I would expect, which would be 'This is an exception' in the message pane, followed by the...

In this case it would be better to keep the procedures separate. You may not get an efficient execution plan putting to two queries together in a single stored...

jcrawf02 (1/19/2010)

---

ooh, that's not going...

Also, give this code a try in a test environment.

update dbo.xTest set

location = xu.location

from

dbo.xTest xt

inner join dbo.xUpdate xu

...

Could you please post the DDL (CREATE TABLE statements) for the two tables? Also, how are the tables related?

I see two choices, neither of which I would implement without involving the vendor of the product, unless you own it.

One requires upgrading to SQL Server 2005/2008 and changing the...