Posts by niknight89 • 21 points
2 posts
-
-1
votes1
answer28
viewsQ: Questions with COUNT/GROUP BY
Good afternoon, I’m having trouble with the group by clause. I have a gigantic query, I need to quantify the contracts by Id, showing the degree of impact. Then I gave a Count(Id). The problem is…
-
0
votes1
answer51
viewsQ: LEFT JOIN with more than one condition in ON - SQL Server
Hi, guys, all right? I’m putting together a query, and I need to do a Join. In this case, the AIV table records have a start date and may or may not have an end date. I want them to cross as…