lmu92 (7/5/2009)

---

Peso (7/5/2009)

---

In your CTE, ROW and VALUE elements are upper case, and in your cross apply the row and value path are lower case.

This results in an empty result....

Not with an identity column. If you really need this, you may need to do it in a trigger.

First, I...

Jeff Moden (7/4/2009)

---

You bet, Wayne. Thanks for answering my seemingly unrelated questions. They go far in helping me understand the needs of folks so I can setup certain...

Peso (7/4/2009)

---

Good effort but won't work.

1. XML is case sensitive.

2. Run the code again, after fixing the case sensitive elements, with this test data

insert into #temp values ('I like Ike...

This is going to leave a lot of people guessing at what you're looking for.

If someone starts looking at a range of numbers, is that range then put into this...

I think that this might be a good read for you: Comparing Table Variables to Temporary Tables[/url]

Thanks...

Ahh, now I...

Jeff Moden (7/4/2009)

---

Last but not least, Wayne... I ran your code and the XML section returns nothing. Perhaps the forum ate some of your code. Can you attach...

Jeff Moden (7/4/2009)

---

Also, please answer the following questions:

How many time have you had to split something in real production work that actually consisted of more than 8k bytes? What...

Jeff Moden (7/4/2009)

---

No problem......

You might want to consider using XML.

if object_id('tempdb..#temp') is not null drop table #temp

create table #temp(record varchar(100))

insert into #temp values ('I like SQL Server')

;with CTE AS

(

select RowNbr = row_number() OVER...

Since the original poster deleted his post, I'm speculating (from the reply post) that he wanted to get just the file name from a full path filename.

A slightly better way...

Doctor Who 2 (7/4/2009)

---

I've got SQL Server 2005 Developer Edition loaded on my home PC, which I do development against. I know there is a limit to the file...