Found the answer with Case When
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
It sounds like you need a CASE statement
case when productid = 27 then ‘Commercial’when productid = 29 then ‘Point of Service’
17 People are following this question.
Hi everyone I'm quite new to SQL. Please I am trying to write a query where a particular column has a value that appeared just once in the table
How to query my linked server
Calculate week from a date
SubQuery Table to Get Selective Display
SQL Query Optimization