Thats why I asked if there will only ever be two rows in the table on the first post.

If you have more than 1 set of values in the table,...

Take a look at Ola Hallengren's maintenance scripts (link in my signature) some great maintenance scripts on there including a good index rebuild script.

Even though the SSRS databases maybe on another server it could still be them causing the TempDB issue, especially if the reports use excessive sorting or #temp tables.

You can query...

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...