Forum Replies Created

Viewing 15 posts - 181 through 195 (of 8,731 total)

  • RE: Can't remove duplicates

    Two things come to my mind, but seem to be weird cases:
     1. Your tables are partitioned, but it's weird that the partitions are exactly the same size.
     2....

    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

    March 21, 2019 at 1:09 pm

    #2025156

  • RE: T-SQL correlated queries

    Toby Harman - Thursday, March 14, 2019 12:03 AM

    Thanks Stuart
    So the subquery becomes (SELECT t1.c1 from t2) which makes even less sense...

    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

    March 21, 2019 at 9:17 am

    #2025123

  • RE: Split strings by space into individual rows

    seismicbeat - Wednesday, March 20, 2019 12:15 AM

    @pietlinden, @jonathan-2, thank you so much for your help.

    I've set up the delimiter and tested...

    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

    March 20, 2019 at 9:06 am

    #2025025

  • RE: Cast of Sceientific notation different result on different SQL version

    jacob.saugmann - Tuesday, March 19, 2019 2:23 PM

    Luis Cazares - Tuesday, March 19, 2019 2:14 PM

    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

    March 19, 2019 at 2:52 pm

    #2024955

  • RE: Cast of Sceientific notation different result on different SQL version

    jacob.saugmann - Tuesday, March 19, 2019 1:52 PM

    Hi, i got a question today and I just can figure out an answer.

    When casting...

    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

    March 19, 2019 at 2:14 pm

    #2024947

  • RE: Split strings by space into individual rows

    pietlinden - Tuesday, March 19, 2019 1:32 PM

    Nevermind, you updated the post.

    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

    March 19, 2019 at 1:38 pm

    #2024940

  • RE: SP with Conditional Where clause where

    You should read the Catch-all-query section from this article (and the whole article) to learn the best ways to do what you need.

    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

    March 19, 2019 at 10:45 am

    #2024924

  • RE: Incremental rowwise sum

    abhas - Tuesday, March 19, 2019 9:25 AM

    Hello All,

    I am having a table with two columns like monthname and sell. I want...

    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

    March 19, 2019 at 9:55 am

    #2024917

  • RE: trimming SSNs

    I would like to emphasize some things that have already been said.
    First thing you should do is remove the dashes and just keep the digits.
    Second thing is create...

    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

    March 18, 2019 at 2:27 pm

    #2024838

  • RE: SSMS Ctrl+U Shortcut

    I had to go back and checked that I can see the tooltip but it won't work. I'm sorry that I can't help, but I'm more confused now. It could...

    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

    March 18, 2019 at 1:45 pm

    #2024831

  • RE: SSMS Ctrl+U Shortcut

    Adam McArdle - Monday, March 18, 2019 8:23 AM

    For as long as I can remember, Ctrl+U takes you to the list of...

    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

    March 18, 2019 at 9:17 am

    #2024773

  • RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

    Jeff Moden - Thursday, March 7, 2019 4:12 PM

    Heh... not quite right.  The Tally Table is still faster than the 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

    March 7, 2019 at 6:32 pm

    #2023909

  • RE: Need counts of orders per week grouped by week

    omelo - Sunday, March 3, 2019 12:03 PM

    ScottPletcher - Thursday, February 1, 2018 7:58 AM

    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

    March 4, 2019 at 9:33 am

    #2023447

  • RE: Defining Stored Procedures

    Sean Lange - Monday, March 4, 2019 8:11 AM

    Nice easy question to start the week with. Reminds of a developer we had...

    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

    March 4, 2019 at 9:29 am

    #2023445

  • RE: The SQL Joke Thread

    Ray K - Friday, March 1, 2019 12:02 PM

    Luis Cazares - Friday, March 1, 2019 11:54 AM

    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

    March 1, 2019 at 12:12 pm

    #2023337

Viewing 15 posts - 181 through 195 (of 8,731 total)