append record from the same table , change customer field based on parameter

• dosia2

  SSC Journeyman

  Points: 90

  More actions

  August 11, 2014 at 3:02 pm

  #291889

  test

• SQLRNNR

  SSC Guru

  Points: 281334

  More actions

  August 11, 2014 at 3:11 pm

  #1737048

  Can you provide sample data and table structures so we can actually provide a working query for you?

  Jason...AKA CirqueDeSQLeil
  _______________________________________________
  I have given a name to my pain...MCM SQL Server, MVP
  SQL RNNR
  Posting Performance Based Questions - Gail Shaw[/url]
  Learn Extended Events

• dosia2

  SSC Journeyman

  Points: 90

  More actions

  August 11, 2014 at 3:28 pm

  #1737058

  table design arcustomer

  [Customer] [char](7) NOT NULL,

  [Name] [char](30) NULL,

  [ExemptFinChg] [char](1) NULL,

  [Salesperson] [char](3) NULL,

  [CustomerClass] [char](2) NULL,

  [Salesperson,] [char](2) NULL,

  [TermsCode] [char](2) NULL,

  [Area] [char](2) NULL,

  [Branch] [char](2) NULL

  two parameters would be provided sx_customer_code and parent_customer_code

  data sample

  CustomerName ExemptFinChg Salesperson CustomerClass Branch Area TermsCode

  AB11153 anna mira NA02T3ABALG

  AB10154alex johnson NCXMT3ABALG

  AB11155South Mall YA02T3ABALP