Sioban Krzywicki (1/21/2015)

---

Anyway, hi! I'm Sioban. Sioban Jeanne Krzywicki. If you want the full name (that it'll be as soon as I finish all the legal paperwork, probably a month...

SELECT *

FROM @table t

WHERE EXISTS (SELECT 1 FROM ufn_CSVToTable(@Filter, ',') s WHERE t.csv LIKE '%'+s.String+'%')

SELECT *

FROM @table t

WHERE EXISTS (

SELECT 1 FROM ufn_CSVToTable(@Filter, ',') s1

INNER...

More or less...

The execution plans won't be identical because the queries aren't identical.

Use a variable for your date filter and you can use the exact same query (and hence exact same execution...

You've been around here for a little longer than I have 😉

Jeff Moden (1/19/2015)

---

Although Chris' code does what you want, I'm not sure it does what you actually need. Yes, it works correctly (haven't run it but looks correct). If...

richardmgreen1 (1/19/2015)

---

Thanks for that Chris.

I might be back for some extra help when I start changing it slightly to add in all my other fields (and quite possibly for an...

Hi Dan, have a look at the execution plan, the leftmost operator, SELECT. Rightclick to raise the properties tab. Look for something like "Reason for early termination..." and post the...

Your spec is a little ambiguous and quite tricky to follow. Hopefully this will give you some ideas. iTally is an IBG-style inline tally table which will generate just as...

This might not be the most efficient way of solving the puzzle, but it does generate the correct results - which I always put before performance or code sophistication:

DECLARE @SAMPLE_DATA...

GilaMonster (1/16/2015)

---

Brandie Tarvin (1/16/2015)

---

GilaMonster (1/15/2015)

---

Sean Lange (1/15/2015)

---

I am having a discussion with somebody who swears that using

EXISTS(select 1

is way faster than just select *. I know Gail has an...

There will be a performance impact, whether or not it's significant is a different matter - but you could test this with little effort by timing an update to a...

Note that the trigger you posted will work for single-row inserts only. Something like the following will handle batch inserts/updates:

BEGIN

SET NOCOUNT ON

SET XACT_ABORT ON

SET ARITHABORT ON

IF TRIGGER_NESTLEVEL() >...

Please post the trigger code.

Potato