You would need to build a check in that anything which is 0 is set to 1 when doing the divide.

Something like

CASE WHEN col = 0 THEN 1 ELSE...

Phil

What should the output based on the current test data look like

EG

ManufacturingOrderIdSomeColumnProductIdProcessNameQuantity

MO01508111-FAU440AASSEMBLY60.00000

MO01508121-FAU440AASSEMBLY75.00000

MO01508111-FAU440AASSEMBLY255.00000

MO01508111-FAU440AASSEMBLY330.00000

MO01508111-FAU440AINSPECTION30.00000

MO01508111-FAU440ATEST60.00000

MO02114311-FAU440AASSEMBLY30.00000

MO02114321-FAU440AASSEMBLY45.00000

MO02114311-FAU440AASSEMBLY105.00000

MO02114311-FAU440AASSEMBLY360.00000

MO02114311-FAU440AASSEMBLY495.00000

MO02114311-FAU440AINSPECTION45.00000

MO02114311-FAU440AINSPECTION105.00000

MO02114311-FAU440ASTORES/DISPATCH240.00000

MO02114321-FAU440ATEST60.00000

MO02114311-FAU440ATEST195.00000

MO02114311-FAU440ATEST300.00000

MO02261621-FAU440AASSEMBLY30.00000

MO02261611-FAU440AASSEMBLY60.00000

MO02261611-FAU440AASSEMBLY240.00000

MO02261611-FAU440AASSEMBLY360.00000

MO02261611-FAU440AASSEMBLY495.00000

MO02261611-FAU440ASTORES/DISPATCH360.00000

MO02261611-FAU440ATEST30.00000

MO02261611-FAU440ATEST435.00000

MO02429711-FAU440AASSEMBLY120.00000

MO02429711-FAU440AASSEMBLY255.00000

MO02429711-FAU440AASSEMBLY405.00000

MO02429711-FAU440AINSPECTION45.00000

MO02429711-FAU440ASTORES/DISPATCH330.00000

MO02429711-FAU440ATEST15.00000

MO02429721-FAU440ATEST30.00000

MO02429721-FAU440ATEST180.00000

MO02429711-FAU440ATEST255.00000

MO02429711-FAU440ATEST270.00000

MO02483911-FAU440BINSPECTION15.00000

MO02483911-FAU440BTEST180.00000

MO02483911-FAU440BTEST195.00000

MO02484611-FAU440BASSEMBLY90.00000

MO02484611-FAU440BINSPECTION15.00000

MO02484611-FAU440BTEST120.00000

MO02484611-FAU440BTEST180.00000

MO02507011-FAU440BASSEMBLY15.00000

MO02507011-FAU440BASSEMBLY60.00000

MO02507011-FAU440BINSPECTION30.00000

MO02507011-FAU440BTEST30.00000

MO02507011-FAU440BTEST120.00000

MO02507011-FAU440BTEST240.00000

MO02520621-FAU440BASSEMBLY30.00000

MO02520611-FAU440BINSPECTION15.00000

MO02520611-FAU440BTEST45.00000

MO02520611-FAU440BTEST60.00000

MO02520611-FAU440BTEST105.00000

MO02520611-FAU440BTEST120.00000

MO02520611-FAU440BTEST240.00000

MO02520611-FAU440BTEST270.00000

MO02520611-FAU440BTEST375.00000

Hopefully it shall be.

Was in Leeds last night watching 65daysofstatic, so tomorrow will (hopefully) be a late awakening with flat pack furniture building for the babies room and beer.

Another one would be to add NT AUTHORITY\Authenticated Users

But either domain users or the above wont work if any of the folders and reports are set to not inherit...

Either add a report header or footer, or create user parameters and assign them the values as an expression, I have personally not done the user params so cannot confirm...

I have the alocohol for the weekend lined up, 2 bottles of Innis & Gunn's, 2 bottles of Moorhouse brewery's Pendle Witches Brew and 2 bottles of Hoegarden Rose.

ToString() is not a valid method for the variables, if you want to convert it to a string use CStr

=CStr(Globals!PageNumber)

It generally wont I have found, usually down to parallelism where one thread is wating for others to complete, in that case while it is a waiting thread, its not...

Yes you will see blank login names for the same SPID in a parallel query, due to a SPID is linked to 1 user and 1 user only, so in...

Expand processes and filter on wait type non blanks

No backups? Why not?

What is the output from the following command

DBCC CHECKDB <Database Name> WITH NO_INFOMSGS, ALL_ERRORMSGS

Have you checked your DNS servers to ensure that the IP on the name record match and there fore resolving correctly?

Define what you mean as difference?

Difference in schema?

Difference in data?

Difference in purpose?

My definition of a staging database is somewhere to temporarly load data into in an ETL process before loading...

Either find the missing transaction log backup or re-initialise logshipping from a full/diff backup depending on the database backup routines.

Yes it is normal for it to delete log files.

The issue you have is that something or someone has done a manual transaction log backup or deleted a trn file...