regarding sql query

Question

Post reply

regarding sql query

p.avinash689

SSC-Addicted

Points: 435
More actions
October 13, 2013 at 12:38 am

#278071

i have 10 records in sql table . the records contains data as gender with male and female. please reply me with a query that can change male into female and female into male with a single query.
Forum Etiquette: How to post Reporting Services problems

[/url]

Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]

How to Post Performance Problems - by Gail Shaw
[/url]

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

update yourtable set

gender = case when gender = 'male' then 'female' when gender = 'female' then 'male' end

Dwain Camps SSC Guru Points: 86908 More actions · Answer 2

p.avinash689 (10/13/2013)
i have 10 records in sql table . the records contains data as gender with male and female. please reply me with a query that can change male into female and female into male with a single query.

Now that Lynn has thoughtfully provided a correct solution to your question, let me ask you: What happens if you run Lynn's query and one of the rows contains the value of "Other" in the gender column?

My mantra: No loops! No CURSORs! No RBAR! Hoo-uh![/I]
My thought question: Have you ever been told that your query runs too fast?

My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.

Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 3

p.avinash689 (10/13/2013)
i have 10 records in sql table . the records contains data as gender with male and female. please reply me with a query that can change male into female and female into male with a single query.

Do you work in a clinic where they provide mass gender altering surgery?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Dwain Camps SSC Guru Points: 86908 More actions · Answer 4

Koen Verbeeck (10/14/2013)
p.avinash689 (10/13/2013)
i have 10 records in sql table . the records contains data as gender with male and female. please reply me with a query that can change male into female and female into male with a single query.
Do you work in a clinic where they provide mass gender altering surgery?

😛

My mantra: No loops! No CURSORs! No RBAR! Hoo-uh![/I]
My thought question: Have you ever been told that your query runs too fast?

My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.

Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St

mister.magoo SSC-Forever Points: 47068 More actions · Answer 5

This reminds me of an old sql challenge or similar test...

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);