Just as an aside; I have got into the habit of using the "Script as create" instead of "Script as alter" or "Modify" options when looking at stored procedures, functions,...

Good article, but wouldn't the Post Code view containing the conditional elements return the whole postcode for parts 1 & 2 rather than blank when there is no space in...

At least the old adage has been proven - that any conversation left to run long enough on the internet will result in someone being likened to Hitler!

The structure proposed by tshad allows employees to flat-share. If you want overall flexibility, you need 3 tables; Employee, Address and EmployeeAddressLink. The start and end dates would then belong...

I have worked on a similar task before. The approach I took was to copy the names to another table (along with the primary key so I could link back...

Good article. One thing that often crops up in job advertisements is "must have experience of the finance industry" and a premium is usually paid for candidates who have that...

When my brother was at college, he was astonished by his friend's reaction to the statement "I'm just going for a tommy". Both parties understood this to be rhyming slang;...

The answer "I don't know" was 100% correct in my case (of course, it's not now).

I've worked for managers who were useless in their current role, but brilliant if you needed them to answer technical questions. I've also worked for excellent managers who took far...

I realise this is an old thread, but I've stopped receiving the newsletter. It was getting increasingly sporadic over the last few months, but I've not received any at all...

To answer the original question; this

http://www.sqlservercentral.com/Forums/Topic1752249-1292-1.aspx

is recursion.

It looks as if only one connection is being used. When does the error occur; on table creation, row insert or the select?

I don't think anyone "builds his business on millions of lines of code". What happens is that systems get written and then things change (the changes are frequently made by...

Does that mean I get a toaster now?

We're probably going to be getting the Redgate tools fairly soon, so the developers will start using SQL Prompt. One of the things I need to do is set the...