Just installed MS SQL on a Guest VM (Linux).

This is nuts...I can't help but smile how cool this is. Not quite ready for primetime as certain key services are...

Absolutely, but could you provide some sample data. I'd prefer to be able to verify any code is working as intended before tossing it out there.

Cheers,

Mutants

Ed Wagner (11/15/2016)

---

Y.B. (11/15/2016)

---

Hey Brandie, cheddar is not better!! LOL (it's all personal preference of course)

That being said I did recently try an Irish Cheddar which was excellent. ...

Hey Brandie, cheddar is not better!! LOL (it's all personal preference of course)

That being said I did recently try an Irish Cheddar which was excellent. I like something...

Awesome! I do...

Ed Wagner (11/15/2016)

---

Y.B. (11/15/2016)

---

My wife and I decided to check out some Mayan ruins near one of our ports of call during our cruise. I wasn't sure what to...

My wife and I decided to check out some Mayan ruins near one of our ports of call during our cruise. I wasn't sure what to expect other than...

Swiss

Mr

Just expanding on what Phil said, this can be done quite easily with a LEFT JOIN.

DECLARE @months TABLE ([month] VARCHAR(12))

INSERT INTO @months

VALUES ('January'), ('February'), ('March'), ('April'), ('May'), ('June'), ('July'), ('August'),...

I'm not 100% sure what you are looking for but It would seem that DATEPART would be your friend as it appears you are trying to grab the year and...

Jeff Moden (10/17/2016)

---

PearlJammer1 (10/17/2016)

---

Hi Jeff

It is because we have a situation where some tables appear to have id values less than the current identity value which will get auto generated...

Unit

sp_readerrorlog uses the extended procedure xp_readerrorlog which allows parameters for start and end dates.

EXEC xp_readerrorlog 0, 1, 'pegasus', '-', '2016-10-13', '2016-10-14'