what do you want return if you had these rows

02038881121 | Jamie
02038881121 | Jamie
02038881121 | John
02038881121 | Jack

just tried adding to "briefcase"....no joy....seems to be there and then immediately disappears

may I ask why the stock level is not checked prior to committing/accepting the order ?

Maybe if you could explain in more detail how your order/stock system works, then it...

as a developer, I am sure you will appreciate my next question............any chance you can provide set up scripts for your tables and sample data, please...?  (Not everyone is going...

why isn't item 125 different.....50/30  60/28 ?

edit...because of Item_master.Type = 'BIK'?

• This reply was modified 3 years, 6 months ago by  J Livingston SQL.

maybe ?

WITH SampleData2 (PERSONNUM, [ORGPATHTXT]) AS
(
SELECT 231089,'./Company/20-00001/120---30-00006/40-00506/50-99506/60-29145/97455001/0097455001/Fire-Grill'
UNION ALL 
SELECT 121564,'./Company/20-00001/120---30-00006/40-00073/50-00075/60-26275/68990001/0068990001/Location3/Burger-Cook'
UNION ALL 
SELECT 999998, './Company/20-00001/120---30-00006/40-00073/50-00075/60-26275/77990993/0077990993/Location6/Food-Worker'
)

SELECT * 
,CAST(N'<x>' + REPLACE(REPLACE(ORGPATHTXT,'/','~'),N'~',N'</x><x>') + N'</x>' AS XML).value('/x[8]','nvarchar(max)')
from SampleData2

without any data or table set up scripts, tis a tad hard to guess what you want....so, just for fun...

if  this is anywhere close to your basic results, then SUM...

• This reply was modified 3 years, 6 months ago by  J Livingston SQL.

Thank you Steve, all appears to be working as expected.

JLS

maybe ?

SELECT
Id,
IncidentNo,
CreatedDate,
LatestRepliedDate
FROM IncidentMasterSimulation
ORDER BY ISNULL(LatestRepliedDate, CreatedDate) DESC

I know its not a good...

hmmmm

after 4½ years it seems to take even longer now !

So, my personal and heartfelt request as a member of "the community that was", I'd love it if you and JLS (another recent revisitor) and a host...

Shifting gears back to your good question, I'm curious...

1. What are you going to do with the t_Group and t_no columns once they've been generated?
2. How often will you...

• This reply was modified 3 years, 6 months ago by  J Livingston SQL.
• This reply was modified 3 years, 6 months ago by  J Livingston SQL.

Jeff...do you still post your "1 million row" test scripts?

Would love to see one for this Q.

Jeff.....had to smile when I saw his post <grin>

Wonder if he will follow it up?