RE: Whose Fish? RDBMS Solution

I decided to try this, as an SQL exercise. I took
me a couple of hours to get right, and I'm not entirely
happy with my solution, so I'm going to post the entire
thing. Comments are interspersed, especially where I think
I've done something particularly awkward. I'd appreciate
any suggestions you may have on how to make this solution
cleaner, or even on completely different (yet still legal
SQL) approaches.

Nice job Mark! That is a very creative solution!
How long does it take to process?

Jordan


.

Relevant Pages

  • Re: regex find then replace - a cleaner approach?
    ... but there must be a cleaner way without having to repeat the ... there is a successful match. ... you're not using placeholders in your SQL. ...
    (comp.lang.perl.misc)
  • Re: How can I merge two pairs of fields into 1 pair of fields
    ... I have managed to get my Columns just how I need them with this SQL: ... 'Don't Show' command with SQL which will use the field, ... cleaner if it wasn't there in the first place. ... I tried doing it with a Union query, but I think that only works on 2 ...
    (microsoft.public.access.queries)
  • Re: How can I merge two pairs of fields into 1 pair of fields
    ... On Oct 28, 5:13 am, efandango ... I have managed to get my Columns just how I need them with this SQL: ... 'Unused' column from the results grid, I suppose the SQL needs to use the ... cleaner if it wasn't there in the first place. ...
    (microsoft.public.access.queries)
  • Re: Insert date 1900-01-01
    ... > Regardless, it is a lot cleaner using parameters... ... >> I think you should also transform your string in datetime format ... >> by sql. ...
    (microsoft.public.dotnet.framework.aspnet)