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...

You can help us help you by reading the first article I have linked in my signature block below that regarding asking for assistance.

So, what don't you like about T-SQL? I find it quite easy to work with and haven't had any problem moving from a 3GL language (COBOL) to it.

The paradigm...

After stopping your code (still hadn't finished after 55 minutes), I reran the code I showed above and here are the results.

My code:

SQL Server Execution Times:

CPU time...

Now, you may be askiing "Why?" Check the second article (Running Totals and its variations) I have linked below in my signature block. If it has been republished...

Manju (3/13/2009)

---

I completely agree with your assesment of my query. I thought I had made that some what clear myself when I said "with the sample dataset"; but I should've...

Manju (3/13/2009)

---

Just tried the following for academic reasons -

With the sample dataset, the execution plan seemed far simpler - you may want to give this a try too.

update t set

...

Since this is a school project, it is best if you do your initial research first. As you find the various answers to your initial questions and need clarification...

ramadesai108 (3/13/2009)

---

The output should be intID and ClientID. Take out the intID in the order by statement because that was a mistake. As seen by one of the responder, the...

ramadesai108 (3/13/2009)

---

Hi,

The index is on the intID column. here is the script to create table and add data

create table Clients

(

intID INT,

...

Please post the DDL for your table, sample data (as INSERT statements that can be cut and paste into SSMS and run) including both numeric and non-nummeric client ids, and...