No cursor needed, here is a set based way to accomplish your task.

select

COL1,

SUBSTRING(COL2,1,10) as COL2,

COL1 + SUBSTRING(COL2,1,10) as...

Alvin Ramard (4/18/2009)

---

I'm watching one of the Star Wars movie on TV and the story is not the same as it used to be. The short, greenish, master Jedi...

Here is another way to do it:

Create Table #Bar (

EmployeeID int

, EName varchar(50)

, VisitedState varchar(60)

)

Insert into #Bar(EmployeeID, EName,...

May I ask why you need to do this in the stored procedure? This is something that really should be done by the front end application or report, not...

Steve Jones - Editor (4/18/2009)

---

He'll go away if you let the thread die. He periodically comes through, posts for a few weeks, and then disappears.

Stop quoting him as well. The...

Downloading and installing SQL Server Express is great, but if you really want to learn more SQL Server you may want to look at spending a little money. For...

GilaMonster (4/18/2009)

---

Lynn Pettis (4/17/2009)

---

I wonder if he will be able to put 2 and 2 together and realize he is in the same bucket of slop as that second contractor...

steve dassin (4/17/2009)

---

Lynn Pettis (4/17/2009)

---

steve dassin (4/17/2009)

---

dphillips (4/17/2009)

---

steve dassin (4/17/2009)

---

Please remember I'm not looking to play stump the grump :-). Go in with a positive attitude. Window shopping is ok....

Actually Alvin, your answer is perfect. It's what you are doing behind the locked doors with the phone off the hook that is important. Doing all that just...

Hmmm, blame me not for Air Force flashback. Alvin's comment it was.

Strange, but something to check, are there any NULL values in Table2 (the one being queried in the WHERE ... NOT IN ?

I like Alvin's answer. Reminds me of my days in the Air Force back in England. If the computer crashed, the first thing we did was take the...

steve dassin (4/17/2009)

---

dphillips (4/17/2009)

---

steve dassin (4/17/2009)

---

Please remember I'm not looking to play stump the grump :-). Go in with a positive attitude. Window shopping is ok. There's always a chance...

Jack Corbett (4/17/2009)

---

Lynn Pettis (4/17/2009)

---

Sounds like you could have used the SNOW DAY. I was dressed and my tie half tied when I got the call this morning. ...

Change your inner join to a left outer join.