This content has been marked as final. Show 3 replies
Well, you could either put the CASE statement in the checksum parameter as well (duplicating logic = bad) or use a factored subquery with the case statment in and alias that column, then reference it in the main query (logic in one place = good).1 person found this helpful
Could you give me an example please. I tried putting a case in the checksum, but to no avail
Edited by: Gus C on Feb 5, 2013 4:18 AM
I have closed this thread because I think my problem lies elsewhere.
I will open a new thread.