Four thousand plus points....

Anyway, could I possibly prevail upon the folks around here to do a little testing for me please. I've...

"Enter your text here ""

If you enter the code above without the " you get

This

To just post the link enter it as below

""http://dba.stackexchange.com/questions/77016/how-to-obtain-sql-feature-list-from-the-command-line""

Now I really am confused, I'm definitely misunderstanding something.

I thought CreatedOn was in the format yyyy-mm-dd hh:mm:ss.ttt. Where does the string come from?

If your dates are stored as

2014-09-26 14:25:51.310

2014-09-26 12:46:42.647

2014-09-24 14:49:35.190

2014-09-24...

Good spot Chris. I'd mentally accounted for it but forgot to actually write it in.

create table #Test

(

CreatedOn datetime

,ID int identity(1,1)

)

insert into #test

select '2014-09-26 14:25:51.310' union all

select '2014-09-26 12:46:42.647' union all

select '2014-09-24 14:49:35.190' union all

select '2014-09-24 12:39:21.150' union all

select '2014-09-19 15:22:36.233' union all

select '2014-09-19...

I'm struggling to understand what you need. Is that the only row you need returning? Can you post some sample data please.

What exactly is the problem? You need to be very careful using BETWEEN with datetime. You're much better using >= and <=.

Lynn Pettis (9/25/2014)

Sean Lange (9/25/2014)

Hi Bill,

thanks for the Series. I've struggling with an odd problem with comparing the results in Excel. When I copy the filtered results across and apply the Auto-Average...

Colon

Ouroboros

Bite

If you change the fixed date to getdate() or the time you ran the report it will round the hour to the start of that hour for the start date...

StartDate = dateadd(hh, datediff(hh, 0, '2014-09-24 08:30:00.000') - 1, 0)

EndDate = dateadd(hh, datediff(hh, 0, '2014-09-24 08:30:00.000'), 0)

Does that do what you want?