You need to use XQuery.

Side note: A great resource for several XQuery solutions is Jacob Sebastians blog

DECLARE @tbl TABLE

(

id INT,

col XML

)

INSERT INTO @tbl

SELECT 1,'<Product>

<name>car</name>

<color>red</color>

<type>sedan</type>

</Product>'...

Your requirement is not clear.

What do you mean by "auto generate"? Are you looking for some kind of an identity column in a custom format?

To ensure you only have unique...

What would be your expected result if there are more than one row per id where either one row has the value 9999.9999 or all rows or sum = 9999.9999...

I noticed this is at least the 4th thread you opened on the very same issue (with minor changes to the required output but all requests are related to the...

I strongly recommend NOT to use a VARCHAR() column to store date information (including not using a lenght of 12 when you know there's always a lngth of 3...) :pinch:

It...

Here's my approach.

I took a while since I had to figure out how the calcualtion is done...

If my reverse-engineering failed you have to modify the aggregation to meet your requirement....

PaulB-TheOneAndOnly (10/19/2010)

---

Well... imagine we are in the year 2030 and...

sqwasi (10/19/2010)

---

Thank you Lutz and Drew. Drew, I will adjust my query accordingly. That makes sense. I also figured out that when tries to calculate my average...

I'm not sure if the c.u.r.s.o.r. will provide the results you're looking for...

It would really help a lot if you could provide some more details (table def, sample data and...

Cldewar (10/19/2010)

---

LutzM (10/19/2010)

---

Cldewar (10/19/2010)

---

How about data disappeared from my table and there are no deletes in any of my procedure. What could have done this?

I encountered a problem where...

Well, when using a *cough* c.u.r.s.o.r. you're processing one row at a time (also called RBAR - row by agonizing row). SQL Server is optimized to deal with sets. A...

jaffrey (10/17/2010)

---

LutzM (10/16/2010)

---

jaffrey (10/16/2010)

---

Before going any further I'd like to know the true reason why you don't use the simple DELETE statement. Also, please describe the business case you're working...

Cldewar (10/19/2010)

---

How about data disappeared from my table and there are no deletes in any of my procedure. What could have done this?

I encountered a problem where the delete...

Option 1:

move the FETCH part from the IF section to the outer section.

So, instead of

if (@ProfCOD1 <> 'YES')

...

I'm very sorry, but the main reason you didn't get an answer yet is still an incomplete requirement: We have the table and the data in a ready to use...