we are not sure what exactly you are looking for?

declare one temp table and then insert the data which u r selecting

insert into @temp

(

name,

LastSuccessfulBackup,

IntervalInDays

)

SELECT a.name, b.type, MAX(b.backup_finish_date) LastSuccessfulBackup,

CAST((GETDATE() - MAX(b.backup_finish_date)) AS NUMERIC(5, 2)) IntervalInDays

FROM master..sysdatabases a

LEFT...

instead of having multiple if blocks, can't you use switch statements?

try case statement

CASE

WHEN Fields!A.Value = "Y" THEN sum(Fields!B.Value)

ELSE 0

END

Try this.

DECLARE

@ta VARCHAR(MAX) = '107.3'

SELECT SUBSTRING(@ta,0,CHARINDEX('.',@ta,0)) + SUBSTRING(@ta,CHARINDEX('.',@ta,0) + 1,LEN(@ta))

can you provide more details? or a sample code?

containing output scenario based on the inputs.

Please check now my post and let me know if its clear...

Thanks for your reply