Re: Inner join weirdness in DTS

There's not much to add except SELECT <list-of-cols>. It happens
whether I select three or four columns or the whole twenty or so.

Used a WHERE clause to define the joins for now but I'm still curious
why SQL Server generates code that it then throws out.

Andy

.

Relevant Pages

  • Re: recursive function
    ... Im afraid the solution must work for both Access and SQL Server ... Andy ... Prev by Date: ...
    (microsoft.public.dotnet.languages.vb)
  • RE: Migrating from Access to SQL Server 2000
    ... "Andy DF" wrote: ... > I need good source of information on converting an Access db to SQL server ... Prev by Date: ...
    (microsoft.public.data.ado)
  • Re: What is the best way to work with SQL SERVER data / tables?
    ... with the appropriate WHERE clause that restricts the dataset. ... * Security, Security, Security; I guess one couldn?t use Windows ... SQL Server and presto, everything would be available to him/her without ... INSTEAD OF triggers can be created on a view to make a view updatable. ...
    (comp.databases.ms-access)
  • Re: ORDER BY in VIEW not working
    ... an ORDER BY clause returned ordered results. ... queries against the view or function that return data and those queries ... SQL Server 2000, determine what the row order might be and then ensure ... Whenever possible please post enough code to reproduce your problem. ...
    (comp.databases.ms-sqlserver)
  • Re: Near Clause usage
    ... NEAR clause using CONTAINS? ... Looking for a SQL Server replication book? ... Looking for a FAQ on Indexing Services/SQL FTS ... get the exact words I m looking for within my NEAR clause: ...
    (microsoft.public.sqlserver.fulltext)