November 3, 2011 at 7:36 am
You may be able to use the ISNULL function to just clean the data temporarily before pivoting:
http://msdn.microsoft.com/en-us/library/ms184325.aspx
_________________________________
seth delconte
http://sqlkeys.com
November 4, 2011 at 6:41 am
How are you doing your pivot transformation?
you could just select the following from your results.
select
customer_id,
max(new_address) as new_address,
max(new_city) as new_city
from [yourtable]
group by
customer_id
November 7, 2011 at 5:56 am
I tried the pivot transformation in two ways, initially with a query using a case statement, then using the pivot transformation in SSIS. Both produced the same result.
I'll look at putting the results into a staging table and then using the select query that you suggested.
I'll keep you posted!
Viewing 3 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply