Forum Replies Created

Viewing 15 posts - 7,006 through 7,020 (of 8,731 total)

  • RE: How comma separated values are divided into rows?

    Evil Kraig F (2/6/2014)

    Jeff, do you have SSIS 2k8 available to you or do you need said examples in 2k5?

    That's just mean 😀

    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

    February 6, 2014 at 5:31 pm

    #1686859

  • RE: Testing the new "This worked" functionality.

    Sean Lange (2/6/2014)

    And I can even mark my own response as the solution. 😛

    Sometimes the OP finds the solution a couple of minutes after posting the question and posts the...

    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

    February 6, 2014 at 3:00 pm

    #1686827

  • RE: Testing the new "This worked" functionality.

    Could you mark all of them?

    This could be called as the green thread 😀

    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

    February 6, 2014 at 2:51 pm

    #1686809

  • RE: Testing the new "This worked" functionality.

    Koen Verbeeck (2/6/2014)

    SQLRNNR (2/6/2014)

    This is the best most absolutely accurate answer so far.

    I tend to disagree.

    I agree that we should disagree. :hehe:

    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

    February 6, 2014 at 2:47 pm

    #1686801

  • RE: Are the posted questions getting worse?

    There seems to be a new feature in the forums to mark answers that worked for the OP.

    What do you think about this? I'm not sure if it's only possible...

    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

    February 6, 2014 at 2:26 pm

    #1686780

  • RE: Number of Records Affected

    jayoub (2/6/2014)

    The rollback tran works perfectly for me. Thank you very much.

    Not sure why you guys call me OP but not concerned.

    OP stands for Original Poster. That's...

    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

    February 6, 2014 at 1:16 pm

    #1686744

  • RE: Ranges that have excluded ranges

    Sean Lange (2/6/2014)

    ChrisM@home (2/6/2014)

    Hey Luis I don't know if you can see what I've just seen on this funny little mobly but you my friend may just be the first!...

    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

    February 6, 2014 at 1:10 pm

    #1686738

  • RE: Find the Nth Occurrence of a Character in a String

    This is an old thread but I would suggest a different approach. It might get give better results performance wise.

    /*

    Example:

    SELECT dbo.CHARINDEX2('a', 'abbabba', 3)

    returns the location of the third occurrence of...

    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

    February 6, 2014 at 1:08 pm

    #1686737

  • RE: Ranges that have excluded ranges

    I added some comments to the original code that might help you to understand what's going on.

    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

    February 6, 2014 at 12:41 pm

    #1686728

  • RE: last 6 months data

    I've been thinking on what to answer here. It seems that you haven't understood the query. I could get the result, but I want you to try harder and research...

    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

    February 6, 2014 at 11:47 am

    #1686716

  • RE: How do I get data for last 13 months grouped by Month

    Please don't post in several forums, you'll just divide the possible help given to you.

    All answers should go in: http://www.sqlservercentral.com/Forums/Topic1538780-391-1.aspx

    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

    February 6, 2014 at 11:45 am

    #1686715

  • RE: Ranges that have excluded ranges

    You're welcome.

    But, do you understand how does it work?

    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

    February 6, 2014 at 11:43 am

    #1686714

  • RE: Help on splitting strings based on patterns

    Even if the article is not related directly with this problem, it gave me the idea for the CHAR(7) option. 🙂

    http://www.sqlservercentral.com/articles/T-SQL/68378/

    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

    February 6, 2014 at 11:39 am

    #1686713

  • RE: Help on splitting strings based on patterns

    Sean Lange (2/6/2014)

    Another option would be to use Dwain Camps' pattern based splitter.

    That splitter is made to split string when the delimiter is not a constant, because it won't perform...

    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

    February 6, 2014 at 11:31 am

    #1686710

  • RE: Ranges that have excluded ranges

    Maybe something like this could work.

    WITH cteTally AS(

    --Use TOP to return only the number of rows needed for all ranges

    SELECT TOP((SELECT MAX([End]) FROM @ranges) - (SELECT MIN([Start]) FROM @ranges) +...

    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

    February 6, 2014 at 11:06 am

    #1686699

Viewing 15 posts - 7,006 through 7,020 (of 8,731 total)