I think we should spring forward a half an hour this year, then we never change the clocks again.  Get the best of both worlds. IMHO 🙂

We use SSIS for all of our ETL.  I would prefer that SSIS be used more for EL and not (T)ransform.  Setting up the SSIS to Extract and Load the...

If I was going to use the STUFF I would want to make sure the field was always the same length.  And since I may not always be able to...

SELECT original_value,
    CAST(ROUND(CONVERT(INT, original_value) / 10.0, 0) AS DECIMAL(9, 3)) AS decimalvalue
FROM (VALUES('0054880'), ('0054885'), ('02120'), ('00002124'), ('2125')) x(original_value)
;

Results:
original_value    decimalvalue
0054880     ...

Just to see how bad I get pounded for this code. This will give you any 'A' claim types where you don't have a 'P' or all 'P' that don't...

I can't believe the number of people hung up on February not always having the same last day.  Some simple SQL with get the correct date for you.
Not everyone...

I just don't get it.  Why if there is a field that will only contain the EOM date would I want to use that logic?
Why do this:
Where DateField...