Jack Corbett (3/13/2009)

---

I prefer not to be the Saint of Lost Causes. I looked at his other posts and he acts...

No it isn't. ...

foxjazz (3/13/2009)

---

First off, I don't "struggle" with t-sql, I use it a lot.

A lot of what I have to do is use cursors, because of how my database is structured,...

foxjazz,

I believe I met your requirement. We all are still waiting to hear back from you.

I killed it back before my last post. I'm not sure I will try it against a 1,000,000 row table again. I think it will take too long...

Anyone else care to join the fray??

foxjazz (3/13/2009)

---

ok example sort of (my computer is sick so I can't give you something already done)

select name from mynametable where changedate > @yesterday

fetch from @sel into @name

while (@@fetch_status =...

Really? That is really necessary? No, I'm...

Let's give every employee a 10% raise:

update dbo.employee set

Salary = Salary * 1.1;

foxjazz (3/13/2009)

---

Ok here is what I would like to do:

run a query or view that gets a datatable (in t-sql) not c#

Then run through each record in the datatable that...

foxjazz (3/13/2009)

---

cursors heh

Excatly my point.... So why doesn't t-sql accomodate sets?

Why would I need a cursor to do updates like ?

foreach(select * from table)

{

insert into othertable (field) value(myfield) ?...

foxjazz (3/13/2009)

---

I don't think it's my problem that sql server is so inefficient with the use of cursors. Maybe they should have designed sql server better eh?

Yes shortening of stuff...

I'd say minimal difference, but I'd personally use the second option.

foxjazz (3/13/2009)

---

also instead of using cursurs like they are now, wouldn't it be easier to say:

foreach( select myfield from tbl where myotherfield > 3)

{

insert into myothertable (myotherfield) values (myfield)

}

I think...

Your complaints are a bit of the mark IMHO. There is nothing wrong with the sematics of T-SQL. It's just different the C# just like C# is different...