mish (8/14/2009)

---

Thanks John for the help. I have managed to get an answer to my original question and I now know that SQL does not have a command similar to...

Mish,

Back to your original question (how to use TOP to get the second and third rows of a result set). Have you tried my suggestion of using TOP...

Lynn Pettis (8/12/2009)

---

Or, an average of 3GB/day *...

I am not familiar with MySQL, but can tell you that the TOP n command in SQL Server simply limits the results to the first n rows selected. If,...

And laugh even harder again at the response to this...

Mish,

Are you in fact using MySQL rather than MS SQL Server 2005? Responses in this forum will assume the latter, as did Gail's suggested query using the Row_Number() function. Does...

If I understand this correctly, your final selection of three board members for a candidate could be the first three rows of an intermediate resut (one of your CTE's perhaps)...

This reminds me of the story about a field engineer being called in...

One more synonym for USER_NAME() is USER. No parentheses needed for that version which doesn't have the optional parameter.

For converting names to mixed case, I'll guess you've already discovered...

Besides looking at the syntax for "Update ... From", also note that the second error appears to have be a simple typo. There's an exclamation point in line...

This was an interesting question that got me experimenting and digging a bit into BOL. First, I found that TIMESTAMP values are stored as either BINARY(8) or VarBINARY(8) depending on...

I guess...

Bruce W Cassidy (8/5/2009)

---

[font="Verdana"]The part of the joke that wasn't necessarily obvious to the young'ns is that RPG is a generator. It generates COBOL code.

Oh, never mind. I...

Mike,

Welcome to SSC and thank you for sharing that function.

You should consider your head safe..... Your post made it clear that defining a function to do this...

As well as what the data type is, how are you looking at it?

If it's type "datetime" and you run a SQL query like Select MyDate from MyTablein...