SELECT MAX([Version])
FROM DeployDtl AS a JOIN DeployLog AS b ON a.DeployID = b.DeployID
WHERE a.ObjectName = @ObjectName
AND a.[Version] < (SELECT MAX(Version) FROM DeployDtl FROM DeployDtl AS a JOIN DeployLog AS b ON a.DeployID = b.DeployID
WHERE a.ObjectName = @ObjectName
WHERE DeployID = @DeployID AND ObjectName = @ObjectName)
'IT > MS-SQL' 카테고리의 다른 글
SP 실행 권한 문제 (0) | 2011.03.08 |
---|---|
MSSQL 단축키 (0) | 2011.03.02 |
내부 프로시저 실행시킬 때 EXECUTE 주의점 (0) | 2011.02.28 |
MSSQL Cursor in Stored Procedure (0) | 2011.02.22 |
MSSQL 특정 단어가 포함된 프로시저 찾기 (0) | 2011.02.22 |