Comments by Juan-ITSM

Juan-ITSM 26-Feb-14 10:49am View

Thank you, although it's been a long time since I asked, I still find very useful this information. Thank you again.

Juan-ITSM 29-Jun-11 21:30pm View

Deleted

thanks for your answer, and obvously i've typed it... and if you didn't have a good answer or at less a good way to explain it, maybe you shouldn't did it.
Thank you again.

Juan-ITSM 10-Jun-11 12:18pm View

thank you, it will help me so much...

Juan-ITSM 10-Jun-11 12:16pm View

thanks for your help, its very usefull for me!

Juan-ITSM 10-Jun-11 12:15pm View

thank you very much, i've been trying to do this, and i've had a litle troubles, even i still have, but things like this help me so much, thank you!

Juan-ITSM 18-May-11 19:49pm View

Thank you very much, it has been very helpfull for me, thank you again...

Juan-ITSM 9-Apr-11 17:46pm View

Thanks for the answer and yes, iÂ´ve been writing stored procedures, but i need to calculate fields in a senteces and im a litle confuse about it for example i have something like this... and after studied, i understood, but i still cant find examples online about this...
im trying to see when a dinamic sql statement becames in a table etc...
thanks for your help.

select IdCliente, Nombre, TotalDeCompras from
(
select IdCliente, Nombre, Paterno,
(
select COUNT(IdCliente)
from Ventas
where Ventas.IdCliente=c.IdCliente
)
as TotalDeCompras from Cliente c
) as NoSe where TotalDeCompras = 0

Juan-ITSM 9-Apr-11 17:46pm View

Thanks for the answer and yes, iÂ´ve been writing stored procedures, but i need to calculate fields in a senteces and im a litle confuse about it for example i have something like this... and after studied, i understood, but i still cant find examples online about this...
im trying to see when a dinamic sql statement becames in a table etc...
thanks for your help.

select IdCliente, Nombre, TotalDeCompras from
(
select IdCliente, Nombre, Paterno,
(
select COUNT(IdCliente)
from Ventas
where Ventas.IdCliente=c.IdCliente
)
as TotalDeCompras from Cliente c
) as NoSe where TotalDeCompras = 0

Comments by Juan-ITSM (Top 8 by date)