[dbo].[usm_vw_link_rateitem

[dbo].[usm_vw_link_rateitem_model]

(local) > mdb > Views > dbo.usm_vw_link_rateitem_model

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
rate_item_id
model_uuid
created_date
created_by_user_id

Permissions

Type	Action	Owning Principal
Grant	Select	usmgroup

SQL Script

create view usm_vw_link_rateitem_model as
select rate_item_id,
    sys.fn_varbintohexsubstring(1,usm_link_rateitem_model.model_uuid,1,0) as model_uuid,
    created_date,
    created_by_user_id
from usm_link_rateitem_model
GO
GRANT SELECT ON  [dbo].[usm_vw_link_rateitem_model] TO [usmgroup]
GO

Uses

[dbo].[usm_link_rateitem_model]
dbo
[sys].[fn_varbintohexsubstring]