[dbo].[usm_vw_link_offering

[dbo].[usm_vw_link_offering_ci]

(local) > mdb > Views > dbo.usm_vw_link_offering_ci

Properties
Columns
Permissions
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	11:19:34 AM Monday, December 13, 2010
Last Modified	11:19:34 AM Monday, December 13, 2010

Columns

Name
offering_id
ci_uuid_char
ci_uuid
status

Permissions

Type	Action	Owning Principal
Grant	Select	usmgroup

SQL Script

create view usm_vw_link_offering_ci as
select offering_id,sys.fn_varbintohexsubstring(1,ci_uuid,1,0) as ci_uuid_char,ci_uuid,status
from usm_link_offering_ci
GO
GRANT SELECT ON [dbo].[usm_vw_link_offering_ci] TO [usmgroup]
GO

Uses

[dbo].[usm_link_offering_ci]
dbo
[sys].[fn_varbintohexsubstring]