Viewing 15 posts - 1 through 15 (of 2,452 total)
what do you want return if you had these rows
02038881121 | Jamie
02038881121 | Jamie
02038881121 | John
02038881121 | Jack
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 8, 2021 at 9:20 am
Is this still an issue?
just tried adding to "briefcase"....no joy....seems to be there and then immediately disappears
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 6, 2021 at 7:34 pm
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 6, 2021 at 7:23 pm
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 3, 2021 at 4:43 pm
why isn't item 125 different.....50/30 60/28 ?
edit...because of Item_master.Type = 'BIK'?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
September 3, 2021 at 3:38 pm
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
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 31, 2021 at 5:24 pm
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 31, 2021 at 3:56 pm
Thank you Steve, all appears to be working as expected.
JLS
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 31, 2021 at 2:29 pm
maybe ?
SELECT
Id,
IncidentNo,
CreatedDate,
LatestRepliedDate
FROM IncidentMasterSimulation
ORDER BY ISNULL(LatestRepliedDate, CreatedDate) DESC
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 31, 2021 at 10:38 am
That's not a good bug report. What's longer?
I've checked this a few times lately and it's about 7-8s at different times of the day.
I know its not a good...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 30, 2021 at 6:55 pm
hmmmm
after 4½ years it seems to take even longer now !
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 30, 2021 at 6:25 pm
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 30, 2021 at 2:26 pm
Shifting gears back to your good question, I'm curious...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 26, 2021 at 1:27 pm
Jeff...do you still post your "1 million row" test scripts?
Would love to see one for this Q.
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 25, 2021 at 7:15 pm
Jeff.....had to smile when I saw his post <grin>
Wonder if he will follow it up?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 25, 2021 at 5:35 pm
Viewing 15 posts - 1 through 15 (of 2,452 total)