Re: Where and Union Clauses

On Tue, 23 Aug 2005 13:17:08 -0700, Fez wrote:

>I am having a little problem creating this query.
(snip)
>Thanks in advance.

Hi Fez,

I'm not sure if I understand what you are trying to achieve. A better
way to explain would be to post CREATE TABLE statements (including
constraints and properties), INSERT statements with some sample data and
expected output. Include the code from your last attempt and the results
of running that code as well.

See www.aspfaq.com/5006 for more details.

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)
.

Relevant Pages

  • Re: get the correct datatype
    ... If you wish to get the exact datatype, you can query a table by opening ... Prev by Date: ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Nearest Common Ancestor Report (XDb1s $1000 Challenge)
    ... >> only one active application (Query Analyzer). ... I did notice that both the data and log files for the ... but with the options SET STATISTICS TIME and SET STATISTICS ...
    (comp.object)
  • Re: internal handling of views
    ... (because the data element is the same). ... they usually mean thats not what it truly is, or they would have use IS ... not merely merging a select query. ...
    (comp.databases.oracle.misc)
  • Re: need procedure for exporting from Access to Excel
    ... >> duplicated in Excel. ... >> 1) build and execute a SQL query that selects the record in the Access ... create an append query that appends records from the Access table to ...
    (microsoft.public.access.externaldata)
  • Re: Range query optimization help?
    ... > instead of the 10+ hours that the naive query took. ... Well, since your problem is a common range lookup problem, the query was ... If this index is not automatically used in the correlated subquery, ...
    (microsoft.public.sqlserver.programming)