Based on the latest sample data that you provided, this code works.

However, I fully expect that you will get other non-compliant records.

You can keep tweaking the code to the point...

Your downfall here is going to be trying to do it all at once.

You cannot touch the vendor DB, but there is nothing stopping you from creating your own staging...

That speaks to a record whose data does not match the pattern of data that was used for creating the solution at hand.

You will need to find the record(s) that...

That code will not work for a declared table variable.

It is for a table parameter as requested in the original post.

Also note that the code is looking for the declared...

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