Have a cup of coffee, hang out, and talk SQL Server. Everyone is welcome.
Mike Bregman's Page
Profile Information
- Relationship Status:
- Married
Mike Bregman's Blog
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
Posted on October 20, 2008 at 5:25pm — 1 Comment
About
© 2009 Created by Chuck Boyce on Ning. Create a Ning Network!
Comment Wall (1 comment)
You need to be a member of SQLServerDVD.com to add comments!
Join this Ning Network