dd_CM00100_SEL_byActindx
This is a very simple stored procedure, but I thought I'd blog it because it might be useful in the future. We sometimes need to get the checkbook ID attached to an account index, this sproc will provide that.
IF EXISTS (SELECT name
FROM sysobjects
WHERE name = N'dd_CM00100_SEL_byActindx'
AND type = 'P')
DROP PROCEDURE dd_CM00100_SEL_byActindx
GO
CREATE PROCEDURE dd_CM00100_SEL_byActindx
-- dd_CM00100_SEL_byActindx 2413
@actindx int
AS
SET NOCOUNT ON
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
select CHEKBKID
from cm00100 cm
where actindx = @actindx