Hey SQL Guru's :)
I'm stuck on something that may be very simple but can't wrap my head around it.
I have a few columns with a GROUP BY and a simple join. I also have one aggregration column; [No of Employees]
SELECT
H.CALL_CENTER AS [Site],
H.TEAM_LEAD_NAME...
Hi all
I have a great financial services client in the Northern suburbs of Johannesburg and they want a front-end ASP.net developer.
The salary max is R450k CTC and they have various benefits.:D
Work with a team of BAs, DBAs and backend-devs
They are looking for someone who has the...
C# .Net Developer
Lava Lamp is ramping up for growth! An innovative, growing software development start-up, with clients who focus on innovation, social networking and mobile technologies. We are seeking a motivated, mature .NET developer/architect to complement our technical team. We’re...
Hi all.
I'm struggling with an SQL query from a particular table. The table is normalised, containing addresses. For the sake of argument, let's call the Table Address.
Address has within it a few fields: AddressID, Line1, Line2, Line3 and AddressType. AddressID is the PK. AddressType is one...