Here's the scenario:
We have two databases, call them A and B. A is created when a user registers on a forum site here at the university, and B is their "profile".
There is a common ID in both files.
Because of a bug in the way Invision works (the forum software), there is one field in A that is out of sync with B. A.member_type is a numeric based on their "membership type" (student, teacher, etc) - single digit.
B.member_group is the membership type in text, based on what they put in A - for example, if A.member_type = 3, then B.member_group would be "Student". But both tables are editable by the user, so they don't match up (that is being fixed over Christmas !).
What I need to do is retrieve all records in both tables, joined by their ID, and change B.member_group based on the contents of A.member_type.
But every time I try it, I get various and sundry errors, and one of our developers has told me that it cannot be done programmatically. As it is not I who will be running this script, but someone with zero SQL knowledge, is there an easy way of doing it?
Dig Deeper on SQL Server Database Modeling and Design
Related Q&A from Greg Low
Should developers be granted permissions to production queue in a SQL Server environment? See why expert Greg Low suggests proc access by WITH ... Continue Reading
Find how to save stored procedure output to the network drive via SQL Server Management Studio. Continue Reading
Find how to query in SQL Server to get all database names created by users. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.