Viewing 15 posts - 316 through 330 (of 1,468 total)
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...
October 8, 2020 at 10:14 am
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...
October 8, 2020 at 9:32 am
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...
October 7, 2020 at 2:38 pm
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...
October 7, 2020 at 7:24 am
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...
October 6, 2020 at 4:45 pm
SELECT TableVariableTypeName = tt.name
, ColumnName = c.name
, ColumnNumber = c.column_id
, [DataType] ...
October 5, 2020 at 2:47 pm
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
October 2, 2020 at 11:27 am
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...
October 2, 2020 at 9:43 am
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...
October 1, 2020 at 5:19 pm
Using basic math substitution .....
-- Fee = Sell * FeeMargin
-- Nett = Sell - Cost - Fee
-- NettMargin = Nett / Cost
----------------------------------------------------------------------------------
-- NettMargin = ( Sell - Cost - Fee...
October 1, 2020 at 3:43 pm
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
,...
October 1, 2020 at 11:49 am
Looks like you just need to add an aggregate and group by
SELECT a.Internal_No
, a.TimeMode
...
September 30, 2020 at 9:34 am
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...
September 30, 2020 at 4:22 am
Thanks for the question Jeff.
For now we only have, 6x3,6x4,6x5 and 8x5 and 8x6.
So the MAX is F6 and F8 and the Z6 will not happen.
The number of times...
September 29, 2020 at 2:57 pm
Viewing 15 posts - 316 through 330 (of 1,468 total)