Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Help with a join RE: Help with a join<!-- 864 -->

  • August 21, 2014 at 9:49 am

    #1739963

    Ryan Keast (8/21/2014)

    Thanks guys for the help so far.

    I've discovered that what I thought was a potential link actually isn't so after all your advice it's not going to help me in this scenario.

    That being said I think I have found another potential to link my two data sets together.

    Example I table 1 we have "708698"

    In table 2 we have "Internet Card Payment Auth Code: 708698"

    Is there anyway in SQL that you could say join 708698 to Internet Card Payment Auth Code: 708698 by looking in the table 2 field to match the 708698?

    Is all the data in the column you wish to join to like this: Internet Card Payment Auth Code: nnnnnn where nnnnnn is the value to be joined?

    If yes, can you add a persisted computed column to table 2 that extracts the Internet Card Payment Auth Code: ? If so, you could then index the persisted column and join to it.