AnsweredAssumed Answered

How making a 'Distinct' with DBMS Script ?

Question asked by jmroman on Oct 19, 2015
Latest reply on Oct 20, 2015 by George Jeffcock

Hi everybody,

 

With Plex I want to make a "DISTINCT" in my view  like in sql server. I was looking in the "CA PLEX HELP" and I Found this:

 

           VW DBMS script SRC

 

So, I create a source code with this instruction:


          -- END OF THE VIEW

          #END

          -- SELECT DISTINCT OF THE VIEW

          #BEGIN

          SELECT distinct * FROM [Nomina].[dbo].[AA1pV]



And Include this SRC in the triple of the view like in the picture below:


TRIPLE.jpg


I compiled & Generated the view and the function which is pointing to that view.

The view retrieve all the data, and the 'distinct has not effect.


How could achieve to do a distinct in plex?


thanks.




P.D: This is the source code of my view that is generated using plex:


#BEGIN VIEW AA1pV

CREATE VIEW AA1pV AS

SELECT

    T1.ReferenciaEntrada,

    T1.EstadoTransaccion

FROM Aviso_Entrada T1

-- END OF THE VIEW

#END

 

-- SELECT DISTINCT OF THE VIEW

#BEGIN

SELECT distinct * FROM [Nomina].[dbo].[AA1pV]

#END

 

Outcomes