create table dbo.Dates ( Id int not null constraint Dates_Id_PK primary key clustered (Id), [DateValue] date not null }
create table dbo.Posts ( Id int identity not null constraint Posts_Id_PK primary key clustered (Id), Created datetime not null, Title nvarchar (200) not null )
How can I get a table that has the column DateValue from Dates and the number of Posts with that date.
I need to match the datetime Created value to the date DateValue.
Match Dates and Count
Posted - 10/04/2012 : 20:30:52
