Viewing 3 posts - 1 through 4 (of 4 total)
I am so happy right now. Thanks so very much to both/all of you. My brain is no longer stuck in a do loop. I appreciate the help!!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The only difference between impossible and possible is time...and a little help from my friends.
May 23, 2011 at 10:33 am
Wow, thanks. Yes, you understand it perfectly. It would be the 2nd version (I think) - for IDs 1 through 7, it would be 7 days positive (YES) result. For...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The only difference between impossible and possible is time...and a little help from my friends.
May 20, 2011 at 3:00 pm
I think you need this?
UPDATE {TABLE}
SET {COLUMN1}=CASE WHEN {COLUMN1} IS NULL THEN {something something}
END
Repeat case statement for all applicable columns
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The only difference between impossible and possible is time...and a little help from my friends.
May 20, 2011 at 10:57 am
Viewing 3 posts - 1 through 4 (of 4 total)