Just a simple look at what is asked:

/*

Country Address2 Resulting Column

Australia Sydney Australia Sydney

USA Washington USA Washington

United Kingdom London United Kingdom London

*/

create table dbo.Addresses (

Address2...

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

Just registered for PASS 2015.

[font="Arial Black"]Happy New Year from far off Afghanistan!!![/font]

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

veloopity (12/30/2014)

---

Msg 242, Level 16, State 3, Line 1

The conversion of a char data type to a datetime data type resulted...

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

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

Jeff Moden (12/28/2014)

---

Lynn Pettis (12/28/2014)

---

Okay, I have read the OPs posts and I am slightly confused at what he is attempting to accomplish. I get the idea that the...

Okay, I have read the OPs posts and I am slightly confused at what he is attempting to accomplish. I get the idea that the OP wants the column...

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

I am not actually complaining but I...

I am curious how 2004/08/28 - 2004/08/24 = 4 and 2004/08/31 - 2004/08/31 = 1. Seems to me the result of the first should be 5 OR the result...

GilaMonster (12/27/2014)

---

Grant Fritchey (12/27/2014)

---

Lynn Pettis (12/23/2014)

---

Okay, I have a question about PASS 2015. I can save a lot of money by registering for PASS 2015 now. My question...

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