Re: Doing multiple joins on one table

On Mon, 4 Sep 2006 14:21:39 +0200, Yaniv Danan wrote:

it doesnt work , it returns always the same max count() for all the rows

Hi Yaniv,

There's neither a max nor a count() in my solution, so I have no idea
what "it" refers to, not how or why it "doesn't work".

To get better help, it's advisable to post table structure in the form
of CREATE TABLE statements (omitting irrelevant columns, but including
all constraints, properties, and indexes), sample data in the form of
INSERT statements (not housands of rows, but just a few rows of data,
carefully chosen to illustrate the problem), and expected results based
on the sample data provided.

Also, check out www.aspfaq.com/5006.

--
Hugo Kornelis, SQL Server MVP
.

Relevant Pages

  • Re: Custom Sorting a DataTable Using DataGrid
    ... I think the code in the previous post does work to sort according to string ... the length sorting for the generated data is the same as the default ... If you use this loop to generate the sample data, ... give different results and thus better illustrate the idea. ...
    (microsoft.public.dotnet.framework.windowsforms.controls)
  • Re: Auto Number
    ... Please post DDL, so that people do not have to guess what the keys, ... constraints, Declarative Referential Integrity, datatypes, etc. in your ... Sample data is also a good idea, ... two column key. ...
    (microsoft.public.sqlserver.programming)
  • Re: Need Case Based Query for This Situation
    ... Please post DDL, so that people do not have to guess what the keys, ... constraints, Declarative Referential Integrity, datatypes, etc. in ... Sample data is also a good idea, ...
    (microsoft.public.sqlserver.programming)
  • Re: Copying data from one row to another within the same table.
    ... > including keys and constraints), sample data INSERTs and show your ...
    (microsoft.public.sqlserver.programming)
  • Re: ORA-00001 on non-unique index!
    ... Post the DDL for the table and all of its indexes and constraints so we can try it out in various versions. ... A few rows of sample data the produce any problem you think data related ... Puget Sound Oracle Users Group ...
    (comp.databases.oracle.server)