SQL_Kills (10/27/2016)

---

Hi,

I have the below table

CREATE TABLE [dbo].[BookOrderTest](

[TitleID] [int] NULL,

[Title] [nvarchar](100) NULL,

[Quantity] [int] NULL

) ON [PRIMARY]

insert into bookordertest values (1,'The Catcher in the Rye',3)

insert into bookordertest values (1,'The Catcher in the Rye',3)

insert into bookordertest values (3,'The Great Gatsby',0)

insert into bookordertest values (4,'Gone with the Wind',4)

insert into bookordertest values (5,'Jane Eyre',5)

insert into bookordertest values (7,'Age of Innocence',8)

Select titleid, COUNT(*) cnt

FROM BookOrderTest

Group By titleid

having COUNT(*)>1

I want to send a email to Joe.Bloggs@google.com if there are duplicates returning and to advise which titleid they are. If there are no duplicates then no email to be sent.

Any ideas?