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?

In the LLBLGen Pro Designer, go to the catalog explorer (in the far right side of the screen) -> browse to the procedure by clicking open catalog -> schema -> stored procedures. THen click open the node of the stored procedure and you should see a node #0. Right-click it and select Change from the context menu. You then can change it to 1 or 2 or another value. (but 1 or 2 are sufficient).

After you've done that, you can add it as a retrieval procedure.

Thanks Walaa. It worked. :-)