Or just make it. [font="courier"]is_active (bit)[/font].

There are several ways to do this, SQL CLR routines are probably one of the less advantageous ways.

Other ways:

1) SQL Replication

2) Triggers and Linked-Servers

3) Service Broker & EndPoints

Jeff Moden (7/2/2008)

---

We can do that! I'll actually be at PASS...

Congratulations Jeff & Michael! Richly-deserved...

Chris Morris (7/1/2008)

---

Oh all right then. No funny stuff either.

DECLARE @ItemID INT

DECLARE @FirstCol varChar(5), @SecondCol INT, @ThirdCol Char(1)

SET @ItemID = 1

UPDATE #Testing SET ThirdCol = CASE @ItemID WHEN 1...

Amen to that, Brother.

Except that that is NOT what was wanted. What was wanted was:

Eliminate One row...

Well you can set your results output to "Save to file..", but I...

Ah, OK. Now I understand. Thanks,

What? You couldn't remember that it goes quote, quote, quote, value one, quote, quote, comma, quote, quote, value two, quote, quote, comma, quote, quote, value three, quote, quote, comma,...

But if you want to stay with this, call it like this:

[font="Courier New"]

EXEC sp_Balance_BF '''A1'',''A2'',''A3'',''A4''', '', '', ''[/font]

GSquared (6/30/2008)

---

They've been taught the magic words and the mystic gestures, they know that when you say "waz zug cho cthulhu", you have to turn around widershine three times, with...

Thanks for the feedback, sherjon.

OK, I see. :blush: I really need to take...

Actually,...