Jason Shadonix (8/19/2014)

---

I've been installing SQL with a unattended install for awhile, and have the following settings in my install_configuration.ini file. I happened to come across a password with...

Why so much extra work? No CTEs required:

create table dbo.DogBreeds (

DogBreed varchar(32)

);

insert into dbo.DogBreeds

values

('Boxer'),

('Boxer'),

...

CELKO (8/19/2014)

---

I'm working on setup where we have period like 201401 ( jan 2014), etc... And it is INTEGER , however it doesn't help if you need to...

mic.con87 (8/19/2014)

---

Its meant to be a combination of two months worth of data.

If an MSISDN is in both months then the final output would be:

Report_Month || MSISDN || SUB_SEGEMNT

201406 ||...

I get even more confused as I reread your posts and the sample tables and data you posted.

I'm not sure if what you posted matches your original post, and I...

mic.con87 (8/19/2014)

---

Its meant to be a combination of two months worth of data.

If an MSISDN is in both months then the final output would be:

Report_Month || MSISDN || SUB_SEGEMNT

201406 ||...

Steve Jones - SSC Editor (8/19/2014)

---

I've also set our "remove all posts by person xx" job to every 5 minutes, which will help.

Unfortunately, I really need some front end development...

Sean Lange (8/19/2014)

---

The amount of spam on this site is just out of control. Something needs to happen or our users are going to go elsewhere. I for one have...

I'm just keeping an eye on possible positions in Colorado Springs while I'm still out here in Afghanistan. Need to keep my fingers on the pulse of SQL Server...

SQLRNNR (8/19/2014)

---

Lynn Pettis (8/19/2014)

---

How about this one, starting monthly salary of $4,927 for a Senior Database Developer. That's 2/3 what I made at School District 11.

Granted, it is a...

How about this one, starting monthly salary of $4,927 for a Senior Database Developer. That's 2/3 what I made at School District 11.

Granted, it is a non-profit religious organization,...

Romo or Brady? Not sure which.

Eirikur Eiriksson (8/14/2014)

---

Luis Cazares (8/14/2014)

---

Grant Fritchey (8/14/2014)

---

Evil Kraig F (8/14/2014)

---

djj (8/14/2014)

---

Wish I could remember what last year was like, I remember some nice days for '77 as...

Evil Kraig F (8/14/2014)

---

djj (8/14/2014)

---

Wish I could remember what last year was like, I remember some nice days for '77 as I have a picture of me...

Jeff Moden (8/14/2014)

---

dwilliscp (8/14/2014)

---

Jeff Moden (8/13/2014)

---

Thanks, Lynn. I read the original post incorrectly and didn't run your code to see. Thanks for the correction.

I must admit, I'm totally...