SQL Server has come a long way since SQL Server 2000.

I think CTE didn't even come along until 2005.

You are dismissing it out of hand without researching or trying it....

Did you look at using a SQL Server CTE with its ability to recurse?

That actually does a very fast loop in memory and is close to a set based operation.

SQL...

Here it is with dates formatted and ordered by freq and next run date & time. This works also in SQL Server 2012. (Darn, when I edited it,...

Two problems I see right off:

1. You may not want isolation level serializable for the whole package. That may cause unnecessary blocking in other processes.

2. if the data flow...

Please kick lingaga off the forum. that is pure SPAM.

The issue of passing a parameter to a stored procedure that contains a list of values to be used in an IN-clause used to confound me, but now one can...

However, if your organization's programmers insist on embedded SQL and the database team doesn't enforce such boundaries, then at least make sure all such SQL is sent as parameterized commands/queries...

I saw a very clever use of ROW_NUMBER( ) OVER (ORDER BY CASE WHEN ....) as RowNum,

in a CTE WITH-clause in a stored proc, where the CASE used an input...

I say go for Sprint.  I use Sprint, and my latest phone (bought last year) is far superior in reception to any previous phone (same service) so I guess the...

Oh, I get it. Sorry I missed the nice pun.

No, not an English teacher. Just a programmer (who bills himself as a "software engineer").

Funny. Actually, it's nothing to do with tense, but with case. "Me" is objective case; "I" is subjective case.

In the original phrase, "Andy and me" are both the...

I suggest that if tables have that many columns that the database needs to be redesigned.  This is an indication that the database is far from third normal form. 

Of...