Viewing 15 posts - 16 through 30 (of 44 total)
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...
April 26, 2007 at 10:37 am
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 ...
April 25, 2007 at 6:23 pm
Any suggestions how to accomplish this.
Thanks in advance.
April 25, 2007 at 9:58 am
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 ...
April 18, 2007 at 12:28 pm
Thanks for the reply. I need to display the details of the parent and all related child nodes.
Thanks
Sam.
April 17, 2007 at 8:23 am
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...
April 16, 2007 at 6:49 pm
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...
April 12, 2007 at 11:30 am
Can you give me an example to the scenario. Thanks.
April 12, 2007 at 10:24 am
Hi Peter,
I tried the following
SELECT t1.PART_ID,t1.DATE,t1.PART_CD,t1.
March 29, 2007 at 11:02 am
Thanks Peter. let me try again. Thanks again.
San.
March 29, 2007 at 9:58 am
Viewing 15 posts - 16 through 30 (of 44 total)