Forum Replies Created

Viewing 15 posts - 2,611 through 2,625 (of 8,731 total)

  • RE: Are the posted questions getting worse?

    Sean Lange (6/24/2016)

    Ugh....just needing to share this unbelievably ridiculous mess I just stumbled across.

    create view [dbo].[getNewID] as select newid() as new_id;

    Really? A view to get a guid???

    But wait...it gets even...

    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

    June 24, 2016 at 10:20 am

    #1886797

  • RE: Find value is prim or not

    Anandkumar-SQL_Developer (6/24/2016)

    Thank u very much Luis Cazares for your valuable time. its working.

    The question now is. Do you understand it? Would you be able to explain it to someone else...

    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

    June 24, 2016 at 8:03 am

    #1886750

  • RE: Today's Random Word!

    Hugo Kornelis (6/24/2016)

    Ed Wagner (6/24/2016)

    Grumpy DBA (6/24/2016)

    Ed Wagner (6/24/2016)

    ThomasRushton (6/24/2016)

    Balls

    Fire

    Jerry Lee Lewis

    Slapstick

    Laurel and Hardy

    Tom & Jerry

    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

    June 24, 2016 at 7:46 am

    #1886742

  • RE: Are the posted questions getting worse?

    I'm sorry, is there any country that can give me good news? It seems that Mexico, US and UK are full of negative news and I'm getting grumpy and sarcastic...

    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

    June 24, 2016 at 7:17 am

    #1886728

  • RE: Find value is prim or not

    Your first problem is to use SQL code as VB code.

    The second problem is that you have an ELSE which you shouldn't have.

    Here's an alternative, which is simpler than Eirikur'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

    June 24, 2016 at 7:13 am

    #1886726

  • RE: Aggregates and Group BY

    Because one needs a group to show a row and the other doesn't.

    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

    June 24, 2016 at 7:00 am

    #1886724

  • RE: Convert snippet from VBA to SQL

    Your comments are completely right. I just don't want to assume something with someone new to SQL.

    It's not a problem if we change variables' values in a stored procedure, 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

    June 24, 2016 at 6:33 am

    #1886717

  • RE: Convert snippet from VBA to SQL

    patrickmcginnis59 10839 (6/23/2016)

    Luis Cazares (6/23/2016)

    itortu (6/22/2016)

    Thank you Luis C.

    You're welcome.

    Do you understand that this is not the best use of a stored procedure? Stored procedures (as any database code) 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

    June 23, 2016 at 1:52 pm

    #1886624

  • RE: A SQL Server Date Handling Issue

    trboyden (6/23/2016)

    dhaveedh (6/23/2016)

    None of your links present any information to support your assertion that 2002-02-28 00.00.00.000 is not a valid date. The ISDATE function even confirms it is 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

    June 23, 2016 at 1:44 pm

    #1886620

  • RE: A SQL Server Date Handling Issue

    trboyden (6/23/2016)

    Luis Cazares (6/23/2016)

    It is a valid date.

    What do you mean by "the correct error checking functions"?

    http://www.w3schools.com/sql/sql_dates.asp

    http://www.w3schools.com/sql/func_convert.asp

    https://msdn.microsoft.com/en-us/library/ms187347.aspx ( ISDATE() Function)

    https://technet.microsoft.com/en-us/library/ms179465(v=sql.105).aspx ( Handling Database Engine Errors )

    http://sqlmag.com/t-sql/t-sql-best-practices-part-2 (See datetime best practices...

    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

    June 23, 2016 at 11:00 am

    #1886585

  • RE: Today's Random Word!

    ThomasRushton (6/23/2016)

    Y.B. (6/23/2016)

    Ed Wagner (6/23/2016)

    Grumpy DBA (6/23/2016)

    Ed Wagner (6/23/2016)

    Plain

    Jane

    Tarzan

    Lord (of the apes)

    Flies

    Conch

    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

    June 23, 2016 at 10:42 am

    #1886582

  • RE: A SQL Server Date Handling Issue

    trboyden (6/23/2016)

    dhaveedh (6/23/2016)

    In your last post you said SELECT CONVERT(Datetime, '29-Feb-2') returns an error because SQL Server does not accept single digit years?

    Why does SELECT CONVERT(Datetime, '28-Feb-2') return 2002-02-28 00.00.00.000...

    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

    June 23, 2016 at 10:17 am

    #1886579

  • RE: Maintaining Latin characters in SQL BULK INSERT with Format File

    Lisa Slater Nicholls (6/23/2016)

    Luis Cazares (6/23/2016) It appears that UTF-8 is only compatible on 2016.

    Wow, good to know. Do you have a doc reference for this being supported...

    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

    June 23, 2016 at 10:13 am

    #1886578

  • RE: Scalar Function - Format Numbers

    Your function doesn't do all the validations that you mention. Are you aware of 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

    June 23, 2016 at 9:15 am

    #1886572

  • RE: Maintaining Latin characters in SQL BULK INSERT with Format File

    Lisa Slater Nicholls (6/22/2016)

    Hi,

    I used to do this all the time --

    My understanding has always been that UTF8 was not supported by BCP. Therefore, if the incoming file...

    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

    June 23, 2016 at 9:04 am

    #1886566

Viewing 15 posts - 2,611 through 2,625 (of 8,731 total)