Andomar

Netherlands

Age: 41

I'm a software developer at a telco supporting line-of-business applications. We use a variety of technologies from ASP.NET to Perl. I've come to appreciate SQL more over time, and I now spend most of my time in the database.

If you'd like to learn SQL properly, consider the free SQL course from Stanford. For more free online courses awesomeness, check out the list of courses on Coursera and EdX.

1d
awarded Nice Answer
2d
awarded Yearling
2d
awarded Yearling
Aug
25
comment Query multiple tables in SQL Server
Aah, so the trainee is related to the lead, not the manager, I've updated the query.
Aug
25
revised Query multiple tables in SQL Server
deleted 504 characters in body
Aug
24
comment Previous and Current Week Quantities JOIN Issue
This question is pretty chaotic now. Perhaps close this question and create a new question that's clearer. Only columns that matter, small rowset, example output, explanation of example output.
Aug
24
comment Previous and Current Week Quantities JOIN Issue
I've looked at the fiddle and comments, but I have a hard time figuring out what you're looking for. Could you try to create a simple example with say 5 rows, leaving out irrelevant columns? Provide an explanation for the output. In your current example, I have no idea 3612 comes from.
Aug
24
comment Access VBA Return 0 in grouping even if there is no match
Nice one, the zen of Access goes in strange paths, hehe
Aug
24
comment Access VBA Return 0 in grouping even if there is no match
You're right! I just Googled that you can simulate a cross join with a comma-separated list after from... does the updated answer work?
Aug
24
revised Access VBA Return 0 in grouping even if there is no match
deleted 16 characters in body
Aug
24
comment Query multiple tables in SQL Server
Added a query that does that. It only makes sense if there's no more than one trainee and no more than one lead per manager.
Aug
24
revised Query multiple tables in SQL Server
added 423 characters in body
Aug
24
comment Previous and Current Week Quantities JOIN Issue
One of the buttons on sqlfiddle is "link", this will put an URL in the browser's address bar that you can copy/paste here
Aug
24
comment Previous and Current Week Quantities JOIN Issue
Screenshots are not super useful, if I wanted to use them I'd have to type everything in again. Your update misses the source data in the tables #salescore and #presales, without which it is hard to tell what the problem is.
Aug
24
comment Previous and Current Week Quantities JOIN Issue
Best is if you can set up an example at sqlfiddle.com
Aug
24
answered Access VBA Return 0 in grouping even if there is no match
Aug
24
comment Previous and Current Week Quantities JOIN Issue
Your example output isn't helpful without the source data that is supposed to produce it
Aug
24
answered Query multiple tables in SQL Server
Aug
21
awarded Good Answer
Aug
20
comment Connection pooling vs persistent connection in ASP.NET?
That is the one and only BEST practice. Connection pooling makes reopening a connection very cheap.
1 2 3 4 5