Forum Replies Created

Viewing 15 posts - 16 through 30 (of 44 total)

  • RE: Tree View Data Report

    Any help would be greatly appreciated. Thanks.

  • RE: Tree View Data Report

    Thanks Carl for the reply. Here is the sample data and DDL.

    CREATE TABLE [Group] (

     [PkID] [int] IDENTITY (1, 1) NOT NULL ,

     [Desc] [nvarchar] (30) COLLATE SQL_1xCompat_CP850_CI_AS NULL ,

     [Type] [int] NULL...

  • RE: Tree View Data Report

    Thanks for the reply.

    But my structure of the table is something like this

    GROUP     PRODUCT

    ID              ID

    GROUP_ID    GROUP_ID

    NAME         NAME

    DESC         DESC

    DATA FOR TABLE GROUP

    1    0    FOOD    FOOD

    2    0    DRINKS  BEVERAGES

    3    0    OTHERS  OTHER

    4   ...

  • RE: Tree View Data Report

    Any suggestions how to accomplish this.

    Thanks in advance.

  • RE: Tree View Data Report

    Any help would be greatly appreciated. Thanks.

  • RE: Tree View Data Report

    Thanks. My table structure is something like this.

    GROUP                              PRODUCT

    GROUP_ID                    GROUP_ID

    DESC                          DESC

    TYPE                          CODE

    I need to display the details in a report format or export to excel.

    Drinks           general       Food

        Hot Drinks    Drinks    ...

  • RE: Tree View Data Report

    Thanks. This works for 2000 too.

  • RE: Tree View Data Report

    Thanks for the reply. I need to display the details of the parent and all related child nodes.

    Thanks

    Sam.

  • RE: Tree View Data Report

    Thanks for the reply. I am displaying the data in the front end using Tree view control. I need to export the data to excel or display the data in...

  • RE: Tree View Data Report

    Any help would be greatly apprecited.

    Thanks

    Sam.

  • RE: Error when subtracting two columns

    Thanks so much.

  • RE: Error when subtracting two columns

    Thanks Aaron. But when I used the datediff and ran the query it fecthed "n" number of rows and I compared the same with Access query and there is a...

  • RE: Error when subtracting two columns

    Can you give me an example to the scenario. Thanks.

  • RE: Eliminate Duplicate rows

    Hi Peter,

       I tried the following

    SELECT t1.PART_ID,t1.DATE,t1.PART_CD,t1.

  • RE: Eliminate Duplicate rows

    Thanks Peter. let me try again. Thanks again.

    San.

Viewing 15 posts - 16 through 30 (of 44 total)