Jeff Moden (12/6/2012)

---

patrickmcginnis59 (12/6/2012)

---

I'll take...

I'll take that job. And...

CELKO (11/27/2012)

The same holds true with UPDATE. If you don't know how to use it correctly, then it'll do weird things to you just like any other code....

SQLSACT (11/29/2012)

---

GilaMonster (11/29/2012)

---

A page is just an 8kb chunk of data. Given that, what exactly is the difference between a page (an 8kb chunk of data) and the contents of...

I use SQLOLEDB !

It would be interesting to see if the queries produced different execution plans. I'm gonna put that on my todo list !

I can enthusicastically agree with jcrawf02 here on these concerns. I've...

richard.noordam (11/27/2012)

---

What is the best way to deal with a set of rows and determine/return the first occurance of a non-zero column value in each row, using a set of...

I'm guessing that you can, as long as you include the keyword 'OUTPUT' in all the appropriate places. This snipped returned 123 as a result of the final select statement....

I know what you mean about being stuck with the table and column formats. I'm in the same boat. When I bring these nondate data into other applications, I use...

GSquared actually already gave the bottom line here:

"If you want the date formatted, I recommend doing that above the database layer."

Formatting it with the convert functions we use required that...

the 'END' after the first convert stuff then has an 'AS DATE'. This is just sort of applying a name to the expression. Remove the 'AS DATE' then try the...

You're welcome! Make sure you keep in mind the validation...

An example just to underscore the validation point, I could put 139001 into the time column and while its a perfectly legitimate integer (or decimal (10,0)), if you applied these...

Both this post and the previous post obviously don't validate that the results are legitimate times and dates. That is probably a nice discussion to have, hope you are watching...