Forum Replies Created

Viewing 15 posts - 2,221 through 2,235 (of 8,731 total)

  • RE: Group by with update statement

    afreenraja (8/29/2016)

    Thanks.

    I will try these.

    Try to understand them, so if there's an error you can correct 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

    August 29, 2016 at 10:07 am

    #1898128

  • RE: Group by with update statement

    Here are 2 options identical in execution. One uses a derived table and the other one uses a CTE.

    UPDATE T

    SET SALE = S.Sale,

    Exp = S.EXP

    FROM Sale...

    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

    August 29, 2016 at 9:42 am

    #1898120

  • RE: how to remove leading 1 and zeros

    If it's a bigint or similar, then a simple math operation will work.

    DECLARE @Table TABLE( Somenumber bigint);

    INSERT INTO @Table

    SELECT 1000000017777 UNION ALL

    SELECT 1000000017342;

    SELECT *, Somenumber % 1000000000000

    FROM @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

    August 29, 2016 at 6:59 am

    #1898075

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (8/29/2016)

    Here's a thought. So many people are asking for interview questions, why don't we create a list of subjects that are often covered by interviews (possibly including links...

    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

    August 29, 2016 at 6:46 am

    #1898069

  • RE: Are the posted questions getting worse?

    SQLRNNR (8/26/2016)

    WayneS (8/26/2016)

    Grant Fritchey (8/25/2016)

    Lynn Pettis (8/25/2016)

    Got to the following from a LinkedIn email. Not sure about a few of the answers.

    https://intellipaat.com/interview-question/sql-interview-questions/

    I posted a comment. I couldn't help it.

    As...

    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

    August 26, 2016 at 11:11 am

    #1897874

  • RE: Need help with Conditions in SQL Query

    What do you mean by this?

    shezi (8/26/2016)

    In TSQL it would have been listtle easy to do that but I need to get this done in SQL query. I believe...

    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

    August 26, 2016 at 9:37 am

    #1897853

  • RE: Are the posted questions getting worse?

    WayneS (8/26/2016)

    Grant Fritchey (8/25/2016)

    Lynn Pettis (8/25/2016)

    Got to the following from a LinkedIn email. Not sure about a few of the answers.

    https://intellipaat.com/interview-question/sql-interview-questions/

    I posted a comment. I couldn't help it.

    As did...

    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

    August 26, 2016 at 9:30 am

    #1897849

  • RE: Are the posted questions getting worse?

    Beatrix Kiddo (8/26/2016)

    would like to hear your Chinese restaurant recommendations ...

    Go to Canal street. Face east. Turn right on Mott. Go down a block. Turn right. Thai restaurant on your...

    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

    August 26, 2016 at 8:58 am

    #1897832

  • RE: SQL help - how do we find that a particular string appears x times in a certain field

    The problem with the proposed xml solutions, is that the sample data is not xml. It has to be formatted to be xml and that would be more work.

    That's if...

    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

    August 26, 2016 at 8:08 am

    #1897810

  • RE: simple dynomic Transpose 2 column as 2 rows

    You seem to have asked this question (or a version of it) several times.

    You should be able to create a dynamic pivot for yourself now, unless you don't understand the...

    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

    August 26, 2016 at 7:40 am

    #1897797

  • RE: Table Row Counts

    jdbrown239 (8/26/2016)

    Thanks for the help guys. Check out this blog which gave me what i needed.

    http://blogs.lessthandot.com/index.php/datamgmt/datadesign/how-to-get-information-about-all-databas/

    Read the article that I mentioned before, here's an extract to show why it's important:

    ...

    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

    August 26, 2016 at 7:24 am

    #1897791

  • RE: Cast Varchar to Float Resulting In (Scientific) E Notation

    Jeff Moden (8/25/2016)

    P.S. You should also avoid the use of any of the "MONEY" datatypes and small scale DECIMAL types for any work with any operators other than simple...

    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

    August 26, 2016 at 7:14 am

    #1897785

  • RE: Remove 'spaces' from DB backup filename

    You have the wrong characters in your REPLACE function. Use the correct ones and you should get it done.

    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

    August 26, 2016 at 7:11 am

    #1897782

  • RE: Today's Random Word!

    djj (8/26/2016)

    Ed Wagner (8/26/2016)

    Stuart Davies (8/26/2016)

    Alan.B (8/25/2016)

    djj (8/25/2016)

    Ed Wagner (8/25/2016)

    Y.B. (8/25/2016)

    ZZartin (8/25/2016)

    Ray K (8/25/2016)

    crookj (8/25/2016)

    Ed Wagner (8/25/2016)

    Alan.B (8/25/2016)

    BWFC (8/25/2016)

    Prefect

    day

    Night

    Stalker

    Talker

    Dead

    Walking

    Running

    Jogging

    blogging

    vlogging

    Flogging

    Flagellation

    Fragmentation

    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

    August 26, 2016 at 7:07 am

    #1897780

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (8/25/2016)

    They must be proud of their site. It helps unqualified people get jobs they can't handle.

    Can you believe they also charge for their courses?

    I...

    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

    August 25, 2016 at 2:29 pm

    #1897663

Viewing 15 posts - 2,221 through 2,235 (of 8,731 total)