troubleshooting Question

SQL 2000 - Need to update information from a different database (same instance)

Avatar of 2326ac
2326ac asked on
DatabasesMicrosoft SQL ServerSQL
3 Comments1 Solution222 ViewsLast Modified:

I have two database in the same instance.  1 called SD the other called CRDB.

SD has 3 fields I am interested in.  Forname, Surname and Email.  I need to create a query or stored proceedure that will take all the fields from this table and update them in a different database. But.... in CRDB the destination) I need the Fiorname and Surname to be together into a WholeName field (Forname + ' ' + Surname) and the email field to be to populated with the first letter of the forname, the whole surname field ''

Can anyone please advise me on this.  If you need me to be more clear, please say and I will be more detailed.  it is very simply what I am trying to do
Join our community to see this answer!
Unlock 1 Answer and 3 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 1 Answer and 3 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