In other words, what we do "depends" on what situation. And that's how it should be. We need some rules, we need to enforce them, but we also need exceptions...

Heh... what??? You guys didn't know that "SMO" stood for "[font="Arial Black"]S[/font]low [font="Arial Black"]M[/font]oving [font="Arial Black"]O[/font]bjects"? 😛

Mouli,

I believe this will solve your problem... no UDF overhead... no need for CROSS-APPLY. Just use the whole thing as another derived table. I suppose it could be...

Sorry... went to edit and ended up double posting, instead... please see below in my next post.

Chirag (3/23/2009)

---

Have a look at this

declare @str varchar(100)

select @str = '1230-544,15C5487,132DE78'

;With Breakdown as

(

Select

SubString(@Str,1,1)[Chr],

1[Idx]

Union All

Select

SubString(@Str,Idx+1,1),

Idx+1

from Breakdown

where (Idx+1)<=Len(@Str)

)

select chr from Breakdown where isnumeric(chr) = 1

Edit:- This will return ',' and...

Like derived tables and CTE's, every time you reference a view in the from clause of query causes the view to be "re-executed" (results materialized) and that's gonna make for...

polo_sport09 (3/22/2009)

---

I have drop all rows in my table... when i insert them back aggain the identity starts at 50 instead of 1.

i think i need to set identity to...

pedro.ribeiro (3/23/2009)

---

Hi -

I have a table. This table (table1) as 3 columns (name,address and number).

The fields 1 and 2 (name and address) are already with data.

I need to...

I don't believe any of that is necessary in either 2000 or 2005, but I can't tell without some sample data ... please see the link in my signature below...

I'd recommend learning some of the basics...

http://sqlcourse.com/

Have you any sample data that you'd like to share along with the expected answer to make you thread perfectly clear? And, before you post any data, please take...

Heh... you should have stated that...

Why do you want to know?

RBarryYoung (3/23/2009)

---

So what's Lynn really like in person? Can you actually see the...

halifaxdal (3/23/2009)

---

Jeff Moden (3/20/2009)

---

halifaxdal (3/20/2009)

---

Thank you all for the reply, like I mentioned earlier, the problem has almost been resolved except: how to ignore the last line in the source...