Viewing 15 posts - 1 through 15 (of 105 total)
Hi Thom
Thanks for the response, it's unlikely i'll have a single file which is greater than 8MB because the database where i've downloaded the files from doesn't allow a sigle...
April 2, 2019 at 12:58 pm
Hi Chris
your query work perfectly. it's what I wanted.
Thank you kindly
March 15, 2018 at 3:48 am
thanks for the response
March 15, 2018 at 3:18 am
the duration varies for each tasks hence I can't group it together
November 7, 2017 at 7:11 am
Thank John
it did work.
October 18, 2017 at 8:46 am
I forgot to mention
the RowGroup = Status
ColumnGroup = RequiredByDate
Data = Count(WorkOrder)
February 24, 2017 at 6:16 am
Thank you so much
It worked as expected.
Regards
December 12, 2016 at 4:23 am
hi John
No I haven't
what I need to do is when the user select the date range: 20161201 to 20161231 I want to be able to return data for 20161225 to...
December 12, 2016 at 3:50 am
Yes, I want to be able to enter multiple values for the @shift.
November 25, 2016 at 5:10 am
Thanks for the response, but I tried that solution it's only works if you select single value. I you select multiple selection the WHERE clause doesn't work.
Regards,
November 25, 2016 at 3:31 am
if the value of the @shift = 'Afternoon Shift (FMF/SVP)' it must return 'Afternoon Shift'
else 'Afternoon Shift'. Hence the case statement:
WHERE
s.Description IN (
...
November 25, 2016 at 12:39 am
noted thanks :
DECLARE @Table TABLE
(
code VARCHAR(10)
,Description VARCHAR(100)
);
INSERT INTO @Table
...
November 24, 2016 at 7:06 am
Hi guys
I managed to sort it out, I used the query Chris gave me.
Thanks a million!!!
August 23, 2016 at 5:05 am
what I want is the record with the minimum date per asset, in the case of 1004 and 1005 the date is the same and 1004 is the minimum record,...
August 23, 2016 at 4:48 am
thank you for the quick response,
my question is now, I technically I don't have ROWId in my table, I've it there In the example so I can distinguish easily which...
August 23, 2016 at 4:32 am
Viewing 15 posts - 1 through 15 (of 105 total)