Forum Replies Created

Viewing 15 posts - 7,741 through 7,755 (of 8,731 total)

  • RE: SQL Server Full to Simple to Full Recovery Model

    That is not a recommended process, you will have performance issues and you'll be losing all the advantages given by the full recovery model.

    Once I found a company where they...

    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

    September 3, 2013 at 12:32 pm

    #1647122

  • RE: How to update string based on Dates.

    It's not a very difficult task to do, you just need to have the correct tools to do it. For reference on the methods used for this solution, you should...

    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

    September 3, 2013 at 9:03 am

    #1647072

  • RE: sp_getrecords to get all records from a table

    erikd (9/2/2013)

    Sean Lange (8/29/2013)

    saravanakumar.G (8/28/2013)

    Hi,

    Thanks for the reply.

    Yes. the SP is working if we put single quotes across the tablename ('schemaname.tablename').

    I want 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

    September 2, 2013 at 12:49 pm

    #1646794

  • RE: Need Help on query

    LinksUp (9/2/2013)

    vignesh.ms (9/2/2013)

    is there any other way ?

    This way is fine. It just needs to be modified slightly to handle nulls.

    Why would you need to handle nulls? Null won't be...

    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

    September 2, 2013 at 10:28 am

    #1646780

  • RE: IF Statement based on Multiple SELECT Statements

    Yes, it is possible. However, for more information on how to do it, we need more information from you.

    Check the article linked on my signature to get better help.

    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

    September 2, 2013 at 10:01 am

    #1646779

  • RE: Need Help on query

    There might, depending on what the real information looks like. What's wrong with the given solution?

    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

    September 2, 2013 at 9:19 am

    #1646770

  • RE: Use SUM() with GROUP BY?

    If I understand correctly, you need something like this.

    SELECT SUM( CASE WHEN age BETWEEN 18 AND 25 THEN MyValue END) AS [18-25],

    SUM( CASE WHEN age BETWEEN 26 AND...

    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

    September 2, 2013 at 8:40 am

    #1646761

  • RE: Need Help on query

    Thank you for posting your sample data. If I understand correctly, the following query should help you.

    SELECT a ,

    b,

    c ,

    CASE WHEN a >= b AND a >=...

    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

    September 2, 2013 at 8:36 am

    #1646760

  • RE: Updating using # table

    It's funny, your last sentence could be my answer. An example of what you need with DDL, sample data and expected results will be handy to help 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

    September 2, 2013 at 8:33 am

    #1646759

  • RE: How to Split String

    Take a look at Jeff Moden Splitter and come back if you have questions or need help.

    http://www.sqlservercentral.com/articles/Tally+Table/72993/

    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 29, 2013 at 11:38 am

    #1646065

  • RE: Problem with data conversion

    Thank you Jeff,

    Your suggestion gave me an idea. It was actually a precision problem. I just changed to a larger precision and it was fixed. 🙂

    Code turned out like this.

    SUBSTRING([Column...

    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 28, 2013 at 5:31 pm

    #1645789

  • RE: Problem with data conversion

    Hi Koen,

    The expression works on most cases but on some values it just returns NULLS when it ignores failures or the following errors that make the task fail.

    [Derived Column [187]]...

    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 28, 2013 at 3:30 pm

    #1645754

  • RE: Sum

    Even if the solution given will show the correct result, you should consider to do this calculations in the front end.

    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 27, 2013 at 8:27 am

    #1645228

  • RE: Are the posted questions getting worse?

    Sean Lange (8/22/2013)

    Good for me...but maybe not so good for SSC's reputation as a place to get quality responses.

    Do you mean that we're destroying this site reputation? I'll better...

    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 22, 2013 at 4:17 pm

    #1644181

  • RE: Format varchar to currency.

    Could you post DDL, sample data and expected results to give us a clearer idea of what you want?

    Check the article linked on my signature to find out how. No...

    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 21, 2013 at 10:16 am

    #1643527

Viewing 15 posts - 7,741 through 7,755 (of 8,731 total)