Sorry, I'm not sure if I understand the question. The UNION ALL statements were just there to insert the sample data into the test table. You'd use all sorts of...

[p]Ooh Fun. A pivot! [/p]

[p]This is the old-fashioned way I usually do it. I kept your date order just in case you needed it that way. The code looks...

I hope that our SQL Server Security Workbench [/url] will tell you how to do this.

Yes, it is a fascinating story. We're now getting some accounts from his work-mates that ring true, for a change. It would be great to turn the whole story into...

I suspect that, as soon as the details of this case come out, the focus of blame will move to the people who were responsible for supervising the guy....

A while back, a long while back, I worked, in Japan, with a big Japanese company on the design and production of a computer. Although the manager had spent ten...

How's this for a solution (slow, but then it is best to get something working and move on from that point (watch out for the two close-brackets at the end....

Am I right in saying that you have a table that represents a catalogue of Design Drawings? This table has the name of the designer, and also a number of...

There are drawbacks to using Select Into...

For a more general stored procedure for copying a list of tables, procedures or functions from one database to another have a look at...

Gail,

I'm so pleased you got the recognition. I'm a great fan of your forum entries. I was trying to find my favourite one of all, in which you test the...

As well as the wonderful articles they both write, I always particularly enjoy reading forum entries by Jeff and Michael. In Jeff's case, it is his tenacity in sorting out...

I don't see much of a future for cursors if you get on the committee, Jeff. Additionally, I'd kick out XQuery in favour of an extension to SQL for querying...

[p]I'm a developer, not a DBA, but I've worked with a large number of DBAs. I ought to know what the core skills for a DBA are but I believe...

Nigel is one of the most consistently popular writers on the Simple-Talk site. He has a refreshing way of never taking anything in TSQL for granted, but is always ...

He was an ex-cop too and a martial arts expert! He had wonderful ways with developers who tried fiddling with production databases.