1

I have a table that looks like below (Before) and using SQL I would like to make it the same as the table shown in 'After'.

Image here:

enter image description here

How would this be possible in SQL Server?

Many thanks

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
nowYouSeeMe
  • 935
  • 6
  • 11
  • 21
  • 3
    Why do you want to store data this way? So that when you want to search for `Terry` it is really hard? – Aaron Bertrand Apr 16 '13 at 14:45
  • 2
    Don't use screenshots to provide your schema but add it to your question. That has three advantages: 1. we can see it without clicking on links 2. we are able to see it even if the image provider doesn't exist anymore 3. we are able to create sample-data on sql-fiddle – Tim Schmelter Apr 16 '13 at 14:45
  • 2
    @Tim and 4. I know of at least one user for whom `imgur.com` is blocked, so they can't see it today either. – Aaron Bertrand Apr 16 '13 at 14:46

0 Answers0