Code snippet for using CASE inseide value part of insert statement:
- INSERT INTO [DTWL].[dbo].[Transation_Log_Master]
- ([Description]
- ,[TranDate]
- ,[TranByUser]
- ,[TableName]
- ,[RowID])
- VALUES
- ( CASE @Operation
- WHEN 1 THEN 'New Addes'
- WHEN 2 THEN 'Updated'
- ELSE 'Deleted'
- END
- ,Getdate()
- ,@UserID
- ,'DistributorPoint'
- ,@ID)