Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

SQL to LINQ converter

select top 10 p.Nombre, p.Apellidos, (SELECT COUNT(*) FROM Personas ps WHERE PS.ParentCode LIKE '%' + CONVERT(VARCHAR, p.id) + '-%'   ) Total  
from personas p
ORDER BY Total desc
 
PREVIOUS NEXT
Tagged: #SQL #LINQ #converter
ADD COMMENT
Topic
Name
3+1 =