Forum Replies Created

Viewing 15 posts - 1,876 through 1,890 (of 8,731 total)

  • RE: Help with a query runs forever but returns nothing.

    Jeffery Williams (11/15/2016)

    Why do the JOIN clauses seem weird and most useless?

    And thank you for the suggestion I am about to test this. The statements are dynamically generated so this...

    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

    November 15, 2016 at 9:04 am

    #1912569

  • RE: Are the posted questions getting worse?

    Y.B. (11/15/2016)

    Grant Fritchey (11/15/2016)

    That pyramid looks amazing.

    BTW, I'll be going on SQL Cruise in January. It's stopping at Cozumel. Who wants to go see the pyramid with me?

    Awesome! 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

    November 15, 2016 at 8:55 am

    #1912563

  • RE: Replace uppercase words with bold

    Eirikur Eiriksson (11/15/2016)

    Luis Cazares (11/15/2016)

    Here's an option using a modified version of the pattern splitter explained in here: http://www.sqlservercentral.com/articles/String+Manipulation/94365/

    The only modification was to make it CASE sensitive.

    Nice one Luis!

    😎

    Thank 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

    November 15, 2016 at 8:31 am

    #1912545

  • RE: Are the posted questions getting worse?

    Y.B. (11/15/2016)

    My wife and I decided to check out some Mayan ruins near one of our ports of call during our cruise. I wasn't sure what to expect other...

    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

    November 15, 2016 at 8:08 am

    #1912527

  • RE: Replace uppercase words with bold

    Here's an option using a modified version of the pattern splitter explained in here: http://www.sqlservercentral.com/articles/String+Manipulation/94365/

    The only modification was to make it CASE sensitive.

    ALTER FUNCTION [dbo].[PatternSplitCM](@List [varchar](8000) = NULL, @Pattern [varchar](50))

    RETURNS...

    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

    November 15, 2016 at 7:47 am

    #1912514

  • RE: Tables that start with "DIM" missing in AdventureWorksDatabase2012 - Please help

    mw112009 (11/15/2016)

    GM

    I am assuming that this Db will have those tables that start with the "DM" prefix ( Ex: DmDate )

    Yes, AdventureWorksDW (with whatever version number) is the data warehouse...

    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

    November 15, 2016 at 7:33 am

    #1912505

  • RE: how to remove characters char(0) to char(31)

    Eirikur Eiriksson (11/15/2016)

    lady.konvicka (11/15/2016)

    hi i have this test code which replace our problem on production

    first replace for CHAR(0) removes character 'C' --- I dont know Why

    when u set input 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

    November 15, 2016 at 7:21 am

    #1912498

  • RE: Today's Random Word!

    Ed Wagner (11/15/2016)

    djj (11/15/2016)

    Manic Star (11/15/2016)

    djj (11/15/2016)

    Ed Wagner (11/15/2016)

    BWFC (11/15/2016)

    Click

    Link

    Missing

    Dog

    Cat

    Mouse

    Cheese

    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

    November 15, 2016 at 7:06 am

    #1912490

  • RE: Performing union data with null values

    The answer is correct but the explanation seems to be missing the part where it explains why is the second NULL not counted as duplicate. Or maybe it's just me...

    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

    November 15, 2016 at 6:52 am

    #1912480

  • RE: Query

    J Livingston SQL (11/14/2016)

    sqlfriends (11/14/2016)

    Yes , that was posted by me.

    But I donot like to use recursive CTE, it is slow.

    And I wonder if there are any other...

    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

    November 14, 2016 at 12:03 pm

    #1912335

  • RE: Help with a query runs forever but returns nothing.

    Eirikur Eiriksson (11/14/2016)

    Can you post the actual execution plan, would make this a lot easier.

    😎

    If the plan contains sensitive data then you can use SQL Sentry Plan Explorer to anonymize...

    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

    November 14, 2016 at 9:51 am

    #1912309

  • RE: Help with a query runs forever but returns nothing.

    What about rewriting the WHERE clause to this?

    WHERE NOT EXISTS(

    SELECT 1

    ...

    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

    November 14, 2016 at 8:22 am

    #1912271

  • RE: Today's Random Word!

    djj (11/11/2016)

    Ed Wagner (11/11/2016)

    Revenant (11/11/2016)

    Hope

    Faith

    Charity

    goodwill

    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

    November 11, 2016 at 12:59 pm

    #1911996

  • RE: Benefits of SQL 2014/2016 over 2005 ??

    ryanbesko (11/11/2016)

    From a programmer's point of view, I couldn't live without these features, which were not available in SQL Server 2005:

    Common Table Expressions: https://msdn.microsoft.com/en-us/library/ms175972.aspx?f=255&MSPPError=-2147217396

    MERGE: https://msdn.microsoft.com/en-us/library/bb510625.aspx?f=255&MSPPError=-2147217396

    ROW_NUMBER(): https://msdn.microsoft.com/en-us/library/ms186734.aspx

    Only MERGE wasn't available 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

    November 11, 2016 at 11:51 am

    #1911975

  • RE: Series of numbers with required pair of Digits - SQL

    Here's an alternative, if the digits don't have to be consecutive. A change to make them only xxxxxxy / yxxxxxx should be easy.

    WITH CT(CN) AS (SELECT CN FROM (VALUES (0),(1),(2),(3),(4),(5),(6),(7),(8),(9))...

    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

    November 11, 2016 at 9:33 am

    #1911937

Viewing 15 posts - 1,876 through 1,890 (of 8,731 total)