correct below tsql. I am getting error below : DECLARE @hashThis nvarchar(max);
SET @hashThis = CONCAT(
      Branch | '|' |
      DiscountGroup | '|' |
      ItemNumber | '|' |
      PriceColumn |'|' |
      LastUpdatedDate |'|' |
      PMBasis |'|' |
      PMOper |'|' |
      PMMult |'|' |
      DeletedOnDate |'|' |
      PriceMatrixKey |'|' |
      ODS_INSERT_TS 
  )
SELECT HASHBYTES('MD5', @hashThis);