Just Checking - This doesn't alter the data, does it ?

• homebrew01

  SSC Guru

  Points: 55548

  More actions

  November 6, 2008 at 2:53 pm

  #201277

  I'm doing a CONVERT in my join, to the same column that's getting inserted into a table. My convert only applies to the join, right ? It doesn't affect the data being inserted ? Since #CIFHold.RWA_ID is defined as decimal, I should be ok.

  CREATE TABLE #CIFHold

  (Call_ID int,

  RWA_ID decimal (10,0),

  ProducerID char(6),

  StateCd char(2))

  INSERT INTO #CIFHold

  SELECT c.call_id, c.RWA_ID, l.ProducerID, l.StateCdFROM Call_Detail c

  JOIN Leads l on convert(char(20), c.RWA_ID) = l.RWA_ID

  JOIN Leads_CE lc ON lc.RWA_ID = c.RWA_ID

  JOIN CIF_Detail cd ON c.Call_ID = cd.Call_ID

  WHERE c.Call_ID = @Call_ID

  Dumb question, I know, but I had a quick panic attack after some user errors referencing the same field.

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  November 6, 2008 at 8:33 pm

  #895298

  Yes it only applies to the join. The data is not changed.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question