Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Separate first and last name and use them in Select
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01324894
Message ID:
01324895
Views:
11
This message has been marked as a message which has helped to the initial question of the thread.
>Hi everybody,
>
>I got an e-mail (urgent!) to fix some data. In the e-mail the data are in the table format embedded into the e-mail.
>
>If I copy it to notepad or SSMS query window it becomes like this
>
>
>SobleZoe
>StoneGabrielle
>YellenLauren
>SwartzCameron
>ZaslowEden
(~65 records)
>
>I need to update records using this info for the LastName and FirstName. Do you have an idea for me what would be my best approach here?
>
>Thanks a lot in advance.

What if you copy that data in Excel?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform