One warning about the output clause, it can only contain columns that were inserted into the primary table (and calculated columns based on those columns). It will not...

No, no, no... B5010D2A-F8F9-482B-AC29-C1351ECE52C8 is my NAME. My friends call me BR-542.

My appointment is 45DF88B8-C798-45DC-8E8D-4898172DB091.

declare @table table (xtext varchar(100))

insert into @table

select 'bicycle safety' union all

select 'safety bicycle' union all

select 'bicycle sidewalk safety' union all

select 'safety goggles bicycle' union all

select 'bicycle highway speeding' union all

select...

Or we could just go back to flat files. Screw relational AND hierarchical databases.

You're welcome. I figured you'd get there eventually 😉

That's a really good idea, Steve. Sometimes the amount of value in...

I agree with Gus. Your simplest approach is to simply use an identity column and add the "U" when the number is displayed to your supervisor's application. ...

--

There is also a trick to handling spaces, commas, or other separators, which is shown in the examples below. The trick is to test an expression which includes...

I have to ask why the U is mandatory.

Care to elaborate on that, Paul? I'm somewhat familiar with Service Broker but I want to be sure I'm not misunderstanding you.

Take a minute sometime to read it and the comments, Jack. I don't think he was comparing apples to apples.

Another thing to point out about XML's use of space is that, barring compression, the data is being stored as characters wrapped in tags, making storage of integer, numeric, or...

Good luck, blue. It's really not difficult, just tedious and time consuming.

It's not a bug. That behavior is consistent even with char data (see code below).

Trailing blanks or spaces are disregarded, and in my opinion that's a fine thing too....

Jack, I think you have an OP who is lacking in the fundamentals as well as ESL-challenged.

Lynn, I'll say a little prayer for her tonight.

Grant, you and Gus...