!?

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

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...

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

i think this link will help you

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

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...

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

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...

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

might be a little tweak of Lynm

WITH Groups AS

(

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

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

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...

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

Hi lowel,

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

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

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

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

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...

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

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])

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

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

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

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

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

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

DECLARE @AA VARCHAR(12) = 'AAA'

,@XXX ...

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]

intresting one i have one more option

how about this one

SELECT @Result = NULL;

-- Option 6:

SELECT @Result = CASE

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

Every rule in a world of bits and bytes, can be bend or eventually be broken
MyBlog About Common dialog control
A Visualizer for viewing SqlCommand object script [/url]