Forum Replies Created

Viewing 15 posts - 241 through 255 (of 2,452 total)

  • RE: displaying 2 values when field same

    rmcguire 28206 - Wednesday, March 22, 2017 12:40 PM

    Here are 2 .xlsx files one for our orders and one for the stops,...

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

  • RE: displaying 2 values when field same

    rmcguire 28206 - Wednesday, March 22, 2017 12:13 PM

    so that displays correctly as far as showing all of the data, thank you...

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

  • RE: displaying 2 values when field same

    rmcguire 28206 - Wednesday, March 22, 2017 12:02 PM

    I don't believe I'm going to be able to provide the data readily, I'm...

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

  • RE: displaying 2 values when field same

    rmcguire 28206 - Wednesday, March 22, 2017 11:55 AM

    select orders.rate, stop.actual_departure, stop.city_name, stop.state, stop.order_id ,
    CASE when stop.stop_type = 'PU' then city_name...

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

  • RE: displaying 2 values when field same

    here is a link on how to post questions so that everyone understands and help

    https://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/

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

  • RE: displaying 2 values when field same

    rmcguire 28206 - Wednesday, March 22, 2017 11:47 AM

    I have a field, stop.city_name, and it can be 2 different locations based on...

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

  • RE: Calculate DateDiff between two tables and tow records

    A...you have the datediff statement set up in the opposite order to my example
    B...you are ordering by TIME_PICKING_START .....maybe this should be DATE_PICKING_START, TIME_PICKING_START ?
    C...without seeing example of your base...

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

  • RE: Calculate DateDiff between two tables and tow records

    you havent posted the code you are using....only the results .

    maybe this will help you


    CREATE TABLE #yourtable(
     ASSIGNMENT   INT
    ,PickingStart   DATETIME ...

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

  • RE: t-sql 2012 rank or priortize values in one column

    J Livingston SQL - Tuesday, February 21, 2017 1:03 PM

    wendy elizabeth - Monday, February 20, 2017 9:21...

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

  • RE: QueryOptimization

    farax_x - Thursday, March 9, 2017 1:48 AM


     but its extremely slow ! anyone has better idea ? better index ? or...

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

  • RE: SQL query which returns a single aggregate metric indicating how well actuals met forecast for a given week

    jeswar - Saturday, March 4, 2017 12:18 AM

    Table: UnitsSold
    Columns:
    •    ProductID
    •    Quantity
    •    Date
    •    ForecastOrActual – can be “A†for actual and “F†for forecast.

    Sample Data would look...

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

  • RE: SQL question ? How can we find all the occurrences of a text in a string

    Jeff Atherton - Friday, March 3, 2017 11:02 AM

    If you're going to use this on a regular basis I would probably turn...

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

  • RE: Need Help Refuting a Statement about Normalization

    Amy...is this a business system that you have developer control over...or is it a third party vendor with all sorts of stringent clauses?
    if its the latter ; then defer...

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

  • RE: Need Help Refuting a Statement about Normalization

    amy26 - Friday, March 3, 2017 6:32 AM

    By looking in history or request information....

    it may help if you provide details of your...

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

  • RE: Need Help Refuting a Statement about Normalization

    amy26 - Friday, March 3, 2017 5:48 AM

    Hi there,  I just needed to get some collaborative advice.  I work on a system...

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

Viewing 15 posts - 241 through 255 (of 2,452 total)