sgmunson (12/31/2014)

---

I'm not sure that CTE's are available in SQL 2000 either. I can't remember. You can check Books Online, or maybe just Google it. ...

I feel much better now...

rodjkidd (1/7/2015)

---

Hello all,

Just caught up with the thread. Was away for Christmas then experienced New years Eve in London. basically it takes 2 hours longer to get back! So got...

Aaron,

High five to you for coming up with the most interesting challenge (at least to me) so far for the new year! So interesting in fact I couldn't let...

Grant Fritchey (1/7/2015)

---

It's kind of a weird question. I mean I've built complex queries, but I don't remember that many of them now. Plus, most of the ones I wrote,...

Nevyn (1/7/2015)

---

aaron.reese (1/6/2015)

---

@nevyn

Unfortunately that is the simplified version 😀

Let's concentrate on the first part: finding records with the same repeating patterns but in different time phases.

A manual scan of the...

Jeff Moden (1/6/2015)

---

dwain.c (1/6/2015)

---

SQLRNNR (1/6/2015)

---

Lynn Pettis (1/6/2015)

---

Luis Cazares (1/6/2015)

---

dwain.c (1/6/2015)

---

Lynn Pettis (1/6/2015)

---

... Mark one off, 52 days on the calendar to go. 52 days on the calendar to go, 52...

SQLRNNR (1/6/2015)

---

Lynn Pettis (1/6/2015)

---

Luis Cazares (1/6/2015)

---

dwain.c (1/6/2015)

---

Lynn Pettis (1/6/2015)

---

... Mark one off, 52 days on the calendar to go. 52 days on the calendar to go, 52 days to go,...

I'm going to miss your...

Very interesting problem there Aaron! Allow me to offer what I can here.

My interpretation of this is that it reminds me of Itzik Ben-Gan's subsequences challenge: http://sqlmag.com/t-sql/identifying-subsequence-in-sequence-part-3, albeit it...

You may want to take a look at this article as it may also help to identify your options:

http://www.sqlservercentral.com/articles/T-SQL/106783/

Perhaps this might be a little simpler, assuming I got the requirements correct.

CREATE TABLE #ABC(

[Hno] [nchar](10) NULL,

...

Here's one that I believe will work with the desired record missing in either table:

CREATE TABLE #abc(

SeqNo smallint NULL,

Payment decimal(10, 2) NULL

);

GO

CREATE TABLE #def(

SeqNo smallint NULL,

Payment decimal(10, 2) NULL

);

GO

INSERT INTO...

Eirikur Eiriksson (12/29/2014)

---

dwain.c (12/28/2014)

---

I wanted to take a moment to wish all the forum members a (late) Merry Christmas and a Happy New Year.

I've been extremely busy of late so...

I wanted to take a moment to wish all the forum members a (late) Merry Christmas and a Happy New Year.

I've been extremely busy of late so have been of...