set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

create PROCEDURE [dbo].[STPGetLastCheckOutDetailCode]
	@User int
AS
declare @LastDetailCode int
SELECT     @LastDetailCode=MAX(CheckoutTBL.FK_DocSysCode)  
FROM         CheckoutTBL INNER JOIN
                      VWDocumentDetail_DocHeader ON CheckoutTBL.FK_DocSysCode = VWDocumentDetail_DocHeader.DetailCode INNER JOIN
                      DocTbl ON VWDocumentDetail_DocHeader.Fk_docSysCode = DocTbl.SysCode
WHERE     (DocTbl.UserIDNO = @user)
return @LastDetailCode