Matt, I haven't made myself clear.

I use linq to sql, it's great!

What's better is linq and the entity relationships. ETLM I user that also.

What I am looking for specifically is...

No, sorry, from Franklin TN originally, but live in (today) snowy Denver.

Need to go home cause of blizzard conditions.

Lynn, dude you rock.

Have any of you seen the challace and viewed another way it looks like a face?

Or a cube drawn on paper, and how the perspective can change.

I liken doing updates...

Bob, just because I know how to do updates (in mass) or inserts in mass to tables. Doesn't mean I favor the language of use. Don't get me wrong, I...

I didn't realize my rant was only about cursors.

I figured that MS might be smart enough to take loop language and translate it directly to sql which it seems...

I have heard of mumps and always regarded it as a disease.

And dataphore is a strange word.

I guess it all depends on your environment and the maturity of your database.

in sql2008 I have found it best to first find the final output you want to achieve,...

personally the sql commands I have for reports don't travers more than 5 or 6 tables. If you are traversing a lot of tables, then pre-compiled is better. But most...

GilaMonster (3/24/2009)

---

Please post 2005-related questions in the 2005 forums in the future. I'm not asking to be pedantic. I'm...

I have an idea on how this could be done.

Create 2 new tables with an identity, insert the records and join on identity.

But I don't think that is a prefered...

GilaMonster (3/24/2009)

---

Ok, so do you want them matched in order of the columns? So for output you want (first few rows only)

3191 3621004

3193 3621005

3340 3621006

3391 3621007

3392 3621008

3394 3621009

Correct?

Can I use...

GilaMonster (3/24/2009)

---

It can be done easily. It's a trivial problem. I'm just missing some information I need.

I don't know what your data...

If I write a cursor function to do this, would you guys understand it better?

GSquared (3/24/2009)

---

Use this:

declare @ID int;

--

select @ID = productcontrolid

from productcontrol

where productcontrolid in

(select top 25 productcontrolid

from productcontrol

order by productcontrolid desc);

That'll get you an ID you can use for your update.

Then just write...

being as sarcastic as possible, you may control the order if you wish. Maybe using order by??

I don't care, unique is unique and that's all that matters.