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.
Aucun commentaire:
Enregistrer un commentaire