I have a friend who is working on a project and their SQL guy bailed, which has left them SOL with an impending Jan 3 deadline.

What they need is fairly simple:
1. Rename a bunch of table columns to match the incoming column names (their table design doesn't match the sql calls that load the data)
2. Add a few new columns to the tables
3. write an SP to join the tables and output the results to a text file

more on 3: basically, they have a set of rules for matching items. Somehow they need to have these items matched, updated, then output. presumably these should only be output once, at the time that they're matched.

If anyone has a solid SQL background and is willing to work on a tight deadline, hit me up.

To be honest, this seems like a fairly simple thing, but I don't know enough SQL to pull #3 off in any reasonable way.

Thanks for the replies, I think we found someone who will help.

Much appreciated.