LSAdvantage (1/20/2010)

---

talltop-969015 (1/20/2010)

---

LSAdvantage (1/20/2010)

---

Just to put another spin on the subject that was raised about how people should not be providing free advice on a forum during work hours. ...

jswong05 (1/20/2010)

---

That is exactly the message we need in the U. S. of A. Not just to technical people, also to the entire company from CEO to clerk, who work...

scott williams-465021 (1/20/2010)

---

Thanks for all the posts. So even though the database appeared totally "out of wack" - technical term, once the server was restarted the database seems good....

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