Very nice.  The graphics you took the time to do the "Alice's Restaurant" thing to really make this a very clear article on what Rollups and Cubes actually do.  The...

Again, lot's of good posts.  Shie, Robert L, Noeld, and Adam have all pointed out that the use of a "Calendar Table" or "Holiday Table" to hold non-workdays (I'm assuming...

Bert,

Thanks for the great compliment!  As my follow-up note (long posting above) suggests, you can easily add a reference to a simplified holiday table to the function.

Frank,

Thanks for the tip. ...

As Farrell suggested, you don't need to do the rounding thing because INT will do the rounding for you.

Either of these will work...

SELECT CONVERT(INT,CONVERT(MONEY,'27.49'))
SELECT CAST(CAST('26.50' AS MONEY) AS INT)

Obviously, you...

Great responses, all, folks.   Thank you very much for taking the time to make them. 

Hmmmm… perhaps the title of the article should have been “Calculating ‘Week’...

mkeast,

We've all done that before.  Thanks for the come back.

Sorry mkeast,

Didn't work the way you expected... here's the output.

col       

----------

1

2

3

10

11

2A

2B

3A

3B

3C

I think the original poster wants...

col       

----------

1

2

2A

2B

3

3A

3B

3C

10

11

Great idea but I think they really want a custom error message and a check constraint won't do it.  Ran into the same problem with permissions... no custom error message.

Switching...

Like I said, I agree especially in light of that fact that many companies just don't have a documentation system in place.  Documentation always seems to take it in the...

I'd think that the "permission denied" message would drive the point home to a developer but, I agree, it might save a couple of trouble calls to the DBA's.

I kind of like Andy's idea... all of the ideas are great ones but it's not really broken.  Maybe leave it like it is?

Put the customer error message in the App?

Guess I'll add my two (or is it 3?) cents...

------ Finds the LAST day of CURRENT month with no time element
SELECT DATEADD(mm,DATEDIFF(mm,0,GetDate())+1,0)-1 AS LastDayCurrentMonth

------ Finds the LAST day of CURRENT month...

All of that seems like a fair amout of work to keep a table with only 1 row...  why not just log in as the "sa" and revoke insert, update, and...

Ok, Ken, here ya go...

DATEADD(d,DATEDIFF(d,1,getdate()),0)

DATEDIFF(d,1,getdate()) takes the difference between the current date and 01/02/1900 and converts it to a whole number of...