Skip to Content
0
J S
May 18, 2020 at 04:56 AM

There is already an object named @tmp0 in the database

912 Views

Hi

IF object_id('tempdb..#Tmp0') IS NOT NULL
BEGIN
   DROP TABLE #Tmp0
END
create table #Tmp0(DocEntry int,DocNum varchar(10),DocDate date,DocStatus varchar(1),NumAtCard varchar(100),
CardName varchar(100), GstRegNo varchar(50),Location varchar(100), Quantity decimal(18,2), BaseAmt decimal(18,2), TaxPercent decimal(18,2),
Cgst decimal(18,2),Sgst decimal(18,2),Igst decimal(18,2),UTGst decimal(18,2),Others decimal(18,2))

Thanks