Posts by lll_JR_lll • 115 points
4 posts
-
4
votes1
answer1838
viewsQ: How to Use "Not Exists" in LINQ?
I am trying to translate the query below, in LINQ, but without success, someone can help me? SELECT * FROM PESSOAL A WHERE NOT EXISTS ( SELECT Chapa FROM PRODUCAO B WHERE B.Chapa = A.Chapa AND…
-
1
votes2
answers1970
viewsA: Use PIVOT operator without aggregation
Using the MOTTA Tip: SELECT Matricula, MAX( CASE Dia WHEN '2014-06-11' THEN Situacao ELSE '' END ) Dia11, MAX( CASE Dia WHEN '2014-06-12' THEN Situacao ELSE '' END ) Dia12, MAX( CASE Dia WHEN…
-
4
votes2
answers1970
viewsQ: Use PIVOT operator without aggregation
I have the FAULTS table with the following columns: CREATE TABLE [dbo].[FALTAS]( [Id] [int] IDENTITY(1,1) NOT NULL, [Matricula] [int] NOT NULL, [Dia] [date] NOT NULL, [Situacao] [varchar](50) NOT…
-
2
votes1
answer659
viewsQ: Show null results through LEFT JOIN with Linq!
I have an SQL query: SELECT A.Codplano, A.Secao, A.Setor,A.Subsetor,A.Contato, ISNULL(B.Subord,'NÃO LANÇADA')AS Situacao FROM vwPLANODIN A LEFT JOIN LANCADA B ON A.Codplano = B.Subord and B.Data =…