Hi J,

It really does help to have some test data to work against. See the first link in my signature for how to do this.

But, to help you out, here...

For me, programming computers is my passion. There are other things that I enjoy, but this is my passion. I can't imagine doing anything else.

It does have its downsides......

Use a table-valued delimited-split function, with a cross apply, to handle this. The tvf returns the individual parts of the passed-in string as a table.

First, if you don't have the...

jcrawf02 (5/27/2010)

Jack Corbett (5/27/2010)

jcrawf02 (5/27/2010)

Paul White NZ (5/27/2010)

Dave Ballantyne (5/27/2010)

So, if it does upset me, then you'll go ahead and buy...

LOL

The Dixie Flatline (5/27/2010)

Check out the two links in my signature for CROSS-TABS and PIVOTS.

If you still need help, check out the first link in my signature.

Good going Lutz. I completely missed that he specified one column with CSV output... Thanks!

This little bit of code makes a dynamic table of the possible strings, then gets the next one from what is passed in.

declare @test-2 varchar(4)

set @test-2 = 'AAZ'

-- See Jeff...

cmckenzie-656927 (5/27/2010)

Check out this link for how to add to the "My Places" bar on the left side of the open/save as dialog box. Note that the instructions are for SSMS...

Paul White NZ (5/24/2010)A full-text index is the same, storage-wise, as any other non-clustered index. The parent object has an entry in sys.internal_tables, and the DBCC commands can be...

Paul White NZ (5/27/2010)

jts_2003 (5/27/2010)

http://msdn.microsoft.com/en-us/library/ms175049.aspx

This clearly gives 8, which wasbn't even an option!

Not my favourite question, although it did make me think a bit more...

Paul White NZ (5/27/2010)

jts_2003 (5/27/2010)

http://msdn.microsoft.com/en-us/library/ms175049.aspx

This clearly gives 8, which wasbn't even an option!

Not my favourite question, although it did make me think a bit more...