115 reputation
2
bio website
location
age
visits member for 2 years, 10 months
seen Dec 4 '13 at 16:27

Jun
22
comment “For each group of results fullfilling condition X, select only result with smallest column value A”
Thanks for the info and the link. Unfortunately I find it very hard to search for DB-Related questions, unlike for coding questions. Usually I create my DB-schemas in a way that simple SQL is enough to solve my problems.
Jun
22
accepted “For each group of results fullfilling condition X, select only result with smallest column value A”
Jun
22
asked “For each group of results fullfilling condition X, select only result with smallest column value A”
Jun
22
awarded  Scholar
Jun
22
accepted SQL Server: join two tables with “valid-to” dates
Jun
22
comment SQL Server: join two tables with “valid-to” dates
"CROSS APPLY" was the keyword, I didn't know it. The example works like a charm and I could apply it to my problem. I will ask a new related, but different followup question. Thank you very much!
Jun
21
awarded  Student
Jun
21
asked SQL Server: join two tables with “valid-to” dates