Why use a cursor or a loop at all?

insert testSP2

select newID(), id

from testSP;

update testsp

...

I'm thinking I wouldn't put the sub-query there, especially since it's returning a single scalar value.

you're also using 4 subqueries when you only need 1. Look at this rewrite...

Don't use the alias in the GROUP BY.

You probably want:

select EmpID as [Employee_ID] from dbo.Employee group by EmpID

Or perhaps just simply use the DISTINCT, since you don't...

Sometimes things like that take a little while to catch on. Just because there wasn't a lot of attendance doesn't mean that it won't pick up. Of course...

It functionally IS a N+M cluster. You just likely want to have 2 separate IP's and 2 separate DNS names to go long with that, which will then line...

Yes - you would need named instances. Your two clustered instances would have to have nothing in common or overlapping, just in case one single server needs to run...

Also - a couple of tips when this happens:

- check how many rows DID process. if you have 8000 rows, then chances row #8001 in the file has...

It looks to me that your usage is mostly wrong. Your try does some testing, but does nothing that would raise an error (which is what would instantiate the...

Loner (2/19/2008)

---

I started this new job and this company had no real SQL Server developer or DBA before. All the query and stored procedures were written by the web...

Christopher Ford (2/19/2008)

---

Eh.... What? :blink:

---

Frank & Kevin both bring up some very valid points though...

Jeff Moden (2/19/2008)

---

With some great mixed feelings, I won't be joining my outfit in NC... the love of my life for the last 22 years has followed me a couple...

I haven't found a good one yet.

The short list I have is this:

- SQL CLR...

Ahhh - a hierarchy.

While you might do it with a cursor - it probably would be better to use an iterative process using a temp table like the...

Jeff Moden (2/19/2008)

---

Here I am, trying to practice some of those fancy-dancy soft skills that my company has been trying to drill into my head, and you just come right...

Marios Philippopoulos (2/19/2008)

---

Matt, I completely agree with most of your points, but are you sure about the last one?

An update of a VARCHAR column in...