Hi,

Thanks for the response. However, what I found was weirdly the report was linked to itself?

Thanks,

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 help...

Hi,

Well, I would like to know how to create a trigger?

Thanks,

Hi,

Well thanks for the effort.

Your suggestion works too. The only reason I added the product Name was for some clarification. To make sure it was pulling the right data.

Thanks,

Hi,

I have attached the sample data from the query ad the order table.

Thanks,

Hi,

Is this correct?

SELECT COUNT(CustomerID), TotalQuantity, CustomerID, ProductName

FROM [Order]

GROUP BY TotalQuantity, CustomerID, ProductName;

Hi,

Thanks for your very detailed response. Its just practise for home really.

I just want to give a discount of 10 % if the customer has ordered more than 4...

USE [Supermarket]

GO

/****** Object: Table [dbo].[Customer] Script Date: 17/04/2016 13:44:00 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[Customer](

[CustomerID] [varchar](10) NOT NULL,

[FirstName] [nvarchar](50) NULL,

[Surname] [nvarchar](50) NULL,

[Gender] [varchar](5)...

Hi,

Do u want me to add further code for my database?

Thanks

I agree with what you are saying but however this is more of a practise trigger for me to try as I just want to get accustomed to triggers hence...

The fact that, it has to happen after INSERT

Hi,

Yeah, that is correct.

Thanks,

I am not sure how to write a query, that will display the customer who has more than one order in the order table. I have attached the table structures.

THanks

Hi,

I am sorry I have not provided the correct information regarding the problem.

I am trying to create a trigger, which will provide a discount of 10%, if the same customer...

Hi,

Just all the orders ordered by the same customer.

Thanks,