Error - Column name or number of supplied values does not match table definition

• jsshivalik

  SSChasing Mays

  Points: 612

  More actions

  January 14, 2020 at 4:42 pm

  #3715303

  Hi

  ALTER procedure [dbo].[GST_Report_GSTR3B_APAR_Test](
  @fromDate date,
  @toDate date,
  @locGSTN nvarchar(15))
  as
  begin
  
      IF object_id('GST_Report_GSTR3B_APAR_Tab','u') is not null
  drop table GST_Report_GSTR3B_APAR_Tab
  
  select t0.*
  into GST_Report_GSTR3B_APAR_Tab 
  from (select case when ObjType = 14 then -BaseSum
           else BaseSum end as BaseSum, 
   case when ObjType = 14 then -IGSTSum
           else IGSTSum end as IGSTSum, 
   case when ObjType = 14 then -CGSTSum
           else CGSTSum end as CGSTSum,
   case when ObjType = 14 then -SGSTSum
           else SGSTSum end as SGSTSum,
   case when ObjType = 14 then -CessSum
           else CessSum end as CessSum,
   'GR' as ItemTaxType ,CardName,DocEntry,DocNum,DocDate,LocGSTN
    from GST_ODOC_Result_Ignore_RvsCharge t0
    where ObjType in (13, 14)
  and (ItemTaxType <> 'GE' and PureNilRateDoc = 'N')
  and not (ImpOrExp = 'Y' and ExportType <> 'D')
      ) t0
  insert into GST_Report_GSTR3B_APAR_Tab
    select case when ObjType = 14 then -BaseSum
           else BaseSum end as BaseSum, 
   case when ObjType = 14 then -IGSTSum
           else IGSTSum end as IGSTSum, 
   case when ObjType = 14 then -CGSTSum
           else CGSTSum end as CGSTSum,
   case when ObjType = 14 then -SGSTSum
           else SGSTSum end as SGSTSum,
   case when ObjType = 14 then -CessSum
           else CessSum end as CessSum,
   'ZZ' as ItemTaxType ,CardName,DocEntry,DocNum,DocDate,LocGSTN
    from GST_ODOC_Result_Ignore_RvsCharge
    where ObjType in (13, 14)
  and (ItemTaxType <> 'GE' and PureNilRateDoc = 'N')
  and ImpOrExp = 'Y' and ExportType <> 'D'
  
  End

  Thanks

• Phil Parkin

  SSC Guru

  Points: 247172

  More actions

  January 14, 2020 at 4:49 pm

  #3715306

  Is this a blog post, or do you have a question?

  ---

• jsshivalik

  SSChasing Mays

  Points: 612

  More actions

  January 14, 2020 at 5:07 pm

  #3715317

  Question

• Phil Parkin

  SSC Guru

  Points: 247172

  More actions

  January 14, 2020 at 5:30 pm

  #3715324

  jsshivalik wrote:

  Question

  My mind-reading capabilities are lacking today, so please state your question here.

  By the way, questions end with a question mark (?)

  ---