Home Forums SQL Server 2012 SQL 2012 - General make over columns using comma seperated and select in query RE: make over columns using comma seperated and select in query

  • If you absolutely are identifying a row here base on the values of emp1, emp2 and emp3, then you can create a calculated field that persists in the table. This will make inserts a bit slower but the new field can be the subject of an index thus making selects perform reasonably well.

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