create view "e2e_wrm_wrmreporttranwnotrollv" AS
       SELECT "e2e_wrm_wrmreport"."sourceid", "e2e_wrm_wrmreport"."transactionid",
       DATEADD([Hour], (1 - DATEPART(weekday, timestart)) * 24, timestart) AS w, "e2e_wrm_wrmreport"."identifierid", "e2e_wrm_wrmreport"."typeid"
       FROM "e2e_wrm_wrmreport"
       WHERE (timefactor = 2) AND (issent = 0 OR issent IS NULL) AND (typeid = 3 OR typeid = 4)
       GROUP BY sourceid, transactionid, DATEADD([Hour], (1 - DATEPART(weekday, timestart)) * 24, timestart), identifierid, typeid


GO
GRANT SELECT ON  [dbo].[e2e_wrm_wrmreporttranwnotrollv] TO [apmadmin]
GO