Re: Find between a list of values

[Quoted] Il giorno sabato 31 marzo 2018 14:40:13 UTC+2, Jerry Stuckle ha scritto:
> The first thing you need to do is normalize your database. One value
> per row/column. If I read this properly, you should have a second table
> linked to the first with three columns - id of the first table row,
> start and stop. You may add a fourth column for a unique id of the row.

[Quoted] [Quoted] Sure, and where i can, i've started to normalize the database. But that's not easy but is what I'm already using with already normalized tables.

I've asked here thinking about a workaround, to speed up lookups on existing tables planned for a future refactor. Received on Sun Apr 01 2018 - 19:01:53 CEST