Does it means that in clustered index, index pages are directly linked to data pages , which are sorted on the basis of index key.

As non clustered index is maintained as a separate B tree structure that has pointer in form of file id, page no,and row no. where as in clustered index the...

Thanks .. a lot.. one more thing ....

do clustered index has an index table?

As per me it dint?

So, a unique key with not null defined on it can't be used to link to foreign keys.

In many portals I read that the difference is that primary key by...

Hi,

Do u have Raid implemented.

Regards,

Ahmad

Hi,

Please list the steps u performed in doing the same...

have u assigned default database?

Regards,

Ahmad

Hi,

Someone one sujessted me that I am in wrong forum...ishud post my problem in sql 2000 forum....so i did that only....after my post in onther.

Any ways thanks for the valuable...

Hi,

That was not rude...I acknowledged the efforts of each and every person who contributed to my post.....

I just said that i got that very solution in books online ..........also...

Hi,

Thanx for the help.....I was running sql 2005 express edition client....but the server version is 2000.

I already worked out the given solution from BOL......

Thanks any ways......

Hi,

compatibility level is 80.

thanks,

Ahmad

Hi,

It's not working I am getting the same error .

Msg 170, Level 15, State 1, Line 9

Line 9: Incorrect syntax near 'PIVOT'.

Thanks,

Ahmad

Hi,

Fyi.....

SELECT prodmaincat

, [1] AS January

, [2] AS February

, [3] AS March

FROM...

Hi,

I tried this on sql 2005 express edition...

its not working

Hi,

I am getting an error ... "Msg 170, Level 15, State 1, Line 9

Line 9: Incorrect syntax near 'PIVOT'.

Is pivot is command in sql 2000.

Pls help.

Hi Maz,

select z.category,x.count(distinct customers) as cnt, y.sum(sales) as sales from

x inner join y on x.id=y.id

inner join z.ide=y.id

union

select 'Total', sum (Q.cnt), sum(Q.sales) from

(select z.category,x.count(distinct customers) as cnt, y.sum(sales) as sales from

x...