Re: Help with JOins

Tech-Archive recommends: Fix windows errors by optimizing your registry



On Thu, 16 Oct 2008 11:11:02 -0700, Farhan wrote:

Hi,

I have these queries and i want to JOIN all of them to make one query.
(snip)

Hi Farhan,

For questions such as these, the usual recommendation is to post the
following information:

* The structure of all tables involved in the problem. Please post as
CREATE TABLE statements, including all relevant columns, all
constraints, and all indexes.

* Some well-chosen rows of sample data to demonstrate the problem,
posted as INSERT statements.

* Expected results, and ideally a short description of the underlying
business logic.

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

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
.



Relevant Pages

  • Re: Extracting Duplicates from SQL Server 2000
    ... Here is the query that I used. ... a few well-chosen rows of sample data (as ... My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis ...
    (comp.databases.ms-sqlserver)
  • Re: DataTable.select problem with variables
    ... matching that query, because for each of your test rows, s1=s2. ... problem from sql server 2000 ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: CONTAINS performance
    ... That said, and with the query plan, I can start to give you more ... relational join in the context of the free-text optimization, ... SQL Server tables. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Indexing Service, Openquery and sp_executesql
    ... SQL Server version and sp are you running? ... > data from the indexing service catalog when pasted into ... > query analyzer, but failed when put against sp_executesql ... I would choose Microsoft Indexing ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Problem using Access or Query Designer to run queries in SQL Serve
    ... >or Query Designer within Enterprise Manager, it works and I get data back. ... >ODBC Call Failed [ODBC SQL Server Driver] Timeout Expirederror in Access ... >[ODBC SQL Server Driver] Timeout Expired ...
    (microsoft.public.sqlserver.odbc)