lundi 6 juillet 2015

Using sql if else for Anonymizing data in table more simple

the table outputs four columns , i take in a parameter cid and i want the column for company names to all be set as XXXXXX but not the row that contains the Cid

  select x1.CompanyID, x1.CompanyName,x1.averagesurveyscore as Company_Score, x1.Totalticket as Total_Tickets 
  from @table1 x1
  where x1.companyid = @cid

so pretty much set all data that is not the cid to XXXXXX in the company name column except for the company that has been given in the parameter. I dont want anyone seeing the company names.

enter image description here

Aucun commentaire:

Enregistrer un commentaire