You're not going to get anywhere by shouting. I don't even see a question in your original post, so what is it that you're asking?

Please start off by posting...

Then Jason's query should work. How about the results of this?

SELECT TOP 20 OutStartDate + OutStartTime, OutEndDate + OutStartTime

FROM vwOutofOffice

Have a look at the results and see if they...

Martin

It's so much more complicated when you separate out date and time. Please will you post the results of this query:

SELECT TOP 20 OutStartDate, OutEndDate

FROM vwOutofOffice

Thanks

John

No. Probably the easiest way is to create a temp table with an identity column, insert your rows into that, then select from it.

John

Martin

Now I'm confused. If you're storing OutStartDate and OutEndDate as datetime, why do you need OutStartTime and OutEndTime?

John

Martin

Do you have the option to change the view so that it gives the date and time in one value? If you can do that then a simple BETWEEN...

Luis

Each one of your insert statements returns "Error converting data type nvarchar to numeric." Sorry but I don't have time to find which of the columns this is happening...

Try it for yourself. Run the following code:

create table #MyTable(t int)

then create a new connection to the database and run the same code again. Now run this query:

SELECT...

Luis

Thanks for that, but we still need DDL and sample data so that we're not guessing at what's going on. For instance, the data type of the conta column...

That won't work... try parsing it. The correct syntax is the one that...

Roy Ernest (2/27/2008)

I beg to disagree on that. A wrong query plan does not always happen due to Paramater sniffing. It can happen when the Statistics are out of date...

Since a view doesn't take parameters,...

Luis

Please will you post DDL for your tables in the form of CREATE TABLE statements, sample data in the form of INSERT statements, the results your query is producing, and...

JMSM

Try experimenting with the date style parameter in the CONVERT function. This may prevent the "out of range" error eppearing.

John

Sounds like something you would want your app, rather than SQL Server, to do. Put please will you post table definitions in the form of CREATE TABLE statements and...