UFN_BATCH_GETLATESTCHILDBATCHID
This function returns the latest originating batch ID for a given batch.
Return
| Return Type |
|---|
| uniqueidentifier |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @BATCHID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_BATCH_GETLATESTCHILDBATCHID
(
@BATCHID uniqueidentifier
)
returns uniqueidentifier as
begin
declare @RESULT as uniqueidentifier;
select top 1
@RESULT = ID
from
dbo.BATCH
where
ORIGINATINGBATCHID = @BATCHID
order by
DATECHANGED desc;
return @RESULT;
end