Forum Replies Created

Viewing 5 posts - 1 through 5 (of 5 total)

  • RE: CREATE and ALTER Indexes in MSSQL 2000

    Creating an index is pretty easy.

    CREATE INDEX index_name

    ON table_name (field_to_index)

    Is this what you were looking for?

    Caz

  • RE: Help with formating a QUERY ???

    Heya... I would look further into your database design.

    There are things called primary keys, with the way you have set this your table2 looks something like a lookup table which...

  • RE: Query Help

    Craig wins it...

    There is an issue in parsing upper and lower case and collation.

    Regardless... sitting down with a database plan cures all!!

    Caz

  • RE: Query Help

    Yo,

    With only that information you have given me I am gonna put money on the select DISTINCT is the issue - SQL normally works top to bottom hence the sequential...

  • RE: A simple report count errors

    I have a sideways solution to this.

    I just made a heap of datasets, one for each piece of data I wanted to represent and then edited this query slightly each...

Viewing 5 posts - 1 through 5 (of 5 total)