Data Triggerung in MS SQL Server
General information
We are using an order management tool for ebay, which is based on a MS SQL database.
We have special requirements and need adjust the database.
As first part we have a data triggering project, but more project can follow later
Project description
The main table of the database is the “transactions” table.
We extended this table with several fields.
Some of these fields (marked Green) need to be triggered by the other fields.
Which fields need to be triggered and how the attached documents are describing.
Pls note that also Chinese characters need to be insert, so we also need know how to support this character set in the database.
ATTACHEMENT:
1. Some screenshots from the database and the important “transactions” table viewed by EMS SQL Manager Studio
2. Export file of that table with some data – yellow fields are our input fields - red fields need to be triggered
3. Triggering table - The trigger table is not complete (some fields show “data will be delivered later”). We deliver quickly after provider is choosen.
Timeline is as important as price. So please tell us both.
Timeline must be reliable !!!
Please give us the following information:
1. Price
2. Timeline
3. How you will make the project. As trigger SQL syntax hardcode, or which kind of solution
Money will be escrowed and released when project is done or on proof that project is completed.
If any questions pls contact us.
Thanks
Hi,
We are quite comfortable to work on your Project with our excellent team of Programmers & Designers.
Please see PMB for our company Profile & Experience & Questions.
Thanks
Hi, I went through your project description and attached documents. Given my 17 years of programming expereince and my SQL expertise, I am confident I am the right fit. In addition, handling Chinese characters is easy to me too. Please check PM. thanks
For this trigger will be created on database events like while inserting or while updating or inserting a value in particular table trigger will implicitely updates the corrosponding fields of the table.
Dear Team ,
I am interested in doing Part time job.I have completed my MCA . I will obtain perfection in my career through my hard work and sincerity. Please provide me with the details
With Regards,
Preetha Muralidharan
9786724082
That is a project for me. I am a MS SQL server expert in 2000/2005/2008 and I have a lot of experience on triggers. The most import thing is I am Chinese so I know how to handle Chinese characters in DB. Hope to hear from you soon!
am interested in this posted project. I can do CAPTCHAS, copy & paste, data entry and processing and click.
I can work 7-10 hours a day in front of the computer and submit projects on time. I have experiences in Encoding and data entry.
You can send me the details.
Hope to hear from you soon.
Thanks.
This Can be Achived in many ways. as per my understanding your code does not insert the new coloumn value at the same time this can not be modified i guess.
In that case , i need to know how your code support or insert the value into sql server. It can be done while inserting into a data into sql server or this can be update based on the existing data.
i roughly put 15 days but this can be achived much earlier based on the infomration or the sample data provide by you.