Excellent article. Well written, with good examples. Thanks.

I chose option 2 because not having an alias on that column is bad to me, however I agree that option 4 also "fixes" it, just not in an...

I once had a similar experience with Sharepoint, which was solved with this:

Make sure “automatically detect settings” is turned off in IE.

I don't know if it is the same problem...

A warning:

if you have a column set defined on the table, and the column you are checking is part of that column set, then it will never be the only...

Let's just confirm this is a local temporary table, with one #, not a global with two ## ?

I see two choices.

1. It is April 1st.

2. You win the prize for worst query ever.

AdrSHL (3/31/2015)

---

mister.magoo (3/31/2015)

---

If this is copying and pasting one cell from SSMS to one cell in Excel, then make sure you are in edit mode in Excel before pasting, either...

If this is copying and pasting one cell from SSMS to one cell in Excel, then make sure you are in edit mode in Excel before pasting, either by pressing...

Thanks for an interesting read, sometimes it's worth revisiting those ideas that you have put aside just in case you see a new angle on them.

I just wish you hadn't...

Ed Wagner (3/30/2015)

---

Jeff Moden (3/29/2015)

---

I'll have to disagree with that. To me, an empty string or the number 0 is nothing....

Glad you got it working - it takes some people quite a while to get to grips with it, especially figuring out the required naming in WCM.

The next pain you...

I don't use runas /netonly any more for that reason (and I hate typing passwords), so now I store the credentials in the Windows Credential Manager and just run SSMS...

use a query to provide available values.

Something like

select thedate from dates where thedate>=dateadd(day,-60,getdate())

ChrisM@Work (3/26/2015)

---

Phil Parkin (3/26/2015)

---

dwain.c (3/26/2015)

---

Gary Varga (3/26/2015)

---

dwain.c (3/25/2015)

---

...I beginning to think that when I wrote this article (based on a quotation from Jeff):

Make it Work, Make it Fast, Make it...

Try these if you like...

First Monday of previous month:

= DateAdd(DateInterval.Day, (8 - DatePart(Dateinterval.Weekday,DateAdd(DateInterval.Month, - 1, DateValue(Format(today, "MMM yyyy"))),firstdayofweek.Monday)) Mod 7, DateAdd(DateInterval.Month, - 1, DateValue(Format(today, "MMM yyyy"))))

And Sunday before first Monday...