Correct you are, SQL Server 2005 features use you can not while in compatibility mode 80 (SQL Server 2000).

Unfortunately, I won't be coming to PASS either. No funds available. 🙁

steyaert (10/28/2009)

---

No, I did not run the code separately. As a trigger, the "deleted" table would not exist, so the code would not function successfully as a stand-alone.

I did...

gmamata7 (10/28/2009)

---

Looks to me like there may have been a problem during the in-place upgrade. Not really sure where or what you need to look into as all my upgrades...

Glad I could help. Looks like you found another reference that assisted as...

Actually, having just looked at BOL, there are several examples using multiple variables. Looks like they aren't necessarily using variables like I had setup, but they are there. ...

Looks to me like there may have been a problem during the in-place upgrade. Not really sure where or what you need to look into as all my upgrades...

ssismaddy (10/28/2009)

---

Hi, I m trying to get the following result using getdate() :

2009-10-28 08:33:00.000 i.e: I want precision only in minutes and I don't want to display seconds..

...

Roy Ernest (10/28/2009)

---

I shouldnt take both together. Pain killer in the morning and muscle relaxant in the night. The doc told me that the muscle relaxant is going to make...

Why?

Careful mixing the pain killers and the muscle relaxant. My...

Roy Ernest (10/28/2009)

---

I got into an accident yesterday. A four car pile up. Thankfully no one got hurt bad. My whole body is sore. Hit my chest badly on the...

Okay, since you did ask for help, care to enlighten us with your solution? Others may benefit.

Make the following changes to the code I provided:

set @incode = '%' + 'B01' + '%'

--set @incode = '%' + (select top 1 code from anotherTable where USERID=@PersonId) + '%'

Agreed. Forum etiquette says you should post any resolution you come up with if you...