Luis Cazares (11/21/2014)

---

Sean Lange (11/21/2014)

---

ZZartin (11/21/2014)

---

Sean Lange (11/21/2014)

---

Under the hood a cursor is a...

ZZartin (11/21/2014)

---

Sean Lange (11/21/2014)

---

Under the hood a cursor is a just a while loop...

muthyala_51 (11/21/2014)

---

sorry again.

Here is the requirement:

...

This update i am doing for all 12 newsletters , in a loop through the Tbl_sample_data for each logon user using cursor or temptable one...

Under the hood a cursor is a just a while loop on steroids that...

g.britton (11/21/2014)

---

Luis Cazares (11/21/2014)

---

Damian-167372 (11/21/2014)

---

Luis Cazares (11/21/2014)

---

Damian-167372 (11/21/2014)

---

yes your absolutely right I agree table variable is a overhead for this query,

but for any other large queries I can...

muthyala_51 (11/21/2014)

---

Sean Lange (11/21/2014)

---

Your question is not very clear. You did a great job posting ddl and sample data for the sample data table. However, your query has the table...

Luis Cazares (11/21/2014)

---

Damian-167372 (11/21/2014)

---

yes your absolutely right I agree table variable is a overhead for this query,

but for any other large queries I can use this method slightly...

Wayne West (11/21/2014)

---

Sean Lange (11/21/2014)

---

Wayne West (11/21/2014)

---

It sounds like you are trying to argue against 2014 and using 2012 instead because of the difference in price, yet you also state...

Wayne West (11/21/2014)

---

Phil Parkin (11/21/2014)

---

What is it about 2012 that makes you think it will be a better solution for you in this case?

Why would you avoid going for...

Damian-167372 (11/21/2014)

---

ok this what i have come up.. so you can do it

DECLARE @tbl_var TABLE( servername varchar (100 ), ...

Your question is not very clear. You did a great job posting ddl and sample data for the sample data table. However, your query has the table main_table in it...

Damian-167372 (11/21/2014)

---

Sean Lange (11/21/2014)

---

Thanks, ...

Stewart "Arturius" Campbell (11/21/2014)

---

Sean Lange (11/21/2014)

---

Great question but the explanation and the linked article were terribly disappointing. The article says to use the table designer for creating indexes after it...

marcia.j.wilson (11/20/2014)

---

Oh, great....

Damian-167372 (11/21/2014)

---

ok this is what i do

DECLARE @server_namevarchar(200)

Declare cr cursor for

SELECT server_name FROM dbo.Tbl_ServerList

Open cr

Fetch cr into @server_name

WHILE @@FETCH_STATUS = 0

begin

SET @cmd = 'select...