Just use CROSS APPLY to introduce the expression, and then you can just give it a name you can reference.

Here's a quick example illustrating it:

SELECT object_id,

...

From https://msdn.microsoft.com/en-us/library/ff878601.aspx about ALTER AVAILABILITY GROUP...FAILOVER:

(my emphasis)

The problem is as...

There are leading tabs in some of the data.

For example, the [Mailing Address Line 1] that seems to be 'North Middlesex University Hospital NHS Trust' is actually that same...

That first part is not true. If the function returns NULL, then PARSE will return...

As you note, the first restricts results to step_id=0, while the second restricts results to step_id<>0.

That's the most likely cause of a discrepancy I can see. A single job...

That would likely be because your drop did not get triggered.

If you are not executing in the context of tempdb, then scoping the object reference to tempdb is actually...

RVSC48 (9/21/2016)

---

I would replace this: INSERT INTO tempdb..#members_roles(RoleName, MemberName)

with INSERT INTO tempdb..members_roles(RoleName, MemberName) - taking out the # because it is not needed but implicitly implied. Also take...

When referencing a temporary table, there's no need to specify that tempdb is the database.

You'll get that message anytime you attempt to do so (so all the references to...

Eh? How would you expect that? The filter is for anything less than or equal to the date...

If that is the correct logic for your requirements, that should work as well as anything else.

On that note, if you run the report right now, what is the latest...

SQLPain (9/20/2016)

---

Thanks Everyone.

So basically because of the precedence rule the following would end up giving me the same result?

L.FundingDate <= CONVERT(VARCHAR(10),GETDATE()-30,101)

L.FundingDate <= GETDATE()-30

Also would the following give out the...

John Mitchell-245523 (9/20/2016)

---

Mike

I know technically a...

A couple points are worth mentioning.

1) From a "how it gets used in query plans" perspective, there will be little difference between a clustered index with the key on ID...

When you convert both datetime values to varchar, you're doing a string comparison.

The format you've chosen in the convert function converts the datetime to string in the format 'mm/dd/yyyy'.

Doing...

Phil Parkin (9/16/2016)

---

Jacob Wilkins (9/16/2016)

---

Sean Lange (9/16/2016)

---

Eirikur Eiriksson (9/16/2016)

---

Sean Lange (9/16/2016)

---

Eirikur Eiriksson (9/16/2016)

---

ThomasRushton (9/16/2016)

---

Thom A (9/16/2016)

---

ThomasRushton (9/16/2016)

---

Sean Lange (9/16/2016)

---

BWFC (9/16/2016)

---

jasona.work (9/16/2016)

---

Thom A (9/16/2016)

---

ThomasRushton (9/16/2016)

---

These posts offering ways to get rid...