USE [RFWH]
GO
/****** Object:  View [dbo].[UNKNOWN_MIXED_SUMMARY_QUERY]    Script Date: 06/05/2008 14:50:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[UNKNOWN_MIXED_SUMMARY_QUERY]
AS
SELECT     PORTABLE_ID, USER_ID, TRANS_KEY, 
                      CASE WHEN MIXED_COUNT > UNKNOWN_COUNT THEN CASE WHEN MIXED_MODELS = 1 THEN MIXED_COUNT ELSE 0 END ELSE UNKNOWN_COUNT
                       END AS UNKNOWN_MIXED
FROM         dbo.STAGED_UNKNOWN_MIXED_QUERY