I am trying to run a bloack of code...but getting the following error:
Msg 229, Level 14, State 5, Line 32
The EXECUTE permission was denied on the object 'DateOnly', database 'WSD', schema 'dbo'.
Msg 208, Level 16, State 0, Line 55
Invalid object name '#ShoeTotalsUser'.
does this mean that I dont have access to the DB to run the EXECUTE
2) #ShoeTotalsUser is a temp table or a view and when the system runs this inside a sproc runs fine, im trying to run locally but now this issue...how do I view this?