I'm trying to write my first ever stored procedure and I get an invalid obect name 'dbo.spRPT.rptSLR_Imprt_LC' when I try to run it. I have pasted my stored procedure below. What am I missing???
if exists (select * from sysobjects where id = object_id('dbo.spRPT_rptSLR_Imprt_LC') and sysstat & 0xf = 4)
drop procedure dbo.spRPT_rptSLR_Imprt_LC
GO
CREATE PROCEDURE spRPT_rptSLR_Imprt_LC
@sBeginDate char(8),
@sEndDate char(8)
AS
DECLARE
@dtBeginDate smalldatetime,
@dtEndDate smalldatetime
SELECT refno = main.refno,
amt = main.amt,
applicant = main.applicant,
acctparty_mnem = main.acctparty_mnem,
Date_Entered = main.DateEntered,
Date_Issued = (SELECT MIN(logtime) FROM LOC_IBSWIN..mleventlog mleventlog
WHERE mleventlog.refno = main.refno
AND eventname = 'ISSAPPL'),
user_name = ISNULL(main.user_name, '<Not Entered>'),
userid = main.userid
FROM
(SELECT DISTINCT
refno = lc.refno,
amt = lc.amt,
applicant = lc.applicant,
acctparty_mnem = lc.acctparty_mnem,
DateEntered = internal.scf_rcd_dt,
user_name = ISNULL(usertable.user_name, '<Not Entered>'),
userid = mleventlog.userid
FROM
LOC_IBSWIN..lc lc INNER JOIN LOC_IBSWIN..internal internal ON lc.refno = internal.refno
INNER JOIN LOC_IBSWIN..mleventlog mleventlog ON internal.refno = mleventlog.refno
INNER JOIN LOC_IBSWIN..usertable usertable ON mleventlog.userid = usertable.user_id
WHERE
mleventlog.eventname = 'ISSENTL'
AND mleventlog.refno IN(SELECT DISTINCT refno
FROM LOC_IBSWIN..mleventlog mleventlog
WHERE (refno LIKE 'INO%' OR refno LIKE 'IGT%')
AND eventname = 'ISSAPPL'
AND logtime >= @dtBeginDate
AND logtime <= @dtEndDate)) main
ORDER BY userid
GO
GRANT EXECUTE ON dbo.spRPT_rptSLR_Imprt_LC TO public
GO
GRANT EXECUTE ON dbo.spRPT_rptSLR_Imprt_LC TO IBSREPORT
GO
GRANT EXECUTE ON dbo.spRPT_rptSLR_Imprt_LC TO IBSUSER
GO