Eirikur Eiriksson (10/19/2014)

---

On the contrary, it is very useful as it respects the left outer join, which in essence return all records from the right hand side and only those...

KoldCoffee (10/19/2014)

---

in Eirikur's example the LEFT JOIN with the AND returns everything.

In the Adventureworks example:

The LEFT JOIN with the WHERE returns 9 records.

The LEFT JOIN with the AND...

The best thing you can do is see what is the difference between the query you posted and one where you believe the WHERE clause should begin.

I don't have the...

homebrew01 (10/18/2014)

---

I do it this way. I run a script to generate the commands so I can verify I get the right ones. I script "Results to text", then copy-paste...

happycat59 (10/16/2014)

---

This should get you started...

select 'DROP PROCEDURE [' + routine_Schema

+ '].[' + routine_name + ']'

FROM INFORMATION_SCHEMA.ROUTINES

where routine_name like 'Easy_UpdateSchemaTemp%'

this will output the drop procedure statements you need. ...

Kummu (10/16/2014)

---

Thanks for your reply.

I'm using SQLSafe for backups, when recovery model is changed from simple to full or full to simple and then try to run a diff/log my...

I am using IE10.0.9200.17089 and I have...

UDBA (10/15/2014)

---

How can i calculate datediff (in minutes) between two consecutive rows without using CTE & Temp tables?

I was using this successfully, but i need something without CTE and temp...

Steve Jones - SSC Editor (10/14/2014)

---

Unbelievable. Giants can't score, not even a FG, SD decides not to play defense against the Raiders, and Manning has a pedestrian day, ignoring Sanders...

Luis Cazares (10/14/2014)

---

Lynn Pettis (10/14/2014)

---

Without seeing the table structures (columns and definitions) or the execution plan (which will show what is happening) not much we can do to help.

It could...

Without seeing the table structures (columns and definitions) or the execution plan (which will show what is happening) not much we can do to help.

It could be implicit data conversions,...

Could you post the DDL (CREATE TABLE statements) for the tables?

I agree with Jeff on this. Switching from the full recovery model to the simple recovery model and back breaks the log chain. It would be helpful to...

Just checking, but have you had issues with this procedure before? The beginning of the proc is very familiar with all the date calculations at the start.

Both query plans...

Okay, using your sample data, query, and function as a basis to work from here is what I put together.

First, a rewrite of your multi-statement table valued function as an...