sarwaanmca (1/23/2013)
1)Mnth Column Should be Not Null
Add in procedure
IF isnull(@Mnth , '') = ''
RETURN
sarwaanmca (1/23/2013)
The DCPI_Date Field Should be 101 Format ie, (MMDDYYYY)
Use CONVERT function to set its format to 101
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)