Jeff Moden (3/13/2008)

---

No... no way to create a temp view. Creating a TempTable to hold what the TempView would have contained is the next best thing and pretty darned...

Kiran

You should read the topic "Cardinality estimation" in Books Online. If there's anything you don't understand, or if it doesn't cover everything you need to know, please post again....

Does this work where the foreign key constraint consists of more than one column?

John

What have you tried so far? It would also help if you were to post the DDL for your table(s) and some sample data.

Thanks

John

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...