I can't believe that the "View is not ordered with an order by" thread is still going on. It's been thoroughly explained, and yet, still.....

And I would have to say that all 10 should...

Craig Farrell (12/16/2010)

---

Michael Valentine Jones (12/16/2010)

---

There are a lot of people that think that if you do a "select * from MyTable" that it will return data in order by...

Does this handle it for you?

(Since you posted on a SQL 2008 forum, I gave you a SQL 2008 response. Let us know if you're not on SQL 2008 for...

I take this to mean that you're going to read that link he suggested you read, and then to post your data...

First, we need to get that data into a table.

-- See how you start off by actually creating a table and then

-- inserting the data into it? Your doing...

itfbd (12/16/2010)

---

Hello Experts,

Below is the data from table :

EmpidDate PA

30001/12/201010

30002/12/201010

30003/12/201010

30004/12/201010

30005/12/201001

30006/12/201001

30007/12/201001

30008/12/201001

30009/12/201001

30010/12/201010

30011/12/201001

30012/12/201001

30013/12/201001

30014/12/201001

29101/12/201001

29102/12/201001

29103/12/201001

29104/12/201001

29105/12/201001

29106/12/201001

29107/12/201001

29108/12/201001

29109/12/201001

29110/12/201001

29111/12/201001

29112/12/201001

29113/12/201001

29114/12/201001

If i write query

select min(date) from EMP_ATTENDANCE

where emp_id = 291

and month(date) =...

You're welcome. Thanks for the DDL/DML - it makes it a lot easier on us!

bitbucket-25253 (12/16/2010)

---

Wayne I believe it was a good question, and I...

I think Microsoft prefers getdate().

CREATE TABLE #test (RowID INT IDENTITY, MyDate DATETIME DEFAULT (CURRENT_TIMESTAMP));

SELECT definition

FROM tempdb.sys.default_constraints

WHERE parent_object_id = object_id('tempdb..#test');

returns:

definition

-----------

(getdate())

Lamprey13 (12/16/2010)

---

I'll also add my disgust with ISNULL because of it's difference with the other IS... functions.. ISDATE returns a boolean... ISNUMERIC returns a boolean.. All is good witht he...

I'm assuming that since your @DateRanges table has times that can start during the day, that you don't want any part of a holiday.

This should take care of it:

;

WITH CTE...

Okay, I messed up. I posted the wrong code (the posted code was run to get the error message for the QotD). Then I went and gave the explanation based...

My second ever QotD is being published tomorrow. Can you'll let me know what you think of it please?

Craig Farrell (12/15/2010)

---

Actually, the WHERE 1=1 is a neat little trick to avoid doing extra if statements to determine if something starts the clause and needs an AND. Since...