Forum Replies Created

Viewing 15 posts - 1,021 through 1,035 (of 8,731 total)

  • RE: SQL Crossword 2 SELECT Keywords

    ilay.siva - Thursday, August 17, 2017 12:27 PM

    Stuck with 2 things here. 
    9. ______.b.c.d -  Across 
    8. a.b.______.d  - Down. 

    Any clues ?

    a.b.c.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

    August 17, 2017 at 1:18 pm

    #1955721

  • RE: Using CTE to update multiple columns in table and loop on all rows in table

    You need to check your rCTE. You're not using its capabilities and could simply use the table without CTE for your update. Read the examples that Chris and I posted...

    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 16, 2017 at 1:46 pm

    #1955564

  • RE: Using CTE to update multiple columns in table and loop on all rows in table

    Are you looking for something like this?

    WITH rCTE AS (
       SELECT [NewLevel] = 1,
          ID,
          ParentID,
          [Name],
         ...

    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 16, 2017 at 12:37 pm

    #1955557

  • RE: Are the posted questions getting worse?

    Lynn Pettis - Wednesday, August 16, 2017 7:56 AM

    All I am going to say is this, some people shouldn't be allowed 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

    August 16, 2017 at 8:00 am

    #1955493

  • RE: Using CTE to update multiple columns in table and loop on all rows in table

    There seems to be something missing there, but I'm not sure what would it be without sample data. I wrote an article about a similar problem some time ago, 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 16, 2017 at 7:48 am

    #1955485

  • RE: SQL Crossword 2 SELECT Keywords

    John Corkett - Wednesday, August 16, 2017 1:51 AM

    Hi
    What's the easiest way of filling the crosswords in short of printing it out?

    Thanks

    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 16, 2017 at 7:13 am

    #1955476

  • RE: Today's Random Word!

    TomThomson - Tuesday, August 15, 2017 9:32 AM

    Ed Wagner - Tuesday, August 15, 2017 7:28 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

    August 15, 2017 at 10:26 am

    #1955317

  • RE: Today's Random Word!

    anthony.green - Monday, August 14, 2017 7:00 AM

    ManicStar - Monday, August 14, 2017 6:44 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

    August 14, 2017 at 7:02 am

    #1955136

  • RE: Need to remove punctuation characters

    This might help you.
    http://www.sqlservercentral.com/scripts/T-SQL/117890/

    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 14, 2017 at 6:41 am

    #1955131

  • RE: Are the posted questions getting worse?

    Just found the following code. This is what happens when a procedural developer starts writing T-SQL. Fortunately, some learn to stop the non-sense.

    --Variables names changed

    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 11, 2017 at 11:35 am

    #1955033

  • RE: Add prefix to results

    t2 36824 - Friday, August 11, 2017 8:07 AM

    t2 36824 - Friday, August 11, 2017 8:04 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

    August 11, 2017 at 8:17 am

    #1954985

  • RE: Are the posted questions getting worse?

    Brandie Tarvin - Friday, August 11, 2017 4:34 AM

    Steve Jones - SSC Editor - Thursday, August 10,...

    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 11, 2017 at 8:11 am

    #1954981

  • RE: Add prefix to results

    t2 36824 - Friday, August 11, 2017 6:25 AM

    So here is what I have and want to do. In the attached picture,...

    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 11, 2017 at 7:17 am

    #1954964

  • RE: Can I make this query to perform better?

    TheSQLGuru - Thursday, August 10, 2017 12:05 PM

    2) CASE is your friend!!! Learn to use it!

    Just curious. How would you use CASE...

    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 10, 2017 at 12:29 pm

    #1954867

  • RE: Can I make this query to perform better?

    By the way, the execution plan attached is only for the following statement.
    set statistics time, io on

    In other words, it's useless.

    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 10, 2017 at 11:46 am

    #1954859

Viewing 15 posts - 1,021 through 1,035 (of 8,731 total)