Viewing 15 posts - 436 through 450 (of 844 total)
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 travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
March 8, 2018 at 7:30 am
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...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
February 21, 2018 at 7:17 am
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...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
February 16, 2018 at 1:16 pm
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
February 16, 2018 at 11:38 am
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
February 16, 2018 at 10:33 am
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 ...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
February 16, 2018 at 9:20 am
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...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
January 25, 2018 at 3:12 pm
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
January 25, 2018 at 10:24 am
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
January 25, 2018 at 10:17 am
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...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
January 25, 2018 at 8:03 am
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...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
January 24, 2018 at 2:56 pm
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
January 24, 2018 at 9:59 am
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
January 24, 2018 at 6:54 am
Just for S and G's I thought I'd throw in a solution. sorry for...
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
January 23, 2018 at 3:33 pm
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.
January 23, 2018 at 8:30 am
Viewing 15 posts - 436 through 450 (of 844 total)