Not sure were to upload the file on SSC, but find below

--TEST--

SET NOCOUNT ON

if exists (select * from sys.objects where object_id = object_id('DirListingTEST')

and OBJECTPROPERTY(object_id, N'IsUserTable') = 1) Drop Table DirListingTEST

if...

Thx, I have a solution

No variable, yes the file is generated and stored on a folder

Thanks a lot:-)

on the very same server, without changing the startup parameters it works ok, c attached

Now i'm not sure why

Hi

Tested it on the other and starts fine whether systems 32 folder or binn folder

Thanks All for assistance

Thanks

What about a new ip address and service accounts, as currently running two nodes that are active

Thx

It's production the db hasnt been restored

Thanks for your help, i will try the solution in the morning.

😀

Please bear with me, so i'm selecting data from the developer table with incorrect data type inserting data to a table with correct data types. So how do i incorporate...

Thanks, it's just that the developer created the table with varchar type.

Thanks once more, will try the solution.

Great article Craig, just to acknowledge your work i also modified the reports to include a graph to get a quick glance before scanning the report to check for failed...

Thanks for your response the below expression worked with formating the cell in SSRS table to show % sign.

=Sum(Fields!SLA_Missed.Value)/(Sum(Fields!SLA_Achieved.Value) + Sum(Fields!SLA_Missed.Value))

=Sum(Fields!SLA_Achieved.Value)/(Sum(Fields!SLA_Achieved.Value) + Sum(Fields!SLA_Missed.Value))

Thanks