This should be more efficient:

SELECT VisitID

FROM #Test

GROUP BY VisitID

HAVING MAX(CASE WHEN IsPrimaryCareProvider ='Y' THEN 1 ELSE 0 END) = 0

First, the Project table should be keyed on ( DomainID, SchoolID, ID ), if, as your example query implies, Domain is the more dominant "parent" relation. Reverse the first two...

Something like this should do it:

IF OBJECT_ID('tempdb.dbo.#table2_data') IS NOT NULL

DROP TABLE #table2_data

--create the table structure for #table2_data

SELECT TOP (0)

Application,

...

You have a couple of choices.

If you are willing to allow them to run any (local) job, you can add them to the SQLAgentOperatorRole in msdb.

If you want them to...

Is this acceptable? No.

Can this be improved? Yes.

Most importantly, you do not need an identity column on two of these tables. Despite what some people may imply, there's no...

The real solution is very likely to cluster the table on event_date, if that is how you most often query the table. You'll get minimum I/O without having to...

TheSQLGuru (11/8/2016)

---

I disagree on...

It depends on how complex the trigger logic and how much different it is for each type of modification whether you want separate triggers or not.

But you can definitely simplify...

drew.allen (11/3/2016)

---

ScottPletcher (11/3/2016)

---

You could try limiting the pattern matching to only the text between "[whitespace-char]WHERE[whitespace-char]" and the next occurrence of "GROUP BY" or "SELECT". Of course that's also not...

drew.allen (11/3/2016)

---

ScottPletcher (11/3/2016)

---

I avoid the ISNULL "tricks" when I can in favor of straightforward code:

UPDATE table_name

SET Foo = CASE WHEN Foo > '' THEN ', ' ELSE '' END +...

J Livingston SQL (11/3/2016)

---

which I believe is what...

You could try limiting the pattern matching to only the text between "[whitespace-char]WHERE[whitespace-char]" and the next occurrence of "GROUP BY" or "SELECT". Of course that's also not perfect, but...

SELECT

SD.NUMBERS

,RIGHT('0000000' + REPLACE(NUMBERS, '.', ''), 7)

FROM SAMPLE_DATA SD;

I avoid the ISNULL "tricks" when I can in favor of straightforward code:

UPDATE table_name

SET Foo = CASE WHEN Foo > '' THEN ', ' ELSE '' END + 'newvalue'

Sorry, don't have a lot of time, but here's my best guess at what could help:

SELECT i.Item_ID AS Kit_SID

, i.Item_ID AS Kit_ID

, i.Item_NO AS Kit_NO

...