Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Concat columns in Where clause RE: Concat columns in Where clause

  • November 12, 2013 at 12:56 pm

    #1665851

    Jonathan Marshall (11/12/2013)

    The queries are updating lookup tables that do not have a value by using a subquery to the lookup table.

    I like that idea of using a computed column as these will be scanning through lots of data.

    WHERE [column1] + [column2] NOT IN

    (SELECT [column3] + [column4] from dbo.table order by [column1] + [column2])

    If updating one table from another, then consider MERGE statement.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho