foxjazz (3/14/2009)

---

Lynn Pettis (3/14/2009)

---

You know foxjazz, I find the following comment of yours insulting and ignorant on your part:

You all that use t-sql and don't code probably never know any...

You know foxjazz, I find the following comment of yours insulting and ignorant on your part:

You are basically...

Okay, foxjazz, you can rant incoherently that is obvious. How good are you at following directions? As Jeff requested, read THIS[/url]. Follow the steps in that article...

GilaMonster (3/14/2009)

---

Sorry, no. I've 'engaged' that one before and the threads never end without insults getting thrown around. He takes criticism and...

Troll he may be from the dark side he is. Plotting his next move maybe, devising a trap perhaps? Looking for something SQL can not do?

After his last...

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