Every query has a common block:

FROM dbo.RequestorToCapabilityDeferred_vw r

INNER JOIN dbo.Capability_tbl c ON r.capabilityId = c.capabilityId

LEFT OUTER JOIN dbo.CapabilityStatus_tbl CS on r.capabilityStatusid = CS.capabilityStatusid

It should be made into...

Leave it.

Forget about it.

I found the new BOL absolutely useless.

Google may not be perfect, but at least it gets you what you need...

You must have a mapping table between varieties of flavors and "flavor groups" (or how do you name it).

When you say "all chocolate flavors" you mean "chocolate", "chocolate swirl", etc....

For non-clustered indexes you may create pairs if identical indexes and disable one of them.

Then you run something like this:

IF INDEXPROPERTY(OBJECT_ID('dbo.TableName'), 'IX_Index1_Odd', 'IsDisabled') = 0

BEGIN

ALTER INDEX IX_Index1_Even ON dbo.TableName...

David Hall-426383 (3/22/2016)

---

I have an nvarchar column called rptnum in a table that I have created a .NET routine to insert a report number. This is built by getting the...

Or - eliminate the variable @Result completely:

declare @List varchar(max) = '123456789'

declare @ChunkSize int = 3

declare @SepChar char(1) = ','

SELECT STUFF((

SELECT @SepChar + SUBSTRING(@List, N, @ChunkSize)

FROM dbo.Tally t

where

N >= 1...

kuopaz (3/22/2016)

---

Ended up with this, that is closer to my actual requirement. Previously used a WHILE loop and counter.

declare @List varchar(max) = '123456789'

declare @ChunkSize int = 3

declare @SepChar char(1) =...

ColdCoffee (3/18/2016)

---

Hello folks.. i have the following requirement (the table names are modified) :

1. For every row in OrderDetails table with ActionCode not equal to 'V' , check the last...

This should be incredibly faster:

SELECT StatusName PNRStatus from dbo.Status S

WHERE EXISTS (SELECT * FROM [Transactions] T WHERE T.[PNRStatus]=S.StatusName)

ORDER BY PNRStatus

SELECT [AgentID] from dbo.Agent A

WHERE EXISTS (SELECT * FROM [Transactions]...

- and a clustered index with this column in the first position.

select

datepart(yyyy, D.Date)as "Year",

count(*)as "A",

sum(DV.PageCount)as "B"

FROM [DB].[dbo].[Test] D with (nolock)

INNER join (

SELECT TestumentID, TestumentVersionID, PageCount, ROW_NUMBER() OVER(PARTITION BY TestumentID ORDER BY [TestumentVersionID] DESC ) RN

FROM [DB].[dbo].[TestVersion]

) DV with (nolock) on...

INNER JOIN dbo.fnMyFunction('2016-3-21') F ON F.ColumnName = OtherTable.ColumnName

dbo.fnMyFunction must be a table function to be used in a JOIN.

Plagiarist!!!

:w00t:

As for CHAR(0) - well, it's actually a character,...

ScottPletcher (3/17/2016)

---

I don't see that. A middle name of '' should mean the person has no middle name (and that such fact is known); a middle name of NULL...

Not sure if there is much of a difference here.

Scoping - yes, quite different.

Can you name anything else?