Well - there are now several "base installs" of SQLExpress.  The most recent one includes SSMS Express (SQL Server Management Studio for Express).

The original base install didn't include it and...

I think you're having trouble because you're using double-quotes instead of single quotes in your SQL statement. 

case <field> When '<stringvalue>' then '<stringvalue>' END

If it IS Jet SQL - then...

It's a shame you're running this in 2000 - you could have thrown a regular express at it in 2K5....

Of course - there's some stuff over here that might help...

I like PATH better these days, because it gives me the control needed as to what the "guts" of the XML file should look like by playing with the field labels...

Without specifying a row terminator - it's assumed to be carriage return.  Are you returning text fields that might have a carriage return in them?  The first one it runs...

I think you and Brandie both are touching on a fundamental aspect of this: focus / definition.  Just in the same way as the Hostile Work Environment legislation exists in...

That's a tag team I'm NOT commenting on

Correct Kenneth - and I can see I am guilty of said sloppy use of terms.  I'm heading back and removing my own sloppy handling of the terms.

well - connections and CAL's are different concepts.  CAL = seat, meaning how many machines can connect to me at any given time.  The fact that as part of doing...

I always found the FOR XML RAW to be a bit broken, since it tends to return invalid XML (no root node, so any query returning more than one row...

alter

function Excel_monthadd(@datefield datetime, @inc int) returns

Look at the syscolumns table in the given DB.  The ID field matches the ID in Sysobjects that this column comes from

<quote>

Didn't I say, there are several that will disagree with me.  The examples given are the standard ones.... Only one field to reference the column. ... What if I...

You'd probably look into obfuscation methods, and some type of hook (outside of SQL server) that would be required in order for this to app to run.  It's not easy...

Well - I've used recruiters on and off.  There are a LOT that don't have a clue, who are in essence dangerous (since they wouldn't know how to match my...