Hi,
I'm having one stored procedure which is something like following:
CREATE PROCEDURE [dbo].[TEST]
@TESTID INT
AS
BEGIN
CREATE TABLE #TMP
(
A DATETIME null
)
SELECT * FROM #TMP
DROP TABLE #TMP
END
As you can see, it returns temporary table from SP. Now when I generate DAL using LLBL it's showing this Sp as ActionStoredProcedure instead of Retrieval. I want to use this as Retrieval. Please guide me what's wrong?