Doug (12/3/2008)

---

This in itself might be why Lynn's...

Lynn Pettis (12/3/2008)

---

Never mind my post above, it won't work. I am having a brain dead day here at work and it is seeping over to here. You'd...

GSquared (12/3/2008)

---

It won't matter as much in a Group By as it does in a Where, since the Where clause problem is table/index scans instead of seeks, and that doesn't...

umanpowered (12/3/2008)

---

Hi,

As a side question, do you know...

Sergiy (12/1/2008)

---

Matt Miller (12/1/2008)

---

By all means - coding to validate up front will allow you to get past all of those errors you get from "just throwing it against the...

Paul DB (11/26/2008)

---

Lynn, thanks for the great feedback. I am considering this question answered, but I wanted to give Matt and Grant a word...

Matt Miller (9/15/2008)

---

...and again (like Grant...

Jeff Moden (11/28/2008)

---

Jportelas (11/28/2008)

---

Thanks Sergyi, Matt and Jeffrey, so there is no way to achieve this in T-SQL for SQL Server 2000?

Seems like trying to cover all the failure scenarios...

GilaMonster (11/29/2008)

---

You could write the code in notepad and compile with the command-line C# or VB compilers (which are included with the .net framework). It's a lot of work though.

Does...

Even with the 2005 TRY/CATCH, you can't prevent EVERY error from bubbling back up. Some failures are so egregious - they're going to bust you up and that's it.

You...

Actually - one way to make sure that the recordset is read only is to use something like DISTINCT in there (assuming that in itself doesn't alter your query in...

gan (11/27/2008)

---

Michael Valentine Jones (11/25/2008)

---

In that case, let me jump in. 😀

There are many opinions of this subject, but I...

Jeff Moden (11/26/2008)

---

Matt Miller (11/26/2008)

---

...and - we're doing it again. By virtue of this thread alone - we're HIGHLIGHTING the "ugly threads" which mean they get more facetime, and...

v.reddy (11/26/2008)

---

HI,

Thanks for the response,

i was tried with Trace, but its shows only after exection, not before execution of sql statements.

i would like to capture statement before exuction and...

Not sure - this works for me:

select * from

(select Somecode, datename(month,dateadd(day,someid,getdate())) as Reg_Month, SomeCodeNotNull

from testdata) as a

...

Shandy (11/26/2008)

---

Just wanted to thank all you guys for your input (on the output :hehe:). No seriously this has been really interesting to me and I have learnt loads....