Forum Replies Created

Viewing 15 posts - 2,071 through 2,085 (of 8,731 total)

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (10/6/2016)

    Smile, Matthew!

    Yeah, I can see the creepy in this one.

    EDIT: I wonder when the conspiracy theories are going to start on this one.

    I just saw the theory that...

    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

    October 7, 2016 at 9:38 am

    #1905415

  • RE: Introducing the Set-based Loop

    Jeff Moden (10/7/2016)

    Oh my... with a title like that, I'm not sure how I missed the original publication of this article, Luis. Thanks for taking the time 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

    October 7, 2016 at 8:14 am

    #1905386

  • RE: Today's Random Word!

    Grumpy DBA (10/7/2016)

    Stuart Davies (10/7/2016)

    Ed Wagner (10/5/2016)Spawn

    Frog

    Polliwog

    Poliwag

    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

    October 7, 2016 at 8:01 am

    #1905378

  • RE: Search string for matching pattern

    Here's a query with three conditions that should fulfill your requirements.

    SELECT *

    FROM #tmp

    WHERE loginName LIKE '%_._%' --Has a period surrounded by other characters

    AND loginName NOT LIKE '%.%.%' --Has...

    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

    October 7, 2016 at 8:01 am

    #1905377

  • RE: Introducing the Set-based Loop

    brymen (10/7/2016)

    EXCELLENT Article!

    All I can say is more, more... I want to read more articles like this one!

    You can bet I will be sharing this one...

    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

    October 7, 2016 at 6:36 am

    #1905358

  • RE: Are the posted questions getting worse?

    Phil Parkin (10/6/2016)

    Ed Wagner (10/6/2016)

    Sean Lange (10/6/2016)

    This may be the funniest thing I have seen in quite some time. You just gotta love 3rd party software.

    Yeah, that's a good one....

    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

    October 6, 2016 at 12:08 pm

    #1905245

  • RE: Choosing columns for Clustered Index.. Why it is so important?

    The subject is interesting, but you're trying to cover a wide set of topics. Try to get a series of articles instead of just one. At least, that's my opinion.

    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

    October 6, 2016 at 7:18 am

    #1905153

  • RE: MSSQL Query error

    Be careful, you might want to use UNION ALL to prevent that duplicate rows are eliminated (in case that the aggregations return the same value for the funding scheme).

    You also...

    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

    October 6, 2016 at 6:35 am

    #1905147

  • RE: Accidentally Overwrote Stored Procedure

    deekadelic (10/5/2016)

    Since I'm not the administrator of the database, I don't know what additional tools have been installed. How can I determine whether or not I have Redgate SQL Prompt...

    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

    October 5, 2016 at 2:46 pm

    #1905037

  • RE: Are the posted questions getting worse?

    George, enjoy your retirement and try to keep yourself busy and sane.

    Brandie (and possibly others), take care. Let's hope that Matthew doesn't leave a big mess.

    Drew, congratulations on the article....

    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

    October 5, 2016 at 2:37 pm

    #1905033

  • RE: Accidentally Overwrote Stored Procedure

    If you haven't closed the window, use Ctrl+Z until you undo all changes. Then run the code to restore the procedure to its original code.

    If not, follow Phil's advices. Good...

    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

    October 5, 2016 at 2:32 pm

    #1905028

  • RE: Today's Random Word!

    Ray K (10/5/2016)

    Revenant (10/5/2016)

    Manic Star (10/5/2016)

    Grumpy DBA (10/5/2016)

    djj (10/5/2016)

    Ed Wagner (10/5/2016)

    Ray K (10/4/2016)

    Manic Star (10/4/2016)

    Unicycle

    Uniform

    Identical

    Distinct

    Extinct

    COBOL

    Division

    Multiplication

    Reproduction

    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

    October 5, 2016 at 12:50 pm

    #1905009

  • RE: Add column value depending on other value in same row

    Right now, your code can be simplified to the following.

    UPDATE dbo.SaltoCardholders

    SET <column_x> = '<some_value>'

    WHERE GPF5 = 'VWB';

    I'm sure that doesn't solve your problem, but we need more information 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

    October 5, 2016 at 10:35 am

    #1904971

  • RE: Parse street

    Following the rules you posted, here's an alternative.

    DECLARE @SourceTable TABLE (

    ID INT IDENTITY(1,1)

    , adres VARCHAR(255)

    );

    INSERT INTO @SourceTable (adres)

    VALUES (' molenweg 9a '), (' molenweg...

    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

    October 5, 2016 at 7:47 am

    #1904908

  • RE: Today's Random Word!

    ZZartin (10/4/2016)

    Ed Wagner (10/4/2016)

    djj (10/4/2016)

    Jeff Moden (10/4/2016)

    whereisSQL? (10/4/2016)

    Manic Star (10/4/2016)

    djj (10/3/2016)

    Ray K (10/3/2016)

    Ed Wagner (10/3/2016)

    Revenant (10/3/2016)

    Grumpy DBA (10/3/2016)

    Ed Wagner (10/3/2016)

    Quantity

    Quality

    Life

    Family

    Guy

    Gal

    Offspring

    Wannabe

    Interview

    GETDATE()

    Fail

    CURRENT_TIMESTAMP

    ANSI

    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

    October 4, 2016 at 1:05 pm

    #1904735

Viewing 15 posts - 2,071 through 2,085 (of 8,731 total)