May 5, 2011 at 2:40 PM
Edited May 5, 2011 at 2:41 PM
John thanks for your quick response and assistance.
[FCS].[dbo].[WeeklySales] does not do an INSERT INTO ... EXECUTE but the SQLTest_WeeklySales does as you can see below:
-- This code is executed in SQLTest_WeeklySales stored procedure
-- Store the actual data in #ExpectedResult
INSERT INTO #ActualResult
EXEC [FCS].[dbo].[WeeklySales] @WeekEndingDate = '2011-05-03'
Do you know a workaround ?