Forum Replies Created

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

  • RE: Dynamically concatenating multiple columns in a sequence

    This was fun, but I'm not sure I have the complete solution. The difficult part is done without dynamic sql.

    By the way, this seems like a really bad design, but...

    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 16, 2014 at 1:50 pm

    #1752954

  • RE: Need help regarding a procedure.

    You could try deleting the rows in batches. According to your recovery model, there'll be differences on how would you need to code it.

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

    #1752900

  • RE: Ssis import file

    There should be a way to do it completely in SSIS, but you could create a table in SQL Server to query the correct path according to your dates.

    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 15, 2014 at 4:28 pm

    #1752700

  • RE: DateDiff between two consecutive rows

    You can change the CTE for a subquery.

    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 15, 2014 at 4:19 pm

    #1752698

  • RE: Adding two month

    I'm leaving 2 options in here. The problem is that you're formatting your date in different parts.

    Date formatting should be done in the front end to avoid problems.

    CREATE TABLE DateTest(

    ...

    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 15, 2014 at 4:17 pm

    #1752697

  • RE: Can somebody help with this sql query behavior -URGENT

    Just to add what Jack and Batgirl already said. Here's a little test that you can make. If you want to have an exact rounding, you need to use an...

    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 15, 2014 at 1:08 pm

    #1752667

  • RE: Need help regarding a procedure.

    If you're deleting all the rows from the tables, you might want to consider TRUNCATE.

    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 15, 2014 at 8:41 am

    #1752568

  • RE: Are the posted questions getting worse?

    Grant, Congratulations on being elected as a member of the PASS board!

    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 15, 2014 at 7:22 am

    #1752521

  • RE: to preserve line breaks

    The results grid will remove the line breaks, there's no way to change that. You need a front end that can display line breaks.

    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 14, 2014 at 5:08 pm

    #1752359

  • RE: Zero out Parent row from a Merge Statement

    I'm not sure if a "WHEN NOT MATCHED BY SOURCE" would be what you need. It gives the expected result, but I'm not sure if it's the logic needed.

    ...

    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 14, 2014 at 5:00 pm

    #1752357

  • RE: to preserve line breaks

    SQL Server stores the line breaks without any problem. One of your applications must be removing the line breaks.

    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 14, 2014 at 4:48 pm

    #1752354

  • RE: Significant performance dropping when use CASE statement

    Lynn Pettis (10/14/2014)

    Without seeing the table structures (columns and definitions) or the execution plan (which will show what is happening) not much we can do to help.

    It could be implicit...

    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 14, 2014 at 4:06 pm

    #1752347

  • RE: check varchar column for values that are only numeric - HOW

    ScottPletcher (10/14/2014)

    I suggest a different method to avoid 2 or more decimal points:

    AND CASE

    ...

    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 14, 2014 at 4:02 pm

    #1752345

  • RE: Securing objects for a new user (what's the easiest way?)

    You can also grant multiple permissions on a single instruction.

    GRANT INSERT, SELECT, UPDATE, DELETE ON ObjectName TO UserName

    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 14, 2014 at 4:02 pm

    #1752344

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (10/14/2014)

    Luis Cazares (10/14/2014)

    That sounds like a good and bad news. And the good news sound great.

    Thank you for the update, Steve.

    In an unrelated topic, have you ever seen...

    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 14, 2014 at 2:28 pm

    #1752317

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