I haven't had the opportunity to...

Not all of us that got it wrong misunderstood the question. Some of us learned/were reminded of something today... like why I always seem to use INSTEAD OF triggers.

:blush:

mister.magoo (1/10/2011)

---

mounish (1/10/2011)

---

Well, Even though I am not good at using CT Expressions, According to my knowledge, the following should work. But, if I try this, Its showing error "FROM...

Heh, and if you can't easily compare what you have to Lutz, it sounds like you've buried this in a larger query... can...

If this isn't the first statement in the batch, you need a semicolon.

Change:

WITH cte AS

to:

;WITH cte AS

Having COUNT(*) > 3?

There's a number of solutions out there, but the problem is you have to know what you're looking for.

For example, the First-In First-Out logic (FIFO)

Google: SQL FIFO Inventory

This is from...

It was in the subtitle on the main page, it doesn't show here, unfortunately, and he didn't realize he'd need to repeat it in the first...

You can't use IF mid-query. IF is used for proc control, not mid-statement decisions, you want CASE for that usually, but neither here...

So this:

F @ContactType = 'Broker'

Begin

SET s.BrokerID =...

siamak.s16 (1/10/2011)

---

This was an oversimplified version of my proc. I wrongfully assumed that if I ask a question about the where clause, that people would answer the question about the...

To answer your question directly:

No, removing the 1=1 component in the where clause will not affect performance. As a matter of fact, 1=1 never does anything in the optimizer,...

Grant Fritchey (1/10/2011)

---

Craig Farrell (1/10/2011)

---

Grant Fritchey (1/10/2011)

---

This results in a merge join on just a few records. From what I can see, I'd try an index on the PastExperience table...

Ninja's_RGR'us (1/10/2011)

---

Craig Farrell (1/10/2011)

---

*nearly sprays his tea all over the monitor upon opening the execution plan*

Yikes. Wow. :w00t:

Now, THAT'S a Table Spool. Just the estimate, I know,...

An alternate solution would be to have a server trigger generate a Service Broker item, and then have the recieving queue do a send_db_mail. Or just have the trigger...

a_ud (1/10/2011)

---

I'm trying to import a view from a different database in SQL 2005. The tables already exist, so all I want is to import the view without recreating...