SQL Server Stored Procedure with temp table select, does not return correct result in LLBLGen Pro
When you create a stored procedure like: if exists (select 1 from sysobjects where name = 'GetDataFromTempTable' and xtype = 'p') drop procedure [dbo].[GetDataFromTempTable] go create procedure [dbo].[GetDataFromTempTable] as begin -- Create temp table create