Forum Replies Created

Viewing 15 posts - 526 through 540 (of 8,731 total)

  • RE: Cursor - loops but doesn't insert into table.

    That might be because you're not changing your dynamic code on every iteration, so you're just trying to run a null value.


    Set NOCOUNT ON;
    Declare...

    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

    May 24, 2018 at 9:53 am

    #1991831

  • RE: Using FORMAT() for Dates

    Steve Jones - SSC Editor - Thursday, May 24, 2018 9:25 AM

    Jeff Moden - Thursday, May...

    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

    May 24, 2018 at 9:29 am

    #1991819

  • RE: Using FORMAT() for Dates

    patrickmcginnis59 10839 - Thursday, May 24, 2018 7:59 AM

    Jeff Moden - Thursday, May 24, 2018 5:21 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

    May 24, 2018 at 9:15 am

    #1991809

  • RE: Getting an average UPDATED

    brian.cook - Thursday, May 24, 2018 8:37 AM

    I have a table that is created by a Stored procedure. This itself works fine....

    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

    May 24, 2018 at 9:01 am

    #1991802

  • RE: Looping through 65 millions of combinations: Excel or SQL or something else?

    John Mitchell-245523 - Wednesday, May 23, 2018 8:43 AM

    Try this.  If you wanted to go to an indeterminate number of dimensions, you'd...

    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

    May 23, 2018 at 1:35 pm

    #1991698

  • RE: Upgrade from Standard Edition to Enterprise Edition

    keanyukas - Wednesday, May 23, 2018 10:21 AM

    If I upgrade from standard edition to enterprise edition is there anything I should be...

    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

    May 23, 2018 at 1:20 pm

    #1991695

  • RE: find char in column

    Maybe using something like
    WHERE PAN_NO LIKE '[A-Z][A-Z][A-Z][A-Z][A-Z]%'
    You can find more information about searching patterns in here: http://www.sqlservercentral.com/articles/T-SQL/130558/

    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

    May 23, 2018 at 8:42 am

    #1991631

  • RE: Cursors

    Jeff Moden - Wednesday, May 23, 2018 7:23 AM

    varunchopra.apj - Wednesday, May 23, 2018 7:07 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

    May 23, 2018 at 8:32 am

    #1991628

  • RE: Are the posted questions getting worse?

    Lynn Pettis - Tuesday, May 22, 2018 1:08 PM

    Okay, waiting to see what happens after calling out Mr. Celko's flawed code in...

    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

    May 22, 2018 at 1:21 pm

    #1991499

  • RE: A better way than multiple subqueries?

    Use a cross tabs query using the MAX() function to pivot the table as needed. Here's an article describing how to do so: Cross Tabs and Pivots, Part...

    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

    May 22, 2018 at 12:10 pm

    #1991486

  • RE: Are the posted questions getting worse?

    Thom A - Tuesday, May 22, 2018 9:25 AM

    jasona.work - Tuesday, May 22, 2018 9:15 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

    May 22, 2018 at 10:15 am

    #1991459

  • RE: Need to rename server but name is in lots code - alias?

    smv1009 - Tuesday, May 22, 2018 8:00 AM

    I have to rename a SQL Server soon. Unfortunately, the server name is hard-coded in...

    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

    May 22, 2018 at 8:04 am

    #1991409

  • RE: Are the posted questions getting worse?

    jasona.work - Monday, May 21, 2018 12:21 PM

    Couple thoughts for you (note, I've never organized anything bigger than a family "secret...

    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

    May 21, 2018 at 1:00 pm

    #1991339

  • RE: Are the posted questions getting worse?

    Jeff Moden - Monday, May 21, 2018 10:21 AM

    Luis Cazares - Monday, May 21, 2018 10:11 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

    May 21, 2018 at 12:07 pm

    #1991318

  • RE: Are the posted questions getting worse?

    A question for all the BBQ aficionados.
    First, some background. We're organizing a BBQ contest with the help of the Kansas City Barbeque Society for a non-profit. I'll have 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

    May 21, 2018 at 10:11 am

    #1991286

Viewing 15 posts - 526 through 540 (of 8,731 total)