Re: Sequel query pulling up duplicate data

From: Anith Sen (anith_at_bizdatasolutions.com)
Date: 09/27/04 

Date: Mon, 27 Sep 2004 11:46:55 -0500

Can you post your query & the underlying tables along with a few sample data
which illustrates the problem? 

-- 
Anith

Relevant Pages

  • Re: Indexed View is not being used for few instances
    ... this query, and the nonclusted index starts with column Table_B.ColumnA, ... it is a choice between scanning the entire indexed ... view or to execute the underlying query. ... Adding an index on Table_A.ColumnA could help your queries. ...
    (microsoft.public.sqlserver.programming)
  • Re: UDF and SQL2000 - Why doesnt this work?
    ... Basically This is what I want to do - I have created a query ... as DDL (i.e. CREATE TABLE statements; ... Sample data that illustrates the problem, ... Expected output from the sample data supplied; ...
    (microsoft.public.sqlserver.programming)
  • Re: New to SQL and trying multiple table joins
    ... > Can't be certain of how to write this query for you without DDL (CREATE ... Previous msg edited plus added in keys, and sample data at end. ... EmpAvailID (Primary Key), EmpID, EAMonthID(Foreign ... AbilityID, EmpID, MainAbility ...
    (microsoft.public.sqlserver.programming)
  • Re: find missing time periods
    ... User and UserShiftStart in sample data, ... I believe your unmatched query actually ... FROM [Time Periods], Splits; ...
    (microsoft.public.access.queries)
  • Re: calculated field - Access 2003
    ... When I asked for sample data, I meant for you to show me ... I would normally use "criteria" filters for this type of application, ... lookup table containing site names and the PDx ... This will allow you to do a query like ...
    (microsoft.public.access.queries)