Hows what?

The CASE statement works out which colour to assign to the value based on the difference in dates, then you need to write your expression as we have done...

No thats in the dataset, then base your expression off the colourtouse column

SELECT

Col1,

Col2,

CASE DATEDIFF(DAY, proj.last.publication, GETDATE()) WHEN < 15 THEN 'Green' WHEN BETWEEN 15 AND 29 THEN 'Yellow' WHEN >= 30 THEN 'Red' END AS ColourToUse

Col3,

Col4

FROM

dbo.Table1

CREATE DATABASE

Wrap it in a case statement and if the value is between 15 and 30 then flag it as a value to mark which colour indicator to use.

Google it, I am unsure if it can be done.

Without data it is hard to trouble shoot, run the procedure with the parameters that where passed in and it should error at the same point, and then you can...

Something like the below

SELECT

DB1.ProjectName,

DB2.ProjectStage

FROM

Database1.dbo.Table1 DB1

INNER JOIN

Database2.dbo.Table2 DB2

ON

DB1.ProjectStageID = DB2.ProjectStageID

Without knowing your data schemas it is hard to say.

Pineapple

Looks like you need DATEDIFF functions, one tip do this in the SQL data set not the tablix and then base your expression on that columns

Something like below then based...

again unsure, never had to do it, would be worth a google and if it is possible let us know how.

Yes that will resolve the issue, also look at ALTER USER as if I remember correctly sp_change_users_login is scheduled for removal in a future version of SQL.

Find out what the job runs and debug it, could be SSIS packages, stored procs etc.

I believe that this is the latest, unsure if Steve has added any more since this

http://www.sqlservercentral.com/Forums/Topic935523-83-1.aspx

Not sure on that, you will need to build some sort of linking in 1 of the servers.

Something like using linked servers, or building a merged database of both DB's...