fnLastModifiedDate
Return
| Return Type |
|---|
| datetime |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ObjectGuid | uniqueidentifier | IN |
Definition
Copy
CREATE FUNCTION fnLastModifiedDate
(
@ObjectGuid uniqueIdentifier
)
RETURNS datetime AS
begin
declare @dte datetime
SELECT top 1 @dte=AuditDate
FROM Audits
WHERE ObjectGuid=@ObjectGuid and (AuditCodesID=1 or AuditCodesID=2)
Order by AuditDate DESC
return @dte
end