How to find account number of bank from given records in table

• MMartin1

  One Orange Chip

  Points: 27799

  More actions

  February 24, 2016 at 11:16 am

  #1860830

  We cannot use extra columns in file.

  Maybe the person or persons that made this decision and decided to put you as the implementer should take on the task themselves.

  If table t3 is new then what could possibly be dependent on if there is a fear that something might break? If t3 is not new then perhaps it just does not fit the requirements. Another table (t4) in this case would be better.

  I would guess that t3 is existing already and unknown things depend on it and the shop has a history of using SELECT * here and there.

  ----------------------------------------------------

• Jeff Moden

  SSC Guru

  Points: 1004439

  More actions

  February 24, 2016 at 1:31 pm

  #1860878

  MMartin1 (2/24/2016)

  ---

  We cannot use extra columns in file.

  Maybe the person or persons that made this decision and decided to put you as the implementer should take on the task themselves.

  If table t3 is new then what could possibly be dependent on if there is a fear that something might break? If t3 is not new then perhaps it just does not fit the requirements. Another table (t4) in this case would be better.

  I would guess that t3 is existing already and unknown things depend on it and the shop has a history of using SELECT * here and there.

  This is a great use for views... rename t3, add the columns, and put an updateable view on the table and name it "t3".

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)