Hi All,

i know its being long time... I resolved the issue. This is an update to all...

For passing an ntext (2000) value to an xml datatype(2005), there needs to...

hey,

these sounds gr8!!! thanks.....

I do agree that primary key clustered is not a good suggestion for an identity column, instead this can be done as primay key nonclustered and other valid column with...

Can i have sme more suggestions on this....

Hi,

Kindly let me know whether my understanding is incorrect...

A word regarding the environment, the database comes to around few GBs and daily reindex process is done!

If we are having an...

select

 c.source

 ,c.cnt

from

 TempTable c

JOIN (select

  a.Contributor

  ,a.source

  ,count(*) As CCount

 from

  TempTable a

 left join TempTable b ON a.Contributor = b.Contributor

    and a.source >= b.source

 where

  b.Contributor is not null

 group by

  a.Contributor

  ,a.source) d ON d.Contributor = c.Contributor

    and d.source = c.source

order by

 d.Ccount...