UFN_SITEID_MAPFROM_STEWARDSHIPPLANTEMPLATEID
Maps a Stewardship Plan Template to multiple Sites
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @STEWARDSHIPPLANTEMPLATEID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_SITEID_MAPFROM_STEWARDSHIPPLANTEMPLATEID(@STEWARDSHIPPLANTEMPLATEID uniqueidentifier)
returns table
as
return
select TEMPLATESITE.SITEID
from dbo.STEWARDSHIPPLANTEMPLATE [TEMPLATE]
left outer join dbo.STEWARDSHIPPLANTEMPLATESITE [TEMPLATESITE] on TEMPLATESITE.STEWARDSHIPPLANTEMPLATEID = TEMPLATE.ID
where TEMPLATE.ID = @STEWARDSHIPPLANTEMPLATEID;