Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT df.Dropouts, df.Failures, df.Submits, df.Success, dv.Visits FROM
- (SELECT [dbo].[Fact_FormStatisticsByContact].[FormId] AS FormId,
- SUM([dbo].[Fact_FormStatisticsByContact].[Submits]) AS Submits, SUM([dbo].[Fact_FormStatisticsByContact].[Failures]) AS Failures,
- SUM([dbo].[Fact_FormStatisticsByContact].[Dropouts]) AS Dropouts, SUM([dbo].[Fact_FormStatisticsByContact].[Success]) AS Success
- FROM [dbo].[Fact_FormStatisticsByContact] WHERE [dbo].[Fact_FormStatisticsByContact].[FormId] = @FormId
- group by [dbo].[Fact_FormStatisticsByContact].[FormId]) df INNER JOIN
- (SELECT Count(distinct [dbo].[Fact_FormEvents].[InteractionId]) AS Visits,
- [dbo].[Fact_FormEvents].[FormId] AS FormId
- FROM [dbo].[Fact_FormEvents]
- WHERE FormId = @FormId
- GROUP BY [dbo].[Fact_FormEvents].[FormId] ) dv ON df.FormId = dv.FormId
Add Comment
Please, Sign In to add comment