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.

13h
answered SQL: Get running row delta for records
14h
comment Proper database modeling for many-to-many relationship between records
That would work fine, a RaceResult has foreign keys to Driver, Division, and Race. Your example would result in multiple rows for the same race and driver, but with a different division.
14h
comment Access Query Showing Information from a city from a different state
Nice answer, +1. I'm pretty sure MS-Access supports multi-column joins.
14h
revised Proper database modeling for many-to-many relationship between records
added 34 characters in body
14h
comment Proper database modeling for many-to-many relationship between records
In your example, the Division entry would be Race-specific. Might be better to have a foreign key to both in the RaceResult table, I'll put the suggestion in the answer.
14h
answered Access Query Showing Information from a city from a different state
14h
answered Proper database modeling for many-to-many relationship between records
1d
awarded indexing
2d
comment expanding sql query for selecting top two rows based on rating criteria?
If you reviewed a movie thrice, you have also reviewed it twice. The question doesn't say "exactly twice".
Jan
28
revised Optimizer and query compilation
edited tags
Jan
28
comment Copy table from one server to another using select statement
When you create a linked server, there are many security options to choose from. If you have a question about those you'd better ask a new question.
Jan
28
comment Remove duplicates from inner join with one table
Try select distinct s1.id, ...
Jan
28
answered SQL Filtering on unique events and datetime
Jan
28
revised How to get the last day of month in postgres?
added 25 characters in body
Jan
28
comment How to get the last day of month in postgres?
Ok, was able to reproduce your problem. Updated answer works for me!
Jan
28
revised How to get the last day of month in postgres?
added 25 characters in body
Jan
28
comment How to get the last day of month in postgres?
If you already have a date object, there is no need to use timestamp() on it. Try the updated answer?
Jan
28
revised How to get the last day of month in postgres?
added 185 characters in body
Jan
28
comment How to get the last day of month in postgres?
For me it works with a numeric argument... which version of Postgres are you using? Does to_timestamp(act_dt::float) work? Where ::type is a Postgres type cast.
Jan
28
revised How to get the last day of month in postgres?
added 77 characters in body
1 2 3 4 5