Viewing 15 posts - 1,096 through 1,110 (of 2,452 total)
Hrothgar (9/3/2015)
September 3, 2015 at 10:46 am
tthoman77 (8/27/2015)
No sir, our ERP is Epicor. They originally used Progress but are phasing it out now.
what version of Epicor?
as a sidebar.....are you 100% sure that your ERP support licence...
August 27, 2015 at 9:36 am
out of curiosity...is your ERP "Progress/Openedge" by any chance?
August 27, 2015 at 9:26 am
I think that the OP needs to clarify what the "rules" are......or is this just homework (first post from OP) ?
anyways the two solutions provided give the requested results based...
August 27, 2015 at 8:55 am
for clarification, please can you explain in words the business rules for this sort order.
thanks
August 27, 2015 at 4:10 am
robert.chipperfield (8/26/2015)
Really sorry about these issues - we're well aware of them, and working with the hosting company on them.
Basically, we're seeing intermittent packet loss between the SQL boxes...
August 26, 2015 at 11:02 am
nowadays and no longer a regular TSQL practitioner (as well as the grey cells quickly dying off )
I find the following useful......I know that it can be done, but cannot...
August 26, 2015 at 8:02 am
chindilog (8/25/2015)
(SELECT LIST(wo.num, ',')
can you please explain what "SELECT LIST" does....are you using MS...
August 26, 2015 at 7:20 am
in addition to what Alvin has already said....your TSQL code IS different to the Excel function....(ignoring the &_ line continuation)
TSQL
FROM attribute.PersonMembership LEFT OUTER JOIN USFSA.dbo.SOP10100 AS invWork
Excel
"FROM attribute.PersonMembership pm "...
August 26, 2015 at 6:36 am
mister.magoo (8/26/2015)
Is anyone looking into how excruciatingly slow SSC has become?
+1 and has been for the last few hours
August 26, 2015 at 5:54 am
+------+--------+----------------------------+-------+
| id | amount | date | descr|
+------+--------+-----------------------------+------+
| 5689 | 10.00 | 2015-08-25 12:10:57.107 | 4 |
| 5689 | 10.00 | 2015-08-24 12:07:57.107 | 3 |
| 5689 | 130.00...
August 26, 2015 at 3:57 am
serviceaellis (8/25/2015)
Anyone see why there's a syntax error on 'pm' from the function?
no idea really....but have you tried replacing your "pm" alias with actual table names?
shot in the dark.
good luck
August 25, 2015 at 3:10 pm
serviceaellis (8/25/2015)
issue is with a syntax error.
otherwise would like to find how to set the hard date range...
August 25, 2015 at 2:10 pm
serviceaellis (8/25/2015)
J Livingston SQL (8/25/2015)
out of curiosity....what is the size of the data you are dealing with...eg number of rows in your tables?in the date range there's 36,501 records
and with...
August 25, 2015 at 1:55 pm
out of curiosity....what is the size of the data you are dealing with...eg number of rows in your tables?
August 25, 2015 at 1:40 pm
Viewing 15 posts - 1,096 through 1,110 (of 2,452 total)