Forum Replies Created

Viewing 15 posts - 1,651 through 1,665 (of 8,731 total)

  • RE: U-SQL data types

    I saw the "Select 2" after submitting my answer. :unsure:

    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

    January 13, 2017 at 7:30 am

    #1922552

  • RE: Should we keep Comic Sans in the formatting options?

    Comic Sans all the way!!!!😀😛

    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

    January 12, 2017 at 2:12 pm

    #1922428

  • RE: Hi ,how to code the below procedure with loop.

    skmoh2 - Thursday, January 12, 2017 4:19 AM

    Hi Luis,

    i ran the code with CTE clause and it is working but it is  missing...

    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

    January 12, 2017 at 6:33 am

    #1922227

  • RE: First and Last data

    What have you tried?

    How do you define Last_data and last_data from 6 month?

    Are the backup Start and Backup Finish dates always the same? Do they include times?

    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

    January 11, 2017 at 2:06 pm

    #1922066

  • RE: How to join one table to another that needs pivoting?

    sgmunson (1/11/2017)

    This sounds more like a "presentation" thing. I would suggest you just write a normal query that will have all the data for the server in every...

    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

    January 11, 2017 at 8:50 am

    #1921973

  • RE: foreign key w/o constraint

    ZZartin (1/10/2017)

    There's certainly nothing stopping you from using columns in one able to reference another table without making it an official foreign key. You would just have to rely...

    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

    January 10, 2017 at 1:51 pm

    #1921752

  • RE: I'm Having Trouble Parsing This Date Calculation Expression

    You could replace the zero (in both places) with any other date or value that can be implicitly converted into a datetime. It's helpful to prevent errors when dealing with...

    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

    January 10, 2017 at 1:07 pm

    #1921737

  • RE: Create incrementing group numbers for groups of 500 rows?!

    And the resetted row number can be achieved my using modulo.

    SELECT *,

    (ROW_NUMBER() OVER( ORDER BY SomeColumn) + 499) / 500,

    ISNULL(...

    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

    January 10, 2017 at 12:59 pm

    #1921731

  • RE: Are the posted questions getting worse?

    jasona.work (1/10/2017)

    Brandie Tarvin (1/10/2017)

    BrainDonor (1/10/2017)

    jasona.work (1/10/2017)

    My normal 30 minute drive to work took an hour, the roads were crap and slick, and I've got a little rear-wheel drive sporty car.

    Winter...

    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

    January 10, 2017 at 12:49 pm

    #1921727

  • RE: Hi ,how to code the below procedure with loop.

    skmoh2 (1/10/2017)

    Thanks Luis for this.i have done this scenario with SQL and is working fine.

    Can you share that code with us?

    But i have to implement it using procedure/function with LOOP...

    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

    January 10, 2017 at 9:43 am

    #1921657

  • RE: How to join one table to another that needs pivoting?

    Just pivot your table inside a CTE or subquery (derived table) before joining to the other 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

    January 10, 2017 at 9:39 am

    #1921655

  • RE: Hi ,how to code the below procedure with loop.

    OK, let's take it slowly.

    You have Table1 which is your orders table. You need to be sure you have all the rows needed as defined in your components table which...

    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

    January 10, 2017 at 8:51 am

    #1921642

  • RE: Split into multiple rows after certain character

    Is it really that difficult? There should be a better way to get this information, but I would need to get a complete picture and do intensive research. Definitively not...

    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

    January 10, 2017 at 7:27 am

    #1921619

  • RE: Hi ,how to code the below procedure with loop.

    Thom A (1/10/2017)

    Welcome to SSC, however, have you actually asked a question in your above post?

    Also, can you supply DDL and DLM statements for your tables. At first glance 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

    January 10, 2017 at 7:02 am

    #1921608

  • RE: Today's Random Word!

    djj (1/10/2017)

    Grumpy DBA (1/10/2017)

    Ed Wagner (1/10/2017)

    Truth

    (or) Dare

    Care

    Bear

    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

    January 10, 2017 at 7:00 am

    #1921607

Viewing 15 posts - 1,651 through 1,665 (of 8,731 total)