Forum Replies Created

Viewing 15 posts - 196 through 210 (of 2,452 total)

  • RE: Creating a temp table with dynamic SQL

    Brandie Tarvin - Friday, May 19, 2017 5:12 AM

    Jeff Moden - Thursday, May 18, 2017 4:09 PM

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Reverse ouput

    peter larsen-490879 - Friday, May 19, 2017 4:25 AM

    HI,

    Parent_Group_ID will be used group fields from 'Sold in current time frame in KILOS'...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Help On Calculating Aging

    koti.raavi - Wednesday, May 17, 2017 10:37 AM

    Yes correct Livingston, you and chris are masters,kudos to both of you. thanks for your...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Help On Calculating Aging

    koti.raavi - Wednesday, May 17, 2017 9:41 AM

    Nope,why last column data is number 2 for 17:00:00.000000 schedule on 2017-04-28 it should be...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: weird string problem

    solus - Friday, May 12, 2017 2:32 AM

    Ive tried this

    WHEN EndTime LIKE '[0-9][0-9][0-9][0-9]' THEN LEFT(dbo.RemoveNonNumericChar(EndTime),2) + ':' + RIGHT(dbo.RemoveNonNumericChar(EndTime),2) + ':00.0000000'

    and this...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Stairway to PowerPivot and DAX - Level 7: Function / Iterator Function Pairs: The DAX AVERAGE() and AVERAGEX() Functions

    Appreciate this stairway is 3 years old....being somewhat naive on this subject, is the information still relevant today with MS Power BI (2017)?

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Why DECLARE doesn't work?

    kkbear - Monday, May 1, 2017 9:41 AM

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: array or do while loop

    Phil Parkin - Monday, April 24, 2017 11:45 AM

    J Livingston SQL - Monday, April 24, 2017 11:33 AM

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: array or do while loop

    Phil Parkin - Monday, April 24, 2017 11:28 AM

    If it were me, I'd probably process the data from your vendor into a...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: array or do while loop

    maybe this will give you some ideas

    WITH CTE AS
    (SELECT s.OWNERB,
       s.ORDNOB AS WMSOrderNo,
       s.HSTRFB AS CUSTORDNO,
       d.scode,
       d.samt
    FROM SpecialCharges s

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Update Field to current logged in user ID with new record command button

    Welsh Corgi - Sunday, April 23, 2017 8:26 AM

    Hi,

    There is a type of a Microsoft Project where you do not use linked...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Help SQL query, count and group by day on multiple fields

    would be far easier for potential answers if you would follow the following advice.....https://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/

    whilst you have given us sample data...you expect us to do your work...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

Viewing 15 posts - 196 through 210 (of 2,452 total)