Forum Replies Created

Viewing 15 posts - 781 through 795 (of 8,731 total)

  • RE: What are the contents?

    I guess Joe is not in the table because he's not elite? :hehe:
    Go Ravens!

    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

    December 18, 2017 at 9:59 am

    #1972544

  • RE: Is there any obvious performance difference between updating 1 column in a 4 column wide table vs 1 columns in a 1000 column wide table ?

    Jeff Moden - Saturday, December 16, 2017 12:35 PM

    Luis Cazares - Saturday, December 16, 2017 12:23 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

    December 16, 2017 at 9:14 pm

    #1972394

  • RE: Is there any obvious performance difference between updating 1 column in a 4 column wide table vs 1 columns in a 1000 column wide table ?

    There's too much speculation and little details with no further replies from the OP.

    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

    December 16, 2017 at 12:23 pm

    #1972387

  • RE: Issues with matching pattern using LIKE

    What about avoiding the pattern match and check for valid date values?

    DECLARE @searchString varchar(1500);

    SET @searchString='03/09/2017 07:52 AM | Lastname, Firstname | Completed - irrelevant...

    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

    December 15, 2017 at 8:09 am

    #1972305

  • RE: Issues with matching pattern using LIKE

    Why would you try to escape the pipe? It's not a wildcard in t-sql.

    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

    December 15, 2017 at 7:40 am

    #1972297

  • RE: Pivot "mergings" cells

    Sure, you can read the following article to know the best way to do it.
    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - SQLServerCentral

    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

    December 14, 2017 at 1:30 pm

    #1972220

  • RE: Is there any obvious performance difference between updating 1 column in a 4 column wide table vs 1 columns in a 1000 column wide table ?

    koustav_1982 - Thursday, December 14, 2017 12:53 PM

    I have a table with 4 columns and 10 million rows in which 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

    December 14, 2017 at 1:24 pm

    #1972217

  • RE: Are the posted questions getting worse?

    Lynn Pettis - Thursday, December 14, 2017 12:52 PM

    TomThomson - Thursday, December 14, 2017 12:37 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

    December 14, 2017 at 1:12 pm

    #1972214

  • RE: Are the posted questions getting worse?

    Brandie Tarvin - Thursday, December 14, 2017 5:48 AM

    So this article hits a little close to home (the references 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

    December 14, 2017 at 12:14 pm

    #1972207

  • RE: how does sql stmt gets executed ?

    I suggest that you read this article from Itzik Ben-Gan.
    http://www.itprotoday.com/microsoft-sql-server/logical-query-processing-what-it-and-what-it-means-you

    You also need to learn about execution plans and the different operators. You'll understand that tables...

    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

    December 14, 2017 at 10:36 am

    #1972177

  • RE: I got date conversion error

    rkordonsky 63916 - Thursday, December 14, 2017 9:22 AM

    Luis Cazares - Thursday, December 14, 2017 9:01 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

    December 14, 2017 at 9:36 am

    #1972169

  • RE: I got date conversion error

    What happens if you run the following query?

    SELECT YAB
    FROM UD_Indiv_Data
    WHERE YAB IS NOT NULL
    AND TRY_CAST( YAB AS DATETIME) IS NULL;

    If...

    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

    December 14, 2017 at 9:01 am

    #1972160

  • RE: Missing index question

    Jeff Moden - Wednesday, December 13, 2017 6:47 AM

    Grant Fritchey - Wednesday, December 13, 2017 2:24 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

    December 13, 2017 at 7:52 am

    #1971956

  • RE: COUNT CASE WHEN

    Is the data coming from different tables?
    It seems that the easiest way would be to use both queries as CTEs and use a FULL JOIN between them.
    Something like...

    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

    December 13, 2017 at 7:47 am

    #1971954

  • RE: Intellisense broken?

    I've experienced problems with Intellisense when the connection is slow or the database is too large. Try refreshing the cache and give it some time to do it.
    Or you...

    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

    December 12, 2017 at 8:37 am

    #1971762

Viewing 15 posts - 781 through 795 (of 8,731 total)