176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

SQL Server Scripting (T-SQL) needed
Sign in to Add to Watch List

IT & Programming > Database Development

View Change History

The client has made the following changes to the job.

Description
Date
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Sat, Sep 29, 2012
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: $200 - $300
  • Fixed Price Job
  • Elance Escrow Protection
  • U.S. freelancers must have W9
Sign in to view client's details

Table A has 5 fields (id, a integer, b varchar, c int, d varchar, e varchar) all integers
Design a table A_Audit which tracks the changes to Table A
Every time Table A is updated, Table A_Audit gets updated with the original record, the changed value (field level), the time stamp and the user id. At any point in time, I should be able to see what A_Audit has and how A's value has changed
A report is generated at the end, which comprehensively shows the difference between Table A and A_Audit and what was changed, when and by whom.
. Need well documented T-SQL code (can be modularized) that can achieve all of the above

IMPORTANT: Need this done by Tuesday (10/2)

- Sam

Sign in or Register to see more

Job ID: 33925558
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 India  |  
I am having 8 years of experience and have completed 27 projects with very good feedback. I am amongst top 20% freelancers in ASP.Net and MS SQL...
2
  |  
 0.0   |  Private   |  5 Jobs
Bid ID: 33929768  |  Submitted: Sep 29, 2012 04:58 ET 
Proposal SEALED

 Sri Lanka  |  
M.A. Jinesh Saminda (BSc MIS) is MCTS in Microsoft SQL Server 2008, Business Intelligence Development and Maintenance and Microsoft Office...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 33929764  |  Submitted: Sep 29, 2012 04:58 ET 
Proposal SEALED

 India  |  
We are a well established company providing overseas solutions to customers in the field of web development and IT . The solutions are tailor made...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 33928598  |  Submitted: Sep 29, 2012 03:36 ET 
Proposal SEALED

 India  |  
Since 2011, we're committed to deliver memorable digital experiences for the clients across the globe. We're a team of talented and enthusiastic...
10
  |  
 4.9   |  Private   |  65 Jobs
Bid ID: 33928584  |  Submitted: Sep 29, 2012 03:35 ET 
Proposal SEALED

Goran Atanasov      
Goran Atanasov's identity has been verified.  Learn More
 Macedonia  |  
Software engineer with 20 years of work experience. Microsoft Certifications for SQL and .Net (MCP,MCAD,MCSD,MCT).
4
  |  
 5.0   |  Private   |  1 Jobs
Bid ID: 33928331  |  Submitted: Sep 29, 2012 03:18 ET 
Proposal SEALED

 India  |  
TEC-LAB is an establishing Offshore Software Development Company providing Web Application Development Services, IT Consulting and Custom...
2
  |  
 0.0   |  Private   |  0 Jobs   |  1 verified credential(s)
Bid ID: 33926836  |  Submitted: Sep 29, 2012 01:37 ET 
Proposal SEALED

 Argentina  |  
Winner
Computer engineer with more than 10 years of work experience. * Highly skilled with SQL, and I have worked using Microsoft SQL Server and MySQL...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 33926048  |  Submitted: Sep 29, 2012 00:45 ET 
Delivery
Within 3 days
$197.26

Manzoor Hussain      
Manzoor Hussain's identity has been verified.  Learn More
 Pakistan
I am expert level web developer in .Net Technology. Coding is my passion and always look for challenging job. Proficient in database driven...
1
  |  
 0.0   |  Private   |  0 Jobs   |  2 verified credential(s)
Bid ID: 33925967  |  Submitted: Sep 29, 2012 00:39 ET 
Proposal SEALED

 India  |  
I have 6 years of experience in developing enterprise applications. Mostly i have worked on .Net technologies and developed quality solutions...
1
  |  
 0.0   |  Private   |  1 Jobs
Bid ID: 33925894  |  Submitted: Sep 29, 2012 00:33 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »