I have attached a sample report based on your initial data which colours the indicator in Red due to the value it calculates.

As this is for an interview question/answer, I recommend that you do the research and come back with potential answers to the question and then the great people here can...

You have brackets around the expression, they arn't needed on that line.

Quickest way is to restart the SQL service which will create a blank TempDB when it restarts.

What is the problem you are facing?

Logical query processing order "should" of removed all the invalid dates as the joins are processed before the where clause, so if the joins did remove all dates which cannot...

or as I detailed get a copy of RSScriptor

Backup in what format?

You can copy the RDL from report manager into an RDL format

You can backup the ReportServer database

You can use RSScriptor to script out all objects from reporting...

=SWITCH

(

LAST(Fields!Value.Value, "DataSet1") = 0, 0,

FIRST(Fields!Value.Value, "DataSet1") >= LAST(Fields!Value.Value, "DataSet1"), 3,

(FIRST(Fields!Value.Value, "DataSet1") / LAST(Fields!Value.Value, "DataSet1")) >= 0.7, 2

(FIRST(Fields!Value.Value, "DataSet1") / LAST(Fields!Value.Value, "DataSet1")) < 0.7, 1

)

You should just need to substitute the...

If the year was 1753 it should process fine, which is why I wanted to know the min and max date from the result set as it would seem its...

Try this instead

missed a few , and " out

=SWITCH

(

LAST(Fields!Value.Value, "DataSet1") = 0, "White",

FIRST(Fields!Value.Value, "DataSet1") >= LAST(Fields!Value.Value, "DataSet1"), "Green",

(FIRST(Fields!Value.Value, "DataSet1") / LAST(Fields!Value.Value, "DataSet1")) >= 0.7, "Yellow",

(FIRST(Fields!Value.Value, "DataSet1") / LAST(Fields!Value.Value, "DataSet1")) <...

What are the two values returned by this

SELECT

MIN(U.START_DATE),

MAX(U.START_DATE)

FROM

CSMADM.dbo.USAGES U

INNER JOIN CSMAUAT_MSCRM.dbo.Account A

on CONVERT(VARCHAR(12),U.MEM_MEMBER_NO) = A.AccountNumber

INNER JOIN CSMAUAT_MSCRM.dbo.Product P

on convert(varchar(10),U.SPT_PRO_PRODUCT_CODE) = P.ProductNumber

How are you opening the CSV file after exported with the " character?

Via Excel, notepad etc?

If Excel it automatically removes the " as it knows its a text qualifier, open...

Appreciate that this may seem like a silly question, but you are running the procedure on the SQL 2000 server not the new server

Also you are running this version of...

Looks fine to me

What is the output of the below

SELECT

DISTINCT

YEAR(U.START_DATE)

FROM

CSMADM.dbo.USAGES U