var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Query to return multiple date rows
Can someone please help with a query I have? Basically I want to return all rows in a table that have multiple date entries that are different. For example:
1636 1073746475 342 2005-12-30 00:00:00.000
1636 1073746475 359 2006-03-10 00:00:00.000
This security 1636 has two entries in the DB with different dates. They are lots of securities with multiple entries with the same date but I need a list of the ones with different dates. Any ideas please?
count(distinct datevalue) as datecount
group by security
having count(*) > 1
You handle all the tough questions...time to shovel snow
Thanks that's a great help, much appreciated!!!