StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
2442649
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2010-03-14T15:36:04.250
FavoriteCount
0
LastActivityDate
2010-03-16T02:10:36.457
LastEditDate
2010-03-16T02:10:36.457
LastEditorUserId
111934
OwnerUserId
111934
ParentId
2442623
PostTypeId
2
Score
3
ViewCount
0
LastEditorDisplayName
text
Body
I had a different interpretation of the question: "how to generate all the dates between a certain range?" Here's a solution to that: <pre><code>--define start and end limits Declare @todate datetime, @fromdate datetime Select @fromdate='2009-03-01', @todate='2009-04-10' ;With DateSequence( Date ) as ( Select @fromdate as Date union all Select dateadd(day, 1, Date) from DateSequence where Date < @todate ) --select result Select * from DateSequence option (MaxRecursion 1000) </code></pre> There is a nice <a href="http://smehrozalam.wordpress.com/2009/06/09/t-sql-using-common-table-expressions-cte-to-generate-sequences/" rel="nofollow noreferrer">article</a> that shows how to generate sequences (numbers, dates, times) using CTEs. <hr> Edit: After clarification, the issue seems to be the date format being input: dd/mm/yyyy. SQL Server expects the format mm/dd/yyyy. I would simply transform it before running the select statement: <pre><code>-- Assuming two variables, @inputFromDate and @inputToDate, in the format of dd/mm/yyyy... declare @fromDate varchar(10), @toDate varchar(10) set @fromDate = substring(@inputFromDate, 3, 2) + '/' + substring(@inputFromDate, 1, 2) + '/' + substring(@inputFromDate, 7, 4) set @toDate = substring(@inputToDate, 3, 2) + '/' + substring(@inputToDate, 1, 2) + '/' + substring(@inputToDate, 7, 4) select * from SomeTable where dateCol >= @fromDate and dateCol < @toDate -- you can change the < or >= comparisons according to your needs </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. PONeed to find date's between 2 date's in SQL Server 2008
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USJeff Meatball Yang
UserOwnerUserId
1. USJeff Meatball Yang
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. COYep, that's what I thought the OP meant too.
 singulars
 PostPostId
 PO
 UserUserId
 USMartin Smith
2. COthank's for the help, i need something simple select...#03/03/2010..between... and i need this kind of date format (dd/mm/yyyy)
 singulars
 PostPostId
 PO
 UserUserId
 USGold

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.