I have to agree with Dan that YYYYMMDD as an integer is useful as a key for a date dimension in a data warehouse.

It also happens to be a...

I think you need to convert the grand open date to a date value and compare it to the system date. If you have Excel installed on the server you...

I think you can get rid of that old connection by right clicking, choosing Add Connection, and selecting the old connection from the list of existing connections. Now delete the...