When I was looking at the code I noticed that you were searching for "tempdb..#temp" and all other references in the script were to "#temp" without the database reference.

Excellent. I am adding this to my library. We had many problems with SQL Server based email because of the overhead, admittedly very small for one email. The problem is...

It totally depends on the level of PCI compliance. I don't remember where it was and I am no longer at that company. It was not specifically spelled out in...

Using stored procedures is a requirement for PCI compliance. It is one of the requirements that slows down or stops all manner of nasties (well delineated in earlier posts). If...

Your answer told me that I was having problems with the browser (Chrome). Tried it with Firefox - works well.

Couldn't get yours to work. Too many errors in the post. We're using this one. I wanted to see the difference. The table of holidays contains only holidays that fall...

Since our apps are primarily web pages we step around the problem by converting the problem characters to unicode. The single quote character is converted to "'". It no...

We used to do this when the code was placed in an off-site computer. It makes it more difficult for personal who aren't supposed to be in it to mess...

Change the statement

DECLARE c CURSOR FOR

to

DECLARE c CURSOR LOCAL FAST_FORWARD READ_ONLY FOR

and test the speed difference.

Nice idea. I tested it on 2000, 2005, and 2008. It works well on all of them.

One way to make a difficult problem more difficult is to make it difficult to see. Remove the formatting and it becomes more difficult for a programmer to decipher. Proper...

Very nice. I'm curious if the SQLDOM is using HTML5.

In that case the <BR>

would become <br />. Any of the tags that do not have a closing tag, such...

Our inhouse method of doing this for today's date is:

DATEDIFF(d, 0, GETDATE())

or for a general date from the DB:

DATEDIFF(d, 0, DateField)

DATEDIFF may be more expensive, but is it more expensive...

There are several errors in the code as presented. Please clean your code before you publish it.

Since I got my degree before there was a computer science degree at CSULB, I initially put my math degree to work in teaching. 100 years ago, I would have...