Been there and done that.  Totally understood.

Only based on history, I've seen a lot of times where someone swears nothing was changed with anything having to do with the front end only to find out later...

Wouldn't it have been nice if MS had made the "datepart" of all these temporal functions so they could have take a variable?  Lordy.

I do like that code, Jonathan.

Nicely done, Alan.  Your code runs faster than GetNums and fnTally because it only uses 2 CROSS JOINs instead of 31 and 3 respectively.  It also doesn't have the habit...

I know this sounds a bit stupid but I can't see what you see.  My first check would be to see if the "missing" databases actually exist any more.  My...

The answer to your question is most likely "YES" but you've not provided enough information to go any further than that.  Please see the first link in my signature line...

Hello,

I am looking for help to understand how to generate multiple rows based on Start and End Dates.  What I have is customers enrolled into a monthly fee with...

How about a Batch delete with batches to delete.

DECLARE @batch INT
SET @batch = 10000 /* SIZE OF BATCH */       ...

You have your own  odel and that's fine.  What I took exception to was your passive aggressive and highly judgemental mouth saying such condescending things like you being...

That means that you're trying to delete about 41% of your table.

DELETEs are fully logged even in the simple...

Ok... the next step is for us to make a bit of an assessment.   Please run the code (change the table name if it's not correct).

 SELECT...

Scratch my previous.  The table you provided the code for has a NOT NULL for the attribute name but it does allow nulls for the attribute value.  Why are you...

No... not blank... it should contain the word NULL without quotes.  So go back and fix...

You have your own  odel and that's fine.  What I took exception to was your passive aggressive and highly judgemental mouth saying such condescending things like you being personalty embarrassed...

If you continue to view that image or title as discriminatory or exclusionary for white people, and that's the unintended consequence, I'm not sure if I can explain...