ok...so we have some test data that we can now all work on....

USE Tempdb

GO

IF OBJECT_ID('tempdb..VehicleMaintenance', 'U') IS NOT NULL

DROP TABLE tempdb..VehicleMaintenance ;

IF OBJECT_ID('tempdb..VehicleTable', 'U') IS NOT NULL

DROP TABLE...

randyetheridge (4/20/2016)

---

Ok Yes, your table create and insert statements are exactly correct.

sorry missed the comment about the vehicle table.

CREATE TABLE VehicleTable( unitid INTEGER NOT NULL ,vehiclename VARCHAR(13) NOT...

see my previous post

In an effort to help you help us and also so that hopefully you will learn with any future posts that you make....here is my "guess" at what your sample...

randyetheridge (4/20/2016)

---

I attached a word document with my SQL code and an excel file with table data and expected results? When I say the pieces run, I mean if...

are you looking to write changes made in a table to an "audit" table.....

I see you have also posted this question here:

http://www.dbforums.com/showthread.php?1708865-Can-someone-help-me-with-creating-queries-for-the-below-information-at-the-Earliest

but on that site you have posted in the MySQL forum.....are you using MS SQL or MySQL?

Phil Parkin (4/19/2016)

---

pvong (4/19/2016)

---

Phil, thanks for your help.

Jacob, I marked you as the answer because I learned how to do an error output file thanks to you suggesting it. ...

here is one way to get the results

CREATE TABLE #yourtable(

OrderId INTEGER NOT NULL

,SalesUnitPrice NUMERIC(13,2) NOT NULL

);

INSERT...

fareedhmohamed (4/18/2016)

---

No, I dont get that result that you are getting. How did you get the discount column price?

Can I please say that thank you so much for trying to...

ok...but lets walk before we run (with triggers)

given the following and according to your rules that an orderiD...

ok...

in an effort to help you move on and hopefully to use as a basis for any future questions that you post

and we are nowhere near using triggers yet

CREATE TABLE...

ok...you have given yet another scree shot....please re read http://www.sqlservercentral.com/Forums/FindPost1778496.aspx

now....what are you expecting?

"is this correct".....maybe maybe not........

in the absence of any sample data and expected results then I will guess...