Forum Replies Created

Viewing 15 posts - 5,731 through 5,745 (of 8,731 total)

  • RE: Are the posted questions getting worse?

    Does anyone have any experience with APS (Microsoft Analytics Platform System)? Would you mind sharing how that worked for 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

    October 3, 2014 at 5:06 pm

    #1750106

  • RE: Recursive replace Japanese to English characters

    Not underestimating adaddio's solution which is the base for my solution, I just made some changes. Using a recursive query as a counter is a bad idea and can generate...

    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 3, 2014 at 4:55 pm

    #1750104

  • RE: I have a problem with a bad install of BIDS 2008

    I believe that I had the same problem once, but I can't be 100% percent sure.

    Could you post the exact error message that you get?

    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 3, 2014 at 9:05 am

    #1750002

  • RE: Remove non alpha chars from a column

    The problem with your code, Don, is that it only handles scalar values.

    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 2, 2014 at 5:55 pm

    #1749858

  • RE: having trouble changing varchar to datetime

    Other than using CAST instead of CONVERT, how is that different from what I posted?

    I included the other way around to prevent using functions on the column used in 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

    October 2, 2014 at 3:15 pm

    #1749815

  • RE: Looking for advice on DATE_FORMAT()

    DATE_FORMAT is from MySQL and MariaDB. What are you using?

    For SQL Server most of us use CONVERT() along with the adequate format code. http://msdn.microsoft.com/en-us/library/ms187928.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

    October 2, 2014 at 11:37 am

    #1749762

  • RE: having trouble changing varchar to datetime

    I feel your pain as I have to work in similar conditions. However, I felt that I needed to share the best option even if most times is not 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

    October 2, 2014 at 10:58 am

    #1749749

  • RE: having trouble changing varchar to datetime

    You can format your string with STUFF(). However, I wouldn't advice to convert your column. You should convert the GETDATE()-1 to string or even better, change the column data type...

    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 2, 2014 at 10:13 am

    #1749734

  • RE: Using ORDER BY in a query returns more rows than if ORDER BY is not used

    There's no way that your ORDER BY will change the results, it must be something else.

    Your query is full of UDFs that will affect performance in a severe way, specially...

    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 2, 2014 at 9:59 am

    #1749730

  • RE: Reverse recursion for some specific statistical calculation

    Hi, welcome to the forums.

    It's considered polite to post the sample data as DDL and insert statements as well as the expected output based on the sample data. This time,...

    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 2, 2014 at 9:35 am

    #1749719

  • RE: How can I cut certain values in a strig to separate columns

    You used group by, but did you use the aggregate function? Are you sure you know what you're grouping by? No cursor is needed. In fact, the solution is so...

    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 2, 2014 at 9:10 am

    #1749709

  • RE: Using ORDER BY in a query returns more rows than if ORDER BY is not used

    ORDER BY won't change the number of rows, it has to be something else. Could you post the queries that you're using?

    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 2, 2014 at 9:07 am

    #1749708

  • RE: How can I cut certain values in a strig to separate columns

    You need to add an aggregate function to your CASE statements. It's all explained in the articles that I mentioned earlier this year.

    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 2, 2014 at 8:17 am

    #1749689

  • RE: BULK INSERT from variable Date Filename - ERROR

    You might be missing a space between your data file path and WITH keyword. Do you really don't have a row terminator?

    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 2, 2014 at 8:03 am

    #1749685

  • RE: Seems like a simple problem. Need to decrease an Amt by a fixed maximum spread over several rows.

    Have you tried the Quirky Update? It's explained in the following article: http://www.sqlservercentral.com/articles/T-SQL/68467/

    Be sure to understand it, follow the rules and test it correctly.

    Here's an idea using your sample tables.

    declare...

    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 1, 2014 at 6:58 pm

    #1749577

Viewing 15 posts - 5,731 through 5,745 (of 8,731 total)