Thanks for the ddl and sample data. It makes understanding what you are trying to do a lot easier and it makes helping possible.

I really can't quite wrap my head...

Your test data doesn't match what the OP posted. Yours is just...

riaan-777462 (10/26/2012)

---

Hi There,

I'm quite inexperienced in returning XML from SQL and have only been using single tables to return normal XML in the past.

Now, however, I need to return multiple...

http://msdn.microsoft.com/en-us/library/ms182776%28v=sql.90%29.aspx

SQL Wayne (10/26/2012)

---

Is there a way to make the results of your query to auto-fit the headers? I just started a new job and I seem to remember being able...

Luis Cazares (10/26/2012)

---

Sean Lange (10/26/2012)

---

I would also point out that based on the calculation in your query you are possibly not going to get the data you want. Even if...

Well if you only need to store characters from the standard ASCII group...

TheGreenShepherd (10/26/2012)

---

There's probably a much better way to do this, but I'll just spitball this idea as something different...what if you created a computed column that contained a concatenation of...

I would also point out that based on the calculation in your query you are possibly not going to get the data you want. Even if you first convert your...

scribesjeff (10/26/2012)

---

Hi,

Can someone help me with this query? I have two columns both are INT and have dates stored in them as YYYYMMDD I need to use them to calculate...

harri.reddy (10/26/2012)

---

hi

i am getting files which data i need to store in table.

i need help with data type

for character i am usign varchar , do i need to use nvarchar...

You should take a look at Gail's post about catch all queries here. http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/%5B/url%5D

I think once you read that you will get a pretty good idea of a good way...

Well it looks like Lowell beat me to the punch on this one. I rolled my own version, which also uses the DelimitedSplit8K function. 😉

;with cte as

(

select 1 as...

luissantos (10/26/2012)

---

Hello Sean

Your reply don´t tell me anything useful about my doughts and also don´t suggest any kind of improvements.

But OK, if i could save 2 minutes :-Dthat´s fine for...

luissantos (10/26/2012)

---

Hello again

I test the statment with the WHILE from yeshupandit_2002 and i have adding a condition for ref like '2%', i talk about 8323 REF (article) with 315610 records...