troubleshooting Question

SQL change value for result set, but don't update

Avatar of simplyfemales
simplyfemales asked on
Microsoft SQL Server
2 Comments2 Solutions284 ViewsLast Modified:
I would like to select a data set and depending on the criteria, I would like to change the value of specific cells, but I don't want to change the original data, just specifically what is seen in the resultant set.

I.E.  if my source=Code1, then in the result set, I would like it to show "Changed Code", but I do not want to update the source table.

How can I accomplish this?  I am trying to work with CASE setting criteria.

I have tried:

case when source='Code1' then source='Changed Code' else null end

but it doesn't work

Suggestions?
ASKER CERTIFIED SOLUTION
Ephraim Wangoya
Software Engineer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros