On 6/25/2010 6:03 PM, Darren New wrote:
> Err, no. The point of my question was that I don't know it's ratings,
> publishers, etc. All I know is that there are tags.
>
> Think of (say) ID3 tags, or arbitrary user tags. I know how to store
> that in SQL. I want to know how to make arbitrary queries against the
> data. Or, rather, how best to represent arbitrary queries.
>
> Or, in other words, what would you use to store
>
> WHERE Publisher = "Warner Brothers"
> AND Language IN("Arabic","French")
> AND Rating != "R"
> AND Media IN("DVD","VHS")
>
> into relational tables rather than a stored procedure?
>

You want to store the results into a new table? I think SELECT INTO does 
that.


-- 
http://isometricland.com

Post a reply to this message