This article is worth a read too.

That's a strange median, as JLS points out.

WHERE StateCodeName = 'Open'

AND SalesStageCode IN (

1,/* DISCOVERY */

121370000, /* PROPOSAL */

121370001, /* SIGN AGREEMENT */

121370002/* INSTALLATION */

)

Sure. Sub in either...

Some links here.

nadersam (8/11/2015)

---

It will return success also, there are 3 different characters they don't have to follow each other.

I was able to write the attached function but it doesn't work if...

Merry Christmas! Have I missed...

and you're reached the corner of the field.

djj (8/11/2015)

---

ChrisM@Work (8/11/2015)

---

rodjkidd (8/11/2015)

---

Sean Lange (8/10/2015)

---

SQLRNNR (8/10/2015)

---

Sean Lange (8/10/2015)

---

The above sounds like with "air" or "bear"? I have heard this pronunciation but that has not happened frequently.

The above sounds like...

Koen Verbeeck (8/11/2015)

---

ChrisM@Work (8/11/2015)

---

rodjkidd (8/11/2015)

---

Sean Lange (8/10/2015)

---

SQLRNNR (8/10/2015)

---

Sean Lange (8/10/2015)

---

The above sounds like with "air" or "bear"? I have heard this pronunciation but that has not happened frequently.

The above sounds...

rodjkidd (8/11/2015)

---

Sean Lange (8/10/2015)

---

SQLRNNR (8/10/2015)

---

Sean Lange (8/10/2015)

---

The above sounds like with "air" or "bear"? I have heard this pronunciation but that has not happened frequently.

The above sounds like "clear" or...

tfeuz (8/10/2015)

---

We have 2 databases on different servers with identical structures and indexes

Database 1 has a stored procedure that runs in approximately 40 seconds on 15,000 rows of data

Database...

Until and unless you change at least one of your predicates to be SARGable, your query will use a full table...

No worries, I have days like that too - more as the grey...

This is completely different, using a msTVF vs an iTVF but doesn't have the overhead of the XML black box:

CREATE FUNCTION fn_RemoveUnwantedCharacters

(@MyString VARCHAR(50)) -- arbitrary max, matches iTally table...

This might help:

DECLARE @pageSize INT, @PageNum INT

SELECT @pageSize = 60, @PageNum = 1

SELECT * FROM #inv ORDER BY #inv.InvoiceDateTime ASC

OFFSET 0 ROWS FETCH FIRST 60 ROWS ONLY

SELECT @pageSize =...