Thanks for the feedback, Marvin. Yeah, and if you throw in a check by IsDate, you can control the error instead of throwing it against the wall to see...

Thanks Timothy... That's why I normally don't use VBS scripts... I can do almost everything with T-SQL. 🙂

There's just nothing like someone providing instant confirmation for us folks just finally getting into 2k5... 🙂 Thanks, Matt.

rbarryyoung (3/10/2008)

---

In my experience they are necessary and acceptable for only one thing: variable-izing SQL objects in the...

kent waldrop (3/10/2008)

---

Jeff:

What are the circumstances for that? When I run the following query it get the commented results:

use tempdb

go

select name as before from sysobjects where type = 'U'

exec...

Guess it's time for porkchops here... Vika, if you want really good answers the first time around, see the URL in my signature line...

Pivot also has some limits... I believe you can only Pivot based on one column...

I disagree... a lookup or definition table better have a Primary Key...

Sorry Lynn... it was more directed at the OP than you...

Also, we'll probably disagree on this, but the new DATE only and TIME only datatypes are a real loss of...

Problem is... most people give up on trying to find a good set-based solution way too early...

Whether I agree or not, it's still interesting and dialog about such subjects are one way for folks to exchange ideas...

See above and reconsider how much hell you will go through if any of the dates ever come in with a time other than midnight... and...

Lynn Pettis (3/10/2008)

---

Jeff, since the OP wants the end of the year wouldn't you want this:

SELECT @startdate = CAST('2007' AS DATETIME)

SELECT @enddate = DATEADD(yy,1,CAST('2007' AS DATETIME)) - 1

I know why...

There are, of course, exceptions to every rule... but most people name a table after what a single row in the table holds. For example, the Customer table would...

First, I thought you said the "records" looked like this...

PunchIn, PunchOut, Break, PunchIn, Punchout.

Second... are your really happy with the solution? Try it with multiple days...

USE tempdb

go

Create Table Punches(empid...