Something like this?

with TestData as (

select memid, MonthStartDate

from

(values

(123,'2014-01-01'),

(123,'2014-03-01'),

(123,'2014-04-01'),

(123,'2014-05-01'),

(123,'2014-06-01'),

(123,'2014-07-01'),

(123,'2014-08-01'),

(123,'2014-09-01'),

(123,'2014-10-01'),

(123,'2014-11-01'),

(123,'2014-12-01'),

(222,'2014-01-01'),

(222,'2014-02-01'),

(222,'2014-03-01'),

(222,'2014-04-01'),

(222,'2014-05-01'),

(222,'2014-06-01'),

(222,'2014-07-01'),

(222,'2014-08-01'),

(222,'2014-09-01'),

(222,'2014-10-01'),

(222,'2014-11-01'),

(223,'2014-02-01'),

(223,'2014-03-01'),

(223,'2014-04-01'),

(223,'2014-05-01'),

(223,'2014-06-01'),

(223,'2014-07-01'),

(223,'2014-08-01'),

(223,'2014-09-01'),

(223,'2014-10-01'),

(223,'2014-11-01'),

(223,'2014-12-01'))dt(memid,MonthStartDate)),

BaseData as (

SELECT

*,

rn = row_number() over (partition by memid order by MonthStartDate)

FROM

...

Jack Corbett (8/11/2015)

---

Sean Lange (8/11/2015)

---

OMG. I just ran across this in a database from a 3rd party. There are actually 50 nvarchar(1) columns with names 1 - 50....

Personally, I'd start with something like this and modify it as needed:

declare @BatchSize int = 5000, -- change as desired

@ArchiveDate DateTime =...

FYI, the NULL in this INSERT is NOT a null. It is a string whose value is the string...

Also, is the string 'Null' a real Null or a string?

Based on the above sample data, what is the expected results?

As I stated, it worked for what you provided. ...

And Silver Spoon is definitely one of them.

lcarrethers (8/10/2015)

---

CREATE TABLE test

(

createdon datetime,

kms_quoteorder varchar(15)

)

INSERT INTO test VALUES ('2015-07-22 16:13:39.000','15-37779/Rev7')

INSERT INTO test VALUES ('2015-07-22 19:54:56.000','15-37779/Rev8')

INSERT INTO test VALUES ('2015-07-22 20:26:41.000','15-35553/Rev9')

INSERT INTO test VALUES ('2015-07-22 21:32:31.000','15-35553/Rev10')

select * from test

So...

bherbert (8/10/2015)

---

So, I've got this query running and it works great providing there is a record in both DataBases. Now, I need to get all of those that have...

sgmunson (8/10/2015)

---

Luis Cazares (8/10/2015)

---

Please don't use a recursive CTE to generate a calendar table as it's only a way of hidden RBAR. You can read more about this on this...

?? Start with 48, take one down,...

delizat (8/10/2015)

---

Lynn Pettis (8/7/2015)

---

Please tell me you aren't updating...

I don't see an 11.2.??.???? on the...

Please tell me you aren't updating statistics on indexes...