stored procedure
$30-5000 USD
Paid on delivery
I need a SQL7 stored procedure that does the following
Tables (1): ClientInformation
Tables (2): tmpClientInformation
Here is the logic.
What I basically need is to move rows from one table to another;
tmpClientInformation -> ClientInformation.
But with some conditions.
conditions:
1. if the account (Row) that you are moving does not exist in the second table then basically do a straight move, all the columns for that row of tmpClientInformation should be moved to ClientInformation table. The default value for [Ignored Fee] is FALSE and [FeeScheduleID]=NULL
2. if the account (row) that you are moving over does exist then do the following
* if [Dealer Number] = ‘7723’ OR ([Dealer Number] = ‘9822’ AND [Rep Number] StartWith ‘AZ’) then move over everything except [AMSCode]
* if the above condition does not apply to the account then move over everything.
Let me know how long and how much.
Please see attached for SQL Script
Thanks
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
SQL 7 and SQL2000
Project ID: #3276826