That's no problem. Just make up some sample data.

Problem Statement : For each...

Can you explain more clearly what you are trying to do? I don't see what a cursor has to do with this at all. Are you trying to update table1...

andre-394971 (2/2/2012)

---

No Problem, Thanks for the response... I understand that the request i put forward was not correct , I was wondering if things had changed in sql server to...

Another thing you could do that would help with the size is to remove

from each one of the subqueries. It is not needed or referenced outside of...

You're welcome. Glad that worked for you.

So what does the actual data in the column look like? Your description left me scratching my head in bewilderment. :w00t:

What you are working is a dynamic cross tab. It is outlined in the second article I posted but you have to get a bit creative with your aggregation to...

There is absolutely no reason to do this row by row. Below is an example that meets the requirements as you described them.

create table #Table1

(

FirstName varchar(20),

LastName varchar(20),

Occupation varchar(70),

ID uniqueidentifier

)

create table...

EdA ROC (2/1/2012)

---

In English: Need to select for records where the value is not equal to %.

Here's where I am in developing the statement:

select ORDER_NO, SUM(qty_alloc)

from ORD_MATL_CST

where MATL_CATEGORY = 'RSCMP'...

Look at the output clause. http://msdn.microsoft.com/en-us/library/ms177564.aspx

For the record unless you have a real reason for uniqueidentifier I would not use them as your primary key. I would suggest that an...

Does something like this get you closer?

Notice I created ddl and sample data so we know we are all on the same page.

create table #data

(

ParentID int,

ChildName varchar(25)

)

insert #data

select 1, 'Tom'

union...

Cadavre (2/1/2012)

---

Oh dear. . . has it been a long...

+1

Seems like too much effort to me. If you are using identity why do you care what number it is? What are you going to do when you 10k rows...

There are way too many possibilities and too few details provided to be of much help. Take a look at this article http://www.sqlservercentral.com/articles/SQLServerCentral/66909/%5B/url%5D.