!?

If you closely watch the link the store procedure is in msdb did you update it in msdb Database, please don't do that , create a wrapper proc for sp_send_dbmail...

i think this link will help you

how about a recursive idea

WITH cte AS (

SELECT a.id, a.column1, CAST(0 AS BIGINT) Base, CHARINDEX(' ', a.column1, 0) AS MID

FROM...

might be this will be handy and more readable

with cte as (

SELECT DISTINCT t1.DealerID, t2.tire,

TotalRepairs = SUM(1) OVER (PARTITION BY t1.DealerID),

RepairsOfThisTire = SUM(1) OVER(PARTITION...

might be a little tweak of Lynm

WITH Groups AS

(

SELECT 1 AS GroupId, 'Oracle' AS GroupName, 0 AS IdParentGroup UNION...

Hi there,

Thanks, I think you try to pick the missing crewid well need some more data, minimum crewid maximum crewid and some sample crewid to know how the crewid...

Hi lowel,

thanks for you, I added a identity column, in the results is it possible to produce that kind...

can you show Query, how did you try to pick the lowest value

Ok, I will explain it clearly please do not consider the Data3 column

idDAta1Data2Data3

1Name81

1possible Shifts307

1First shift228

1Second Shift249

1Third Shift2210

This is my First ID Based set, it might be the first version...

i want the result as follows

SELECT * FROM

(

VALUES

(1,'Name','8',1),

(1,'possible Shifts','30',1),

(1,'First shift','22',1),

(1,'Second Shift','24',1),

(1,'Third Shift','22',1),

(1,'Name','8',2),

(1,'possible Shifts','30',2),

(1,'First shift','22',2),

(1,'Second Shift','24',2),

(1,'Name','8',3),

(1,'possible Shifts','30',3),

(1,'1st shift','18',3),

(1,'2nd Shift','18',3)

) AS vtable (id,[DAta1],[Data2],[DVersion])

Thanks for the reply, but that doesn't work for me any other point

Excellent question New thing learned today, the 6th option is a tricky one

it seems the following values are give only 4 is the correct answers

DECLARE @AA VARCHAR(12) = 'AAA'

,@XXX ...

intresting one i have one more option

how about this one

SELECT @Result = NULL;

-- Option 6:

SELECT @Result = CASE

WHEN @aa =@XXX AND @XXXCount >...