Forum Replies Created

Viewing 15 posts - 61 through 75 (of 2,452 total)

  • RE: Issues with matching pattern using LIKE

    DECLARE @searchString VARCHAR(1500);
    SET @searchString = '03/09/2017 07:52 AM | Lastname, Firstname | Completed - irrelevant note.';
    SELECT CASE
        WHEN @searchString LIKE '[0-9][0-9]/[0-9][0-9]/201[0-9]%[AP]M%|%'
        THEN...

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

  • RE: Group by Date, Then take 1st row of each id

    please read and respond accordingly......saves us all time and you get tried and tested answers.

    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: STRING_SPLIT with no delimiter

    sknox - Monday, December 11, 2017 4:07 PM

    J Livingston SQL - Monday, December 11, 2017 2:56 PM

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

  • RE: STRING_SPLIT with no delimiter

    Jeff Moden - Monday, December 11, 2017 1:33 PM

    J Livingston SQL - Monday, December 11, 2017 1:02...

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

  • RE: STRING_SPLIT with no delimiter

    Jeff Moden - Monday, December 11, 2017 10:29 AM

    werner.grimmer - Monday, December 11, 2017 10:25 AM

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

  • RE: DISTINCT FOR ONE COLUMN ONLY

    craig.jenkins - Thursday, December 7, 2017 9:14 AM

    sorry what is meant by DDL and DML?

    take a look here on advice for posting
    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: Need help on query when sum of total show inaccurate result

    just a thought....it may help explain 

    SELECT c.id_product,
       SUM(COALESCE(c.received_qty, c.ordered_qty)) AS Total,
       c.id_cart,
       p.id_purchase,
       p.id_department
    FROM Cart_Item AS c
      LEFT OUTER...

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

  • RE: Cumulative subtraction

    pity the OP @selpoivre seems to have left the building !

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

  • RE: How to display table values?

    the website is https://www.essayschief.com ...basically for cheats !

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

  • RE: Why dbid is 1 for master, 2 for tempdb, 3 for model and 4 for msdb?

    SQL-DBA-01 - Monday, November 20, 2017 12:15 PM

    Eirikur Eiriksson - Monday, November 20, 2017 12:11 PM

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

  • RE: Cumulative subtraction

    Jacob Wilkins - Friday, November 17, 2017 10:45 AM

    As expected.

    From my initial post:

    Of course, you have to have something that defines...

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

  • RE: Cumulative subtraction

    Jacob Wilkins - Friday, November 17, 2017 10:34 AM

    No worries; I just wanted to make sure I didn't just wait around in...

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

  • RE: Cumulative subtraction

    Jacob Wilkins - Friday, November 17, 2017 10:06 AM

    @j-2 Livingston SQL:

    Directed to the OP, or to me? 🙂

    sorry Jacob.....was supposed to be...

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

  • RE: Cumulative subtraction

    Jacob Wilkins - Friday, November 17, 2017 9:42 AM

    Seems to be an odd recursive thing, where for each row you compute a...

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

Viewing 15 posts - 61 through 75 (of 2,452 total)