Hello - I have a unique problem - I have a requirement to retrieve a substring which appears between the fourth and fifth underscores in a string.  The parent...

Just for the fun of it... 🙂

WITH 
cte_n1 (n) AS (SELECT 1 FROM (VALUES (1),(1),(1),(1),(1),(1),(1),(1),(1),(1)) n (n)),-- 10
cte_n2 (n) AS (SELECT 1 FROM cte_n1 a CROSS JOIN...

I'm with Erland on the use of scalar functions.

Based on your description, it sounds like a perfect use case for an "AFTER TRIGGER".

Please don't take this the wrong way, but looks like the SQL equivalent of a Rube Goldberg devise.

The easiest solution would be to simply install SSMS on the managers laptop...

Because BOL doesn't list/describe all of the available CONVERT styles...

DECLARE @n INT = 0, @v nvarchar(100);
WHILE @n < 10000
BEGIN
BEGIN TRY 
SELECT @v = CONCAT(@n, N' ', CONVERT(NVARCHAR(50),...

GAU-8 Avenger

• This reply was modified 5 years, 8 months ago by  Jason A. Long.

If you work for an organization that counts lines code as a metric for developer productivity, then RedGate's "SQL Prompt" extension for SSMS is a great investment. A...

Thank you for the feedback and clarification. I'm glad the solution will work for you. 🙂