Heh... and IMHO, CLR's have virtually no place including UDF's. RegEx and file handling are the only two places I've not been able to beat a CLR with T-SQL.

Ross McMicken (3/1/2009)

---

I've looked, but can't find the procedure I developed. It's not too difficult, just copy the sp_who2 code to query analyzer, and make the changes to display the...

Yeah, I saw how you think you fixed it on the other thread of yours... lemme tell you the same thing I...

Nope... if all you've done is replace a Cursor with a Temp table and While loop, all you've...

GilaMonster (2/28/2009)

---

Jeff Moden (2/27/2009)

---

Seems like the only difference between you and me as that I never honor the case of the system objects except for very large auto-generated scripts......

Here's one, straight from the horse's mouth....

http://technet.microsoft.com/en-us/library/ms131075.aspx

The part that they left out is that there's normally a way to do the same thing in more than 95% of the case...

Google "UPSERT SQL SERVER 2005".

Basically, you need both an UPDATE and an INSERT. Both would have joins between the two tables. For the UPDATE, if the join succeeds,...

If you were to go through the code and document it, I'll just be you could figure it out yourself. 😉

Make the view without the WHERE clause. Use the WHERE clause when selecting from the view.

Based on what? What are the business rules?

Also, please see how to post sample data in...

SELECT @CompanyID = company_id FROM updated

Your code contains the line above... there's no such thing as an UPDATED table inside the trigger. Do you have a table outside the...

Heh... finally... someone besides me...

Christopher...

Let's think about this... what harm would it cause if all the items were equal and we still did the update anyway? Unless you have triggers or a TIMESTAMP...

I'd definitely suggest you read the article that Bit Bucket pointed you to, but not until you understand how a Tally table actually replaces a loop in situations like this....

sp_cursorfetch isn't something the 3rd party vendor wrote into their code... it's what get's used as a result of their code (or anyone's code).

They key here is, and I...