I am trying to pass dates in a stored procedure and keep getting an error - here is the code and error. eventually the sproc will be used in SSRS.
ALTER PROC [dbo].[USP_SPROC_X]
WHERE @DATE BETWEEN PRC_EFF_DT AND PRC_END_DT
Msg 4104, Level 16, State 1, Procedure [PROCNAME], Line 141
The multi-part identifier "PRC_EFF_DT" could not be bound.
View Complete Post