Oops.  I think I hit REPORT instead of QUOTE.

Using NOLOCK everywhere for performance means that your reports are most likely incorrect.  How can business be expected to make informed decisions...

SELECT TableVariableTypeName = tt.name
     , ColumnName = c.name
     , ColumnNumber = c.column_id
    , [DataType]  ...

So, why not copy the original data to your own table in your own DB, then manipulate it from there?

If you need to cast the value, then simply do it

Thank You Des,

That works well. Could i now use this hidden table with the results to then populate another table using SSIS? Would there be any issues with it...

Des,

That is spot on, worked wonderfully, so thanks.

One last thing, can i do a WHERE clause on the "BookingDate" field to only show bookings for the last two hours?

I...

Using basic math substitution .....

-- Fee = Sell * FeeMargin

-- Nett = Sell - Cost - Fee

-- NettMargin = Nett / Cost

----------------------------------------------------------------------------------

-- NettMargin = ( Sell - Cost - Fee...

            
October 1, 2020 at 3:34 pm
            
#3792284

            
            
                                                
        

Look for defining characters, and split the string by those characters

DECLARE @OriginalColumn varchar(50) = 'Booked on: 20/03/2020 10:52 by: A1234567';

SELECT OriginalColumn = @OriginalColumn
    ,...

Looks like you just need to add an aggregate and group by

SELECT    a.Internal_No
        , a.TimeMode
  ...

This will give you only the marks that have not been used.  Use the ORDER BY to get them in order.  If there is nothing returned, then the box is...

The number of times...

If I understand your requirements correctly, something like this should work

First create some data

DECLARE @StartDate date = '2020-04-01'
      , @EndDate  ...

According to your table structure, there is no index on [MULE_BATCH_ID].  This means that SQL has to do a table scan to find the record.

You are doing a select *,...

Firstly, you cannot compare anything to null.  Run this code as proof.

IF ( NULL > NULL ) PRINT 'NULL > NULL' ELSE PRINT 'CANNOT COMPARE NULL >...

Without anything to test against, I would guess at a solution similar to this

WITH cteMaxTime AS (
  SELECT      pr.plan_id, maxTime =...