Viewing 6 posts - 16 through 21 (of 21 total)
I'm confused by your expected results.
You said you want to get the "latest status as of April 1, 2012." And state that you would expect ConsumerID 101 to be...
March 8, 2013 at 1:18 pm
GilaMonster (3/6/2013)
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
Thanks for that. Sounds like a good term for it to me.
March 6, 2013 at 2:26 pm
Just realized the inner case statement was over complicated and I had a WHEN that could never be satisfied..
revised:
CREATE FUNCTION dbo.itvf_BankersRound(@Num decimal(38,9))
RETURNS TABLE
AS
RETURN
(
SELECT
CASE
WHEN
ROUND(@Num, 2) - @Num = .005
AND...
April 13, 2012 at 9:30 am
Here's what I came up with. Granted I made a pretty sweeping assumption (always rounding to hundredths), but that was the business case I was working with. It...
April 12, 2012 at 5:26 pm
Thanks LutzM, I'll have to check out the quirky update.
I did come up with a solution that seems to work also (Props to LutzM for the idea of counting the...
April 11, 2012 at 9:27 am
LutzM (4/6/2012)
The problem is there's nothing in the data that would allow to define "the full combination of individual vaccines that makes up a completed MMR vaccine".Can you please elaborate?
Sure...
April 6, 2012 at 1:49 pm
Viewing 6 posts - 16 through 21 (of 21 total)