Forum Replies Created

Viewing 15 posts - 151 through 165 (of 8,731 total)

  • Reply To: Using table for search and replace values

    Can a same row have multiple replacements? How long are the columns?

    • This reply was modified 7 years, 1 months ago by Luis Cazares.

    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 29, 2019 at 5:48 pm

    #3549964

  • Reply To: Are the posted questions getting worse?

    Jeff Moden wrote:

    Steve Jones - SSC Editor wrote:

    Quoting is a big challenge with styling and code. Really, I'd urge you to avoid hitting quote every single time. In this thread, it is often helpful, but...

    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 26, 2019 at 1:56 pm

    #3540757

  • Reply To: Are the posted questions getting worse?

    Chris Harshman wrote:

    Here's the link to the screen photo thread if you're in need of a good laugh: https://www.sqlservercentral.com/forums/topic/connection-to-integration-service-failed

    You don't even need to use the Print Screen nowadays. You can use...

    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 24, 2019 at 8:57 pm

    #3532465

  • Reply To: Using Cursor in DELETE statement

    kdrymer wrote:

    Thanks Luis, yes I see that I had forgotten to move the cursor forward. I added that and it now performs the transaction. Just curious what you mean by ...

    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 24, 2019 at 8:29 pm

    #3532369

  • Reply To: Using Cursor in DELETE statement

    You do have an infinite loop going on, but you also have some other problems. I would suggest that you change your trigger to allow you to handle multiple rows...

    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 24, 2019 at 6:33 pm

    #3532011

  • Reply To: Number of days in quarter between date columns

    According to what I understand, your query actually gets the correct results but it needs to be optimized for performance? You don't need to get the number of days from...

    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 18, 2019 at 7:28 pm

    #3456290

  • Reply To: Are the posted questions getting worse?

    Sean Lange wrote:

    jasona.work wrote:

    Jeff Moden wrote:

    below86 wrote:

    Jeff Moden wrote:

    However, if they spend even a second of time considering that as a problem before they fix attachments to posts/articles and links to the rest...

    • This reply was modified 7 years, 2 months ago by Luis Cazares.

    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 18, 2019 at 4:23 pm

    #3453686

  • Reply To: Adjusting T-sql to prevent injection

    MySQL and SQL Server use different methods to execute dynamic code. This is a forum for Microsoft SQL Server, you would get better help on a MySQL forum.

    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 18, 2019 at 1:14 pm

    #3450811

  • Reply To: Are the posted questions getting worse?

    Jeff Moden wrote:

    Well, crud... I resurrected an old "Passport" disk and found my old animated "Death Star" explosion of rebar but the new forum apparently doesn't support animated GIFs.  Had to...

    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 18, 2019 at 1:07 pm

    #3450714

  • Reply To: Are the posted questions getting worse?

    Lynn Pettis wrote:

    Brandie Tarvin wrote:

    Steve Jones - SSC Editor wrote:

    It's live now. A problem with some status not moving on auto publish, but the Corgi Contest is out: https://www.sqlservercentral.com/forums/topic/canine-corgi-completion-contest Not a great way to start 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 15, 2019 at 8:22 pm

    #3387477

  • Reply To: Are the posted questions getting worse?

    Brandie Tarvin wrote:

    I'm heartbroken here. The Corgi Completion Contest "discussion" hyperlink leads to the article on data compression (https://www.sqlservercentral.com/editorials/data-compression-double-take). <sniff><sniff>WAAAAAGGHHHH! @=(

    Maybe the contest is to actually find the thread.

    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, 2019 at 3:17 pm

    #3377620

  • Reply To: Estimated Number of Rows 4,056,100,000,000,000,000,000,000 !

    Could it be that the statistics are not up to date?

    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, 2019 at 3:16 pm

    #3377610

  • Reply To: Are the posted questions getting worse?

    Ed Wagner wrote:

    Loner wrote:

    I think in most cases companies try to put double duties on SQL Developers and now they have to do administrative work. It is definitely in my company,...

    • This reply was modified 7 years, 2 months ago by Luis Cazares.
    • This reply was modified 7 years, 2 months ago by Luis Cazares.

    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, 2019 at 1:52 pm

    #3375013

  • Reply To: Are the posted questions getting worse?

    Sean Lange wrote:

    Good luck finding a thread like "Today's random word". Was going to go there and post something but the search can't seem to find it.

    I don't seem to have...

    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 12, 2019 at 8:55 pm

    #3175099

  • Reply To: Having issues with Excel source in SSIS

    Have you tried converting the column type into a string? I'm just getting this out of memory, but it should be defined in the Excel Source Editor in the Columns...

    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 12, 2019 at 4:16 pm

    #3162427

Viewing 15 posts - 151 through 165 (of 8,731 total)