Here's the scenario:
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
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
A SQL Server application that needs user permission to create and modify tables in SQL Server 2005 may be handled best via a schema.continue reading
Find how to save stored procedure output to the network drive via SQL Server Management Studio.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.