Viewing post 1 (of 1 total)
What about ...
select Product_ID
, MAX( case when CountryCode = 'USA' then AlternateProductID else null end ) AS USA
...
February 22, 2008 at 3:28 pm
#781294