Forum Replies Created
Viewing 15 posts - 541 through 555 (of 10,144 total)
-
RE: Trying to speed up this 'GetWorkingDays' function.
Lars - or this:
SELECT
-
RE: Sum of last 9 records
seubanks00 - Friday, October 20, 2017 8:24 AM -
RE: Trying to speed up this 'GetWorkingDays' function.
Jason A. Long - Wednesday, October 18, 2017 6:00 PM -
RE: Stock take FiFo conundrum
Dom Horton - Wednesday, October 18, 2017 5:16 AM -
RE: Stock take FiFo conundrum
Hi Dom, try this, first in English.
In the Stocktake table;
For each product, ordered by seq;
Determine a RangeStart and RangeEnd.
For seq = 1, RangeStart = 1 and... -
RE: Using Date in Where Condition
Jeff Moden - Tuesday, October 17, 2017 5:44 AMChrisM@Work - Tuesday, October 17, 2017 5:05 AMRE: Using Date in Where Condition
Jeff Moden - Saturday, October 7, 2017 9:10 PMChrisM@home - Saturday, October 7, 2017 3:25 PMRE: Are the posted questions getting worse?
Luis Cazares - Monday, October 16, 2017 10:00 AMRE: Stock take FiFo conundrum
Dom, can you knock up a table of expected results please? Cheers.
RE: Very challenging TSQL Query
Why choose the hard way? Store 1000, 0.5 and 10 with their correct names on the same row and this becomes trivially easy.
What you are asking - the coding...RE: Help with Trigger
Is there ever likely to be more than onerow at a time added to the opportunity table? This is important because it willdetermine how the trigger...
RE: Help with Trigger
Stix83 - Monday, October 16, 2017 6:38 AM
what i am...RE: Where query time between 6am and 6pm
-- Here's how to get the time portion of your datetime.
-- Note that the TIME function has a parameter, check it
--...
RE: How to get columns which has null's
SELECT
[Result] = REVERSE(STUFF(REVERSE('Columns containing NULL in all three tables: '
+ CASE WHEN SUM(c1) < SUM([RowCount]) THEN 'c1, ' ELSE '' END
+ CASE WHEN...RE: Help with Trigger
Stix83 - Monday, October 16, 2017 2:10 AMViewing 15 posts - 541 through 555 (of 10,144 total)
