Views [dbo].[e2e_wrm_wrmreporttranreqmnotroll]
(local) > mdb > Views > dbo.e2e_wrm_wrmreporttranreqmnotroll
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created11:10:13 AM Wednesday, March 07, 2007
Last Modified11:10:13 AM Wednesday, March 07, 2007
Columns
Name
sourceid
transactionid
y
requestnameid
Permissions
TypeActionOwning Principal
GrantSelectapmadmin
SQL Script

create view "e2e_wrm_wrmreporttranreqmnotroll" AS
       SELECT "e2e_wrm_wrmreport"."sourceid", "e2e_wrm_wrmreport"."transactionid", DATEPART([year], timestart) AS y, "e2e_wrm_wrmreport"."requestnameid"
       FROM "e2e_wrm_wrmreport"
       WHERE (timefactor = 4) AND (issent = 0 OR issent IS NULL) AND (typeid = 4)
       GROUP BY sourceid, transactionid, DATEPART([year], timestart), requestnameid


GO
GRANT SELECT ON  [dbo].[e2e_wrm_wrmreporttranreqmnotroll] TO [apmadmin]
GO
Uses
Used By
Created 03 June 2010 08:02
Copyright 2010 by CA Technologies, Inc. - All Rights Reserved