Guest User

Untitled

a guest
Jul 22nd, 2018
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.81 KB | None | 0 0
  1. SELECT df.Dropouts, df.Failures, df.Submits, df.Success, dv.Visits FROM
  2. (SELECT [dbo].[Fact_FormStatisticsByContact].[FormId] AS FormId,
  3. SUM([dbo].[Fact_FormStatisticsByContact].[Submits]) AS Submits, SUM([dbo].[Fact_FormStatisticsByContact].[Failures]) AS Failures,
  4. SUM([dbo].[Fact_FormStatisticsByContact].[Dropouts]) AS Dropouts, SUM([dbo].[Fact_FormStatisticsByContact].[Success]) AS Success
  5. FROM [dbo].[Fact_FormStatisticsByContact] WHERE [dbo].[Fact_FormStatisticsByContact].[FormId] = @FormId
  6. group by [dbo].[Fact_FormStatisticsByContact].[FormId]) df INNER JOIN
  7.  
  8. (SELECT Count(distinct [dbo].[Fact_FormEvents].[InteractionId]) AS Visits,
  9. [dbo].[Fact_FormEvents].[FormId] AS FormId
  10. FROM [dbo].[Fact_FormEvents]
  11. WHERE FormId = @FormId
  12. GROUP BY [dbo].[Fact_FormEvents].[FormId] ) dv ON df.FormId = dv.FormId
Add Comment
Please, Sign In to add comment