I have the same question. Is that using function distinct on name ... ?

THanks for the help, but resolve the problem 🙂

SOLUTION 😀

SELECT

MAX(CONVERT(INT, dbo.OSUSR_BZA_USER_LOGIN_DAY.USERPROFILEPERCENTAGE))AS PERCENTE,

dbo.OSUSR_A7L_GROUP.NAME AS GRUPO,

dbo.OSUSR_A7L_USER_MASTER.NAME AS NAMEs

FROM dbo.OSUSR_A7L_USER_MASTER ...

Here it this. tks for the reply

USE FUTEBOL

GO

IF OBJECT_ID('TR_Inscrito_Insert') IS NOT NULL

DROP TRIGGER TR_Inscrito_Insert

GO

CREATE TRIGGER TR_Inscrito_Insert ON Inscrito INSTEAD OF INSERT

AS

DECLARE @msg VARCHAR(1000),

@EdicaoDataInicio Date,

@ContratoDataInicio Date,

@Equipa char(10),

@EdicaoDataFim Date,

@dateRequestEnd Date

SET @msg...