Ian, a simple example is at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlxml3/htm/bulkload_6bos.asp 

Doesn't require diffgrams - very simple to just insert to a temporary table.  I use it that way myself.

Cheers

Stephen

He's just lucky the creator didn't try an apostrophe in Edgar's

Could possibly be database permissions.  These aren't as portable as some people assume, when you restore a database from one server to another.  You may have similarly named users /...

You might take a look at the NCHAR() and UNICODE() functions.

If I understand you rquestion correctly (by no means certain) you're trying to embed validation to disallow certain characters in...

Had a similar situation at one of my employers.  We used a Custom Data Extension to get in between the report and the database, and re-build the connection string on...

I think you can also use the SERVERPROPERTY() function for this.

select convert(varchar(200),serverproperty('LicenseType')) 

gives you the type of license (PER_SEAT, PER_PROCESSOR or DISABLED) and

select convert(varchar(20),serverproperty('NumLicenses')) 

gives you either the number...

I'm really not a fan of soundex for a couple of reasons:

1.  You don't always get what you expect - even where you'd think it was simple.  Try

select soundex('knight')    ...

This issue apparently is going to be addressed in an upcoming (June/July) SP of Reporting Services.  See also in thread http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=108952

This SP is intended to give export support to...

This issue is supposed to be fixed in an upcoming SP1 for Reporting Services (June/July 2004).  At that release RS will (allegedly) export in the native binary interchange format.

Amother useful technique is to shift the case statement to the select-list, give it an alias and then use the alias in the ORDER BY clause.

select case @Order when 'LNAME'...

Unfortunately the example given doesn't illustrate this correctly. Try the following instead:

DECLARE @TTT TABLE (THE_ID INT NOT NULL)

INSERT INTO @TTT VALUES(1);

INSERT INTO @TTT VALUES(2);

INSERT INTO @TTT VALUES(3);

INSERT INTO @TTT...