yes - once deployed, the report is deployed with the defaults you specify the first time.

If you delete the report and re-deploy with the new defaults you should find all...

This URL may help in making the decision: http://databases.about.com/od/sqlserver/a/mssql_editions.htm

It might be "overkill" for your scenario but if you use projects to store your .sql files, you can specify the connection in the solution.

You could then have separate solutions...

The problem is the colour "Dark Blue" - it does not exist.

However "DarkBlue" does!

:w00t:

gsc_dba (6/27/2011)

---

Try this - uncomment the exec mail for each for testing...

USE [AdventureWorks]

DECLARE @tableHTML NVARCHAR(MAX) ;

DECLARE @varCheck BIT

IF EXISTS ( SELECT *

...

Oh and if you double click the .ssmssln file it opens SSMS and all the associated queries...

😀

This may help

http://msdn.microsoft.com/en-us/library/ms187953.aspx

The scope of a variable is the range of Transact-SQL statements that can reference the variable. The scope of a variable lasts from the point it is declared...

I find it useful to store all queries and connections for an upgrade coupled with source control

How/what did you name your instances...?

For example the default is MSSQLSERVER (i think!) - I named my instances after the version, so MSSQL2008R2, MSSQLDENALI, etc

Then in SSMS when choosing your...

Edit: As mentioned above - need a little more info to be able to help...

Can you elaborate on the table structures?

I think Dannol Liu somes it up quite well...

http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/196b4586-1338-434d-ba8c-49fa3c9bdeeb/

Edit - seems the link is forbidden so here is the content of his response:

As you might know that the collation decides...

Try the ISNULL function:

DECLARE @nullablecolumn INT = NULL

SELECT ISNULL(@nullablecolumn, 0)

Your welcome

🙂

You could also circumvent the @varCheck by setting the @tableHTML = your result set when exists = true

And set @tableHTML to be your "No data available..." when exists =...

Try this - uncomment the exec mail for each for testing...

USE [AdventureWorks]

DECLARE @tableHTML NVARCHAR(MAX) ;

DECLARE @varCheck BIT

IF EXISTS ( SELECT *

...