Forum Replies Created

Viewing 15 posts - 4,381 through 4,395 (of 8,731 total)

  • RE: Are the posted questions getting worse?

    The amazing part is that this same poster was in charge of a 2005 to 2012 migration. :w00t:

    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 17, 2015 at 11:25 am

    #1820520

  • RE: Date format issue in SSIS

    The problem is that your date is not really a date. Is a numeric value that will be implicitly converted to a date to extract the year, month and day....

    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 17, 2015 at 7:14 am

    #1820422

  • RE: varchar to datetime

    Simply use CONVERT( datetime, TheData) or CAST( TheData AS datetime).

    Reference: https://msdn.microsoft.com/en-us/library/ms187928.aspx

    FYI, datetime is not stored in any format. The formats are for display and the same value can be shown...

    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 14, 2015 at 1:50 pm

    #1820213

  • RE: xp_cmdshell

    Have you read this article?

    https://www.mssqltips.com/sqlservertip/2875/how-to-allow-ad-hoc-updates-in-sql-server-system-catalogs/

    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 14, 2015 at 12:34 pm

    #1820185

  • RE: How to use 'or' with a substring

    Or you can go the other way around. :hehe:

    SELECT *

    FROM @JOIN_TABLE JT

    INNER JOIN @TEST_PK PK

    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

    August 14, 2015 at 12:28 pm

    #1820178

  • RE: Removal of Records dynamically using Information Schema

    Lynn Pettis (8/14/2015)

    Luis Cazares (8/14/2015)

    Small correction, they're not there for backwards compatibility, but for SQL Standard compatibility.

    True, but not every RDBMS implements them either. What good is a standard...

    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 14, 2015 at 9:27 am

    #1820104

  • RE: The Tally Table

    g.britton (8/14/2015)

    I just wish it wasn't called a "Tally" table. I don't tally things, I count them. fwiw I usually call my "tally" table "N" to reflect it's relation...

    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 14, 2015 at 9:04 am

    #1820097

  • RE: The Tally Table

    Lynn Pettis (8/14/2015)

    g.britton (8/14/2015)

    What's the purpose of doing a cross join between the master.dbo.syscolumns table, and then not using it? Sorry, inquiring minds want to know.

    to get enough numbers 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

    August 14, 2015 at 9:02 am

    #1820094

  • RE: The Tally Table

    Rod at work (8/14/2015)

    What's the purpose of doing a cross join between the master.dbo.syscolumns table, and then not using it? Sorry, inquiring minds want to know.

    Well, the point is that...

    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 14, 2015 at 8:58 am

    #1820091

  • RE: Today's Random Word!

    Ed Wagner (8/14/2015)

    crookj (8/14/2015)

    BL0B_EATER (8/14/2015)

    Ed Wagner (8/14/2015)

    SQLRNNR (8/13/2015)

    Ed Wagner (8/13/2015)

    DonlSimpson (8/12/2015)

    SQLRNNR (8/12/2015)

    Luis Cazares (8/12/2015)

    WayneS (8/12/2015)

    Ed Wagner (8/12/2015)

    Ed Wagner (8/12/2015)

    SQLRNNR (8/12/2015)

    whereisSQL? (8/12/2015)

    Ed Wagner (8/12/2015)

    Eirikur Eiriksson (8/12/2015)

    Ed Wagner (8/12/2015)

    Steve Jones - SSC...

    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 14, 2015 at 7:52 am

    #1820054

  • RE: Removal of Records dynamically using Information Schema

    Small correction, they're not there for backwards compatibility, but for SQL Standard compatibility.

    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 14, 2015 at 7:50 am

    #1820052

  • RE: Compare sql varchar in PHP

    I agree with everything that Sean said. You need an UPDATE and probably a SELECT. That's when stored procedures come in handy, as you only need to execute one line...

    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 14, 2015 at 7:44 am

    #1820049

  • RE: Are the posted questions getting worse?

    Lynn Pettis (8/13/2015)

    For the cheaper fares and more flexibility looks like I should fly in and out of DIA instead of COS.

    Another question, should I book now or still wait...

    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 13, 2015 at 2:12 pm

    #1819886

  • RE: Query that gives info twice

    I don't have an Oracle database to test against it, but it seems that you can insert and delete rows from Dual if you have Admin rights.

    The fun part is...

    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 13, 2015 at 2:05 pm

    #1819883

  • RE: Are the posted questions getting worse?

    I realized that I have a lot of free time at work when I'm in the Top Members section for the last 30 days, thinking on writing a new article...

    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 13, 2015 at 1:42 pm

    #1819876

Viewing 15 posts - 4,381 through 4,395 (of 8,731 total)