Forum Replies Created

Viewing 15 posts - 3,031 through 3,045 (of 8,731 total)

  • RE: Newbie Help working out a SQL Problem..

    To get the points per game, you need to divide the points by the games played. Then you need to get the greatest value using an aggregate function and grouping...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 15, 2016 at 7:06 am

    #1872330

  • RE: Query to get all non-zero and first zero value rows if there are 2 consecutive Zero value rows

    This is one approach (assuming you posted on the correct forum).

    WITH CTE AS(

    SELECT

    ProductID,

    ...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 14, 2016 at 1:59 pm

    #1872169

  • RE: Help calculate the last day of the previous month

    If you're trying to format a textbox, use the format property with the following value.

    MMMM dd, yyyy

    If you're trying to format a parameter, just don't. Use the date/time type.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 14, 2016 at 1:45 pm

    #1872163

  • RE: NULL values on a LEFT JOIN

    SQLPain (4/14/2016)

    I am unable to get rows where ad.StatusAppDetail IS NULL. I am using the following code.

    SELECT DISTINCT

    ISNULL(Other, 0) AS Other

    FROM Chain AS C

    LEFT JOIN (SELECT

    Count(ad.AppID) as Other,

    C.DealerID

    ...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 14, 2016 at 1:36 pm

    #1872161

  • RE: Help calculate the last day of the previous month

    Like this?

    =DateAdd("d",-Day(Today()), Today())

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 14, 2016 at 1:25 pm

    #1872155

  • RE: Are the posted questions getting worse?

    Ed Wagner (4/14/2016)

    Luis Cazares (4/14/2016)

    Ed Wagner (4/14/2016)

    SQLRNNR (4/14/2016)

    Luis Cazares (4/14/2016)

    Is this guy for real?

    How is it possible that he can't work out a basic DML statement and still have a...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 14, 2016 at 1:01 pm

    #1872146

  • RE: Are the posted questions getting worse?

    Phil Parkin (4/14/2016)

    Steve Jones - SSC Editor (4/14/2016)

    Well, apparently I don't write good questions to teach these people things.

    Maybe some of you should write some questions to help people learn...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 14, 2016 at 12:51 pm

    #1872143

  • RE: Are the posted questions getting worse?

    Ed Wagner (4/14/2016)

    SQLRNNR (4/14/2016)

    Luis Cazares (4/14/2016)

    Is this guy for real?

    How is it possible that he can't work out a basic DML statement and still have a job?

    Hopefully Hugo has him...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 14, 2016 at 11:40 am

    #1872108

  • RE: Is Date the Last Day of the Month

    A different option.

    SELECT YourDate,

    CASE WHEN MONTH(YourDate) <> MONTH(DATEADD(day, 1, YourDate)) THEN 'True' ELSE 'False' END,

    CASE WHEN YourDate = DATEADD( MM, DATEDIFF( MM,...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 14, 2016 at 11:33 am

    #1872101

  • RE: Is Date the Last Day of the Month

    Hugo Kornelis (4/14/2016)

    CASE WHEN MONTH(YourDate) <> MONTH(DATEADD(day, 1, YourDate)) THEN 'True' ELSE 'False' END

    Fixed That For You

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 14, 2016 at 11:23 am

    #1872097

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (4/14/2016)

    Ummmm. Ouch?

    Or does this really matter[/url] to anyone?

    I feel that many of these standards to certify processes are simply created to make money.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 14, 2016 at 10:24 am

    #1872071

  • RE: Reassign sequential group numbers to results of DENSE_RANK?

    drew.allen (4/14/2016)

    You need to be VERY CAREFUL with the quirky update. It is undocumented, not guaranteed, and requires a clustered index on the sort order. If you DO...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 14, 2016 at 10:09 am

    #1872064

  • RE: Are the posted questions getting worse?

    Is this guy for real?

    How is it possible that he can't work out a basic DML statement and still have a job?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 14, 2016 at 10:07 am

    #1872063

  • RE: BCP Import Help

    I honestly don't know why it does that.

    I know however, that you can change the format file and set the column as SQLCHAR (leaving your table intact) and let it...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 14, 2016 at 9:52 am

    #1872052

  • RE: Can not get results to insert into table

    INSERT INTO goes before the whole statement, not before the SELECT from the derived table.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    April 14, 2016 at 8:58 am

    #1872016

Viewing 15 posts - 3,031 through 3,045 (of 8,731 total)