invalid input syntax for integer in collase( ' ' 0).

Question

invalid input syntax for integer in collase( ' '  0).how correct this error I am waiting Sir

aravinth kandasamy · Answer

Update tbfacilityreceiptitems set itemID = 13886 Batchno =' 1522' mfgdate = '10/20/2013 12:00:00 AM' expdate = '10/20/2016 12:00:00 AM' MRP =200.0000 SingleUnitPrice= 158.0000 marginPercentage = 25.00 sellingprice = 184.80 SaletaxID = 34 TaxPercentage = COALESCE('''0')::int  SaleTaxPercentage =COALESCE('' '0')::int  SaleTaxType =' ' sellingpricesku = COALESCE ('''0')::int where facreceiptitemid = 2655

Gowtham Rajamanickam · Answer

show me the entire code

Gowtham Rajamanickam · Answer

show me the entire code

aravinth kandasamy · Answer

My code is give below Update tbfacilityreceiptitems set itemID = 13886 Batchno =' 1522' mfgdate = '10/20/2013 12:00:00 AM' expdate = '10/20/2016 12:00:00 AM' MRP =200.0000 SingleUnitPrice= 158.0000 marginPercentage = 25.00 sellingprice = 184.80 SaletaxID = 34 TaxPercentage = COALESCE(0'')  SaleTaxPercentage =COALESCE('' 0)  SaleTaxType =' ' sellingpricesku = COALESCE (''0) where facreceiptitemid = 2655 Please rearrange this code

invalid input syntax for integer in collase( ' ' , 0).