change the procedure to this..
ALTER procedure [dbo].[SP_SELECT_BILLDELETE]
As
Begin
SET NOCOUNT ON
IF EXISTS
(
SELECT *
FROM tempdb.dbo.sysobjects
WHERE ID = OBJECT_ID(N'tempdb..#MyTempTable')
)
BEGIN
DROP TABLE #MyTempTable
END
select * into #MyTempTable from BillDelete where CONVERT(date,billdate,101) = CONVERT(date,GETDATE(),101)
union
select * from WBillDelete where CONVERT(date,billdate,101) = CONVERT(date,GETDATE(),101)
select * from #MyTempTable
End
add
select * from #MyTempTable
at the bottom before
end
.
hope it works..