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:
Hi,

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 '@domain.co.uk'

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
ASKER CERTIFIED SOLUTION
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