Have a cup of coffee, hang out, and talk SQL Server. Everyone is welcome.
count(distinct *) over(partition by *)
I just downloaded the new version of SQL Server 2008, which I thought was supposed to improve the over(partition by) clause... but i still can't seem to run the following query:
select count(distinct transactions) over(partition by accounts)
from table
Any help is appreciated.
Thanks,
Mike
select count(distinct transactions) over(partition by accounts)
from table
Any help is appreciated.
Thanks,
Mike
Comment
-
Comment by Paul Nielsen on October 22, 2008 at 10:12am - Sorry, but I don't believe there's any enhancement to Over() in SQL Server 2008. If you have a reference that indicates there might be an enhancement to Over() I'd love to see it.
About
© 2009 Created by Chuck Boyce on Ning. Create a Ning Network!
You need to be a member of SQLServerDVD.com to add comments!
Join this Ning Network