Create table TShirt-Kili(Action varchar(255), Reaction varchar(255) )
Think that the data is loaded with Action in the table and Reaction set to NULL.
Given the table to a TShirt-Kili:
Update TShirt-Kili
Set Reaction = Case
Think that the data is loaded with Action in the table and Reaction set to NULL.
Given the table to a TShirt-Kili:
Update TShirt-Kili
Set Reaction = Case
when Action like 'Hes kind of seeing me' Then 'Strecth to make the T-Shirt more tight'
when Action like 'He's not watching me' Then 'Make him watch with heavy perfume'
when Action like 'He's disturbed' Then 'Enjoy the moments'
when Action like 'He's not disturbed' Then 'Huh Huh Huh'
when Action like 'He's a daring guy' Then 'Pick the cell phone and talk the other side'
when Action like 'He's shy' Then 'Pick the cell phone and talk looking at him'
when Action like 'He's nervous' Then 'Talk and walk passing him too close'
when Action like 'He wants to come close' Then 'Walk out when he comes too close'
when Action like 'He wants to say Hello' Then 'See him until there is a lip movement'
when Action like 'He's staring at me' Then 'Cover with a overcoat'
when Action like 'He's not looking at me' Then 'Remove the overcoat'
end
Since SQL server wont be able to handle this scenario more, the update query ends here. Bill Gates have asked to partition the TShirt-Kili table.
when Action like 'He's not watching me' Then 'Make him watch with heavy perfume'
when Action like 'He's disturbed' Then 'Enjoy the moments'
when Action like 'He's not disturbed' Then 'Huh Huh Huh'
when Action like 'He's a daring guy' Then 'Pick the cell phone and talk the other side'
when Action like 'He's shy' Then 'Pick the cell phone and talk looking at him'
when Action like 'He's nervous' Then 'Talk and walk passing him too close'
when Action like 'He wants to come close' Then 'Walk out when he comes too close'
when Action like 'He wants to say Hello' Then 'See him until there is a lip movement'
when Action like 'He's staring at me' Then 'Cover with a overcoat'
when Action like 'He's not looking at me' Then 'Remove the overcoat'
end
Since SQL server wont be able to handle this scenario more, the update query ends here. Bill Gates have asked to partition the TShirt-Kili table.
0 comments