What does "non sargable" mean?

I'm either going to wait for DDS or I guess the user will be getting a few empty emails.

Thanx.

Unfortunately, it's not available here.

This works fine. The admission data and appointment data come from different databases. I pulled that information together then, asked you to help with the final step.

Thanx again.

For example, UnitNumber, 289816, should have 3 records. Sorry again for the confusion.

UnitNumber, DischargeDate, AdmitDate

289816, 07/6/2014, 07/08/2014

289816, 07/10/2014, 07/21/2014

289816, 07/22/2014, 08/04/2014

Sorry for the confusion but, the DischargeDateTime should come before the AdmitDateTime. The patient is discharged from the hospital then, readmitted within 30 days. I screwed up the create table!

So,...

Pardon my ignorance but, what would be the correct syntax to see the next set of results after deleting from the CTE?

Thanx for the solution

Thanx for the solution

Thanx. Never gave that a thought.

Thanx. Time to bring out the pail and shovel

Thanx. My environment is basically reporting off of a DataWarehouse so, performance of the report/query is most important. Could I ask..........if the underlying table(s) is not indexed or poorly indexed...

Thanx.

Thanx.

Thanx. So, what's the advantage of adding an index to a view?