I missed a NULLIF function. If you can solve it, then you should be good to go.

You're welcome, just remember to fully understand the code.

I might have overcomplicated the query, I probably need some rest. 😀

DECLARE @MaxLength int = 50,

@String varchar(max) = '***DUST MASK MUST BE WORN***

ENSURE THE PRODUCT CODE...

S_Kumar_S (8/7/2015)

---

really?? I already tried installing 2012 express from this file :ENU\x64\SQLEXPRADV_x64_ENU.exe( mine is 64 bit). This was the biggest file with 1.3 GB size. So I though it will...

I have profiler and I only installed SQL Server 2012 Express with tools

ArcticEd32 (8/6/2015)

---

Thank you again for the assistance and for the information regarding the triangular join. Only took me a week to read Jeff's post, the re-post, and the discussions...

Why are you trying to change this when you could store the whole text without problems?

It can be done, but it requires some validation and careful code and testing to...

No file attached.

Thank you for your time, have a great holiday.

This is untested, but it might work. What you asked is included as a CROSS APPLY. I also changed a part of your query to prevent multiple reads to BVFindings.

WITH...

Horton

Check this, it should cover the all.

GO is not a keyword. GO is a batch separator. You can actually define a different word instead of using GO as this is a setting for SSMS (aka, the...

This reminded me of an article that explains the method used here. However, the discussion of the article showed a faster option. This is the article: http://www.sqlservercentral.com/articles/T-SQL/68378/

And this is an...

It's preferred to use IF EXISTS instead of COUNT(*) to prevent unnecessary reads. EXISTS will stop on the first occurrence, while COUNT(*) will read all the needed rows.

IF EXISTS(SELECT MO.ProposedEvent

FROM...