Em Andamento

MS SQL Trigger

MS SQL Trigger

I have a database and want to add a trigger to add a specific address for a client when they create an order. Here is how I see it working.

An order is saved to the database, the trigger is fired and it checks if the client has the address in the address table and if so exits and if not adds the address.

Trigger on the Order table

When a record is added Order table the trigger takes the [url removed, login to view] and joins on the [url removed, login to view] and selects the SiteValidation.FacilityID.

Next it takes the [url removed, login to view] from the new record and joins the [url removed, login to view] and checks to see if there is a record for the client where the [url removed, login to view] = [url removed, login to view] and the [url removed, login to view] = Sitevalidation.FacilityID.

If this returns a record then the trigger can exit because the facility has already been added to the address table for the client, if not, we need to create a new record in the address table.

Address Table

ClientID = [url removed, login to view]

FacilityID = [url removed, login to view]

ValidAddress = 1

Status = 1

Street = The rest copy the fields from the

Address table where AddressID = FacilityID

Street2

APT

Building

City

State

Zip

CrossRoads

Contact

Lat

Long

Remarks

Phone

## 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

MS SQL

Habilidades: Engenharia, MySQL, PHP, Arquitetura de software, Teste de Software, SQL

Ver mais: sql coder hire, create contact form php, sql client, ms sql, lat long, hire sql, building engineering hire, rest sql server, sql run package, lat address php, record checks, zip code lat database, contact database php sql, zip code sql database, sql coder, zip code database sql, php form sql, client sql server, need lat, add fields sql database, state city database sql, desktop sql, php contact form sql, sql add fields table, sql code add fields

Acerca do Empregador:
( 14 comentários ) United States

ID do Projeto: #2987200

Premiar a:

aiki2shinvw

See private message.

$29.75 USD em 2 dias
(8 Avaliações)
2.0

16 freelancers estão ofertando em média $25 para este trabalho

stsolhouse

See private message.

$42.5 USD in 2 dias
(23 Comentários)
5.3
mobipixelso

See private message.

$8.5 USD in 2 dias
(103 Comentários)
5.3
advantixvw

See private message.

$17 USD in 2 dias
(59 Comentários)
5.3
Atif222

See private message.

$21.25 USD in 2 dias
(26 Comentários)
4.9
siluvw

See private message.

$12.75 USD in 2 dias
(108 Comentários)
4.7
californianative

See private message.

$76.5 USD in 2 dias
(35 Comentários)
4.6
icewall

See private message.

$21.25 USD in 2 dias
(32 Comentários)
4.6
knoami

See private message.

$34 USD in 2 dias
(11 Comentários)
4.6
alexeytvw

See private message.

$17 USD in 2 dias
(24 Comentários)
4.5
amrelshemy

See private message.

$12.75 USD in 2 dias
(46 Comentários)
3.8
analytixvw

See private message.

$10.2 USD in 2 dias
(21 Comentários)
3.6
innocentfriend

See private message.

$34 USD in 2 dias
(2 Comentários)
1.4
gomathyvw

See private message.

$8.5 USD in 2 dias
(0 Comentários)
0.0
garryt

See private message.

$42.5 USD in 2 dias
(0 Comentários)
0.0
dhkoppad

See private message.

$8.5 USD in 2 dias
(1 Comentário)
0.0