Hi,
I have
m.MerchantIdentifier as 'Merchant Identifier',
I am wanting something like
case when salesoffice = 'Pia' then
m.MerchantIdentifier
end as 'PiaJewlerry'
else end as 'Merchant Identifier'
How could I do this in T-SQL