Forum Discussion
pull only 1 row for each combination of GroupName, BusinessGroup fields
Hi, All, Thanks a lot for looking into this.. I have this table which gets populated from different queries - This is my final table that we use for reporting and i have this scenario - this scenari...
CREATE TABLE [dbo].[Testing123](
[Ticket_Number] varchar(25),
[TicketGroup] varchar(25) ,
[BusinessEntity] varchar(25)
)
INSERT INTO Testing123
(Ticket_Number,TicketGroup,BusinessEntity)
VALUES
('C125962','C125099','FIN'),
('D3478','C125099','HR'),
('C128055','C125099','FIN'),
('C111','C125098','FIN'),
('C222','C125098','HR'),
('C333','C125098','FIN')
[Ticket_Number] varchar(25),
[TicketGroup] varchar(25) ,
[BusinessEntity] varchar(25)
)
INSERT INTO Testing123
(Ticket_Number,TicketGroup,BusinessEntity)
VALUES
('C125962','C125099','FIN'),
('D3478','C125099','HR'),
('C128055','C125099','FIN'),
('C111','C125098','FIN'),
('C222','C125098','HR'),
('C333','C125098','FIN')