Here is another variation that might perform better, depending on the production volume and the existence of a clustered index on the [Seq] column. ( If the...

You need to do a new version of this article after 2016 has been out a while, Steve. 🙂

If you were looking for 'Rat' (the word) you could look for Ngrams like '% RAT %'. You'd still have to use REPLACE to handle punctuation marks....

abhas (8/4/2016)

It should have capability of showing count of Employee who logged for whole day (with slot of every hour), for whole week (with slots of days), for whole Month...

I've read the Nasty Fast N-Grams article and the approach is very similar to Jeff's DelimitedSplit8K() function. The primary difference being that the N-grams would be fixed length...

There is no way that you can simplify joining to multiple entity tables. A join will be required for each entity table. The...

shambhavi13 (8/3/2016)

---

I am using SQL server 2014 .. Apologies for posting in wrong section.

I don't understand the use of 'value' ... what does that stands for ?

with cte as (select...

Flagging this as a duplicate post. Go HERE for discussion.

Try nesting CASE expressions.

Instead of

THEN MonthlyBalance END

use

THEN CASE WHEN Mth <= @EndDate THEN MonthlyBalance ELSE MonthlyBudget END END

Remember, as an expression, CASE can be nested...

Then wouldn't it be more honest to just say you don't know?

vsamantha35 (8/3/2016)

---

Thats Awesome Eirikur Eiriksson. Other thing, it came into my mind looking at the Execution Plan, I see sort and the Merge join is happening.

Is there an way,...

In SQL 2016 you can use the STRING_SPLIT() function to convert your long string value to a series of individual words and then use standard COUNT(*) GROUP BY to get...

tskelley (8/1/2016)

---

Yes, and thank for your pointing out the sarcasm. I have removed it from my reply. I was a little frustrated on this one, and found the...

Two comments so that you can help us help you.

First, thank you for the CREATE table statement, but we have no way to populate it with the sample data you...

Eirikur Eiriksson (8/1/2016)

---

You are very welcome

😎

For further information on the subject, I suggest having a look at Jeff Moden's excellent articles, Cross Tabs and...