This content has been marked as final.
Show 7 replies
-
Re: How do I make the equivalent of QV's Preceding Load in SQL?
Devarasu R Aug 23, 2017 12:22 PM (in response to Julio Arriaga) -
-
Re: How do I make the equivalent of QV's Preceding Load in SQL?
Sunny Talwar Aug 23, 2017 12:24 PM (in response to Sunny Talwar )May be this
select count(*)
from (select Producto_ID, count(Producto_ID) Count
from DWH.MF_PRODUCTO_ORGANIZACION
where 1=1
and EntidadLegal_ID='191'
and Tipo_Producto_ID='1'
group by Producto_ID
having count(Producto_ID)>1
) p;
-
Re: How do I make the equivalent of QV's Preceding Load in SQL?
Peter Cammaert Aug 23, 2017 12:58 PM (in response to Sunny Talwar )Sunny may be right. Your SQL engine appears to be complaining about the last ); lacking a name.
Try to name the result set of the inner select (Sunny called it p)
-
-
-
Re: How do I make the equivalent of QV's Preceding Load in SQL?
Peter Cammaert Aug 23, 2017 12:37 PM (in response to Julio Arriaga)This is a nested SELECT.
If you omit the outer select count(*) from (...), does the inner SELECT work ok on your Teradata DB? Does it produce the expected output?
-
Re: How do I make the equivalent of QV's Preceding Load in SQL?
Julio Arriaga Aug 23, 2017 12:43 PM (in response to Peter Cammaert )Hi, yes, it does :s
-
Re: How do I make the equivalent of QV's Preceding Load in SQL?
Sunny Talwar Aug 23, 2017 12:44 PM (in response to Julio Arriaga)Did you try to look at the link I provided?
-
-