Joe Celko is a purist and while technically correct (probably) he has a "forceful" way of expressing his views.

OK I have got my file by ditching the FOR XML command and using the sp_makewebtask stored procedure with a template that has my XML structure in it.

If I keep...

Good news Dad, your airbag works!

You couldn't trust him to sit the right way on a toilet seat!

Your displaying more intelligence than your hand-writing would suggest.

The most important part of...

If I could get the file then FTPing it is pretty straight forward.

My problem is that my query produces the XML I want but if I try and use a...

The behaviour of the outer join is very useful if you get an question such as

"Give me all the customers who ordered in December who didn't order in November"

You can...

I would consider having a set of archive tables that are basically structurally identical to your existing tables.

Your existing tables contain the data up to 3 months old, your new...

SQL2000 or SQL2005?

Jan 1st 2005 = Saturday

7 days * 52 weeks = 364 days therefore Dec 31st 2005 = week 53.

Jan 1st 2006 = Sunday which is day 2.

Dec 29th 2006 is...

In your VB app what is brought back if you list the results of SELECT * FROM Tstar_Currency?

Also, I have come across a situation where a user database and system...

So going back to my lookup table example with an ID and Description column I should be better off putting my clustered index on my description column rather than on...

In your C# you define your sqlparameter in exactly the same way as you would any other parameter but parameter.direction =ParameterDirection.Output.

You datatypes match those being submitted to the procedure. ...

So basically the argument against them is that they are entirely artificial values that are independent of the data?

I'm not sure what the argument is against using them in clustered...

If you look at the way that EM does it.

CREATE TABLE dbo.tmp_yourtablename ( the new field list )

IF EXISTS(SELECT * FROM dbo.tmp_yourtablename)

EXEC('INSERT INTO dbo.dbo.tmp_yourtablename (the new field list)

SELECT the...

It is just as valid as

BEGIN

SELECT 0 AS ls_action

END

It is just a different way of writing it.

Hang on, if you put a clustered primary key on a table where the primary key isn't naturally ordered doesn't it increase the page splits?

So although fragmentation per se does...