As I recall, 2005 doesn't support windowed functions, so you have to deal with any running totals problem (decrementing from a total falls under the category of running totals) in...

Just...

J Livingston SQL (7/8/2016)

---

Zidar (7/8/2016)

---

Obviously, we need more constraints. What we have so far is OK, but we need more. Time permitting, new post is coming this afternoon, if not,...

Hey Zidar, here is the function and check constraint to avoid overlap. Can't guarantee it's flawless, I just knocked it out during a break.

I presume you are...

How to enforce 2 or 3?

CREATE UNIQUE INDEX IX_#subscriptions ON #subscriptions (SubscriberID, UnsubScribedDate)

will work for our example where the definition of an active subscription is one without an UnsubscribeDate....

Thank you for putting in the effort to create the constraints.

A CASE expression is an expression, just like a formula or function.

Its logic produces a single scalar value.

It is not another version of...

I see it in the syntax...

I don't have time to write a paper at the moment, so this will have to suffice. 🙂

I've read Mr. Celko's books, and I have seen some truly execrable flat...

If you have the ability to change your transactional code I would suggest this, only because subscriptions are always paired with cancellations.

create table ##TEST (ID int, SubscribeDate date, UnsubscribeDate date)

New...

If result.Ip_Code is a number, you could always use it's negative in place of DESC

CASE WHEN result.Pc_CrFCIC IN (52, 53) THEN result.Ip_Code ELSE -result.Ip_Code END,

Found one: http://sqlblog.com/blogs/rob_farley/archive/2012/06/12/merge-gives-better-output-options.aspx

Stefanie, not sure why I missed reading your message with the sample code I wanted. But thanks to you as well.

Thanks to you all.

Drew, that sounds like the answer to a maiden's prayer, and I'd like to remember it for future reference, but after reading your note I looked at the MSDN pages...

DECLARE @Inputs TABLE (RowID INT IDENTITY(1,1) PRIMARY KEY, TextString VARCHAR(100))

insert INTO @inputs

VALUES ('SELECT * from client where id = ''789546'' and county = ''Northants''')

,('select * from client where id =...

TheSQLGuru (7/7/2016)

---

So then the question becomes can you hold off creating the B-table rows until you have acquired all that you need to populate them without doing a post-insert update?...