I mean a calendar table that stores the dates and relevant information.

Stefan Krzywicki (10/30/2014)

---

Just found out through personal experience that Citi bank recycles user IDs.

Makes me a little uncomfortable.

Also found out the hard way that they lost registration data "when moving...

How did you convert them?

You are trying to append a date to a string.

... where convert(datetime, ''10/08/2014'', 101) ' + @startdate + 'between' + @enddate + ') ...

Convert @startdate and @enddate to strings first.

BTW,...

Your question is too vague to be answered.

Explain your scenario, what you want to...

It seems you already have a thread going on.

Please do not post duplicate threads. It will fragment replies and waste peoples time.

Where do you see this? As...

pharmkittie (10/29/2014)

---

Thanks for your help. I worried about the Visual Studio versions with respect to SSRS than the database versions. Usually SSRS availability lags after a new version...

gravitysucks (10/29/2014)

---

Koen Verbeeck (10/29/2014)

---

The easiest way (in my opinion) is to create two environments. Each environment has the same environment variable, but with a different value. In the catalog, the...

Did you try SUBSTRING?

Did you read the book?

1. Normally the installation should work side-by-side. (I have VS 2010 / 2012 / 2013 on my machine) But it is MS software. There can always go something wrong...

2. Correct....

Do you have a date table in your database or data warehouse?

You need to escape single quotes with another single quote.

An example:

SELECT 'This string will escape ''this other string''.'

Instead of using ' for your aliases, you could also use square brackets....

The layout has changed, but the way SSIS works is largely the same.

The biggest changes...