from your local machine, login as that user, then run a command line tool called SQLCMD passing in the parameters needed along with your create database statement.

I dont know, never used lookup in SSRS, try it out and see.

unless you have found a way to link datasets together or have used cross database joining in the data set no.

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.