fnGetActiveSiteCopy
Return
| Return Type |
|---|
| int |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ClientSitesID | int | IN |
Definition
Copy
CREATE FUNCTION [dbo].[fnGetActiveSiteCopy]
(
@ClientSitesID int
)
RETURNS int
AS
BEGIN
DECLARE @Status int
select top 1 @Status = [status]
from SiteCopy where TargetClientSitesID = @ClientSitesID ORDER BY CreateDate DESC
return isnull(@Status,-1)
END