Forum Replies Created

Viewing 15 posts - 3,301 through 3,315 (of 8,731 total)

  • RE: Error in having clause!

    The error seems to be the CAST() functions. Use TRUNC() as you did on your column list.

    For SQL Server, you can't use UNIQUE or TRUNC(), for Oracle your can't use...

    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

    February 23, 2016 at 7:34 am

    #1860404

  • RE: Help with performance (triggers)

    I'd suggest you to use extended events. There are many places where you can find information about how to do what you want.

    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

    February 22, 2016 at 2:36 pm

    #1860201

  • RE: Update with two date columns, need converting

    If Column2 is a Date column, you need to assign a complete date. The year is not a date, it's an integer value. If you want to change the data...

    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

    February 22, 2016 at 9:31 am

    #1860128

  • RE: Why is it that NULL value will be automatically embedded in square brackets in insertion script?

    marin-231997 (2/22/2016)

    Hello all,

    I have encountered following problem lately:

    when an insertion script is done via

    INSERT INTO myTable (col1,col2,col3) VALUES ('TEST1','TEST2',NULL)

    the value NULL will be somehow automatically embedded in square...

    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

    February 22, 2016 at 9:22 am

    #1860125

  • RE: Multi-valued Parameter Query issue

    Jabba1963 (2/22/2016)

    Looked at the article and slightly confused as to how to utilise the function... no I lie - correction - I am very confused since I am not delimiting...

    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

    February 22, 2016 at 9:14 am

    #1860122

  • RE: Help executing a Stored Procedure

    Sean Lange (2/22/2016)

    TSQL Tryer (2/22/2016)

    ALTER PROCEDURE [dbo].[usp_test_Arrears_BrokenArrangement]

    @PolicyId INT, @AccountId INT, @PolicyNodeId INT, @output BIT OUT

    AS

    BEGIN

    SET NOCOUNT ON;

    SET @AccountId = 1

    DECLARE @CurrentArrangement as bit

    DECLARE @LastSystemActionId as int

    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

    February 22, 2016 at 8:57 am

    #1860114

  • RE: Today's Random Word!

    Ed Wagner (2/22/2016)

    Grumpy DBA (2/22/2016)

    djj (2/22/2016)

    Ed Wagner (2/21/2016)

    Orlando Colamatteo (2/20/2016)

    TomThomson (2/20/2016)

    Ed Wagner (2/19/2016)

    TomThomson (2/19/2016)

    ZZartin (2/19/2016)

    Driver

    road hog

    Harley

    Davidson

    Curry

    Spice

    Girls (sorry)

    Tellmewhatchawant (sorry)

    Requirements

    Sweet dreams

    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

    February 22, 2016 at 8:32 am

    #1860109

  • RE: How do you pseudo-code/flow-chart/map existing SQL code?

    FWIW, even if the comments aren't overwhelming in the code posted, some might be prevented and the code can be improved to be almost self documenting.

    -- Insert into tblclass any...

    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

    February 22, 2016 at 7:34 am

    #1860085

  • RE: Are the posted questions getting worse?

    djj (2/22/2016)

    Luis Cazares (2/19/2016)

    Ed Wagner (2/19/2016)

    GilaMonster (2/19/2016)

    SQLRNNR (2/18/2016)

    I am seeing people claim to be an MCM for some of these interviews. I know full well they aren't an MCM. I...

    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

    February 22, 2016 at 5:37 am

    #1860052

  • RE: Are the posted questions getting worse?

    Ed Wagner (2/22/2016)

    Luis Cazares (2/19/2016)

    Ed Wagner (2/19/2016)

    GilaMonster (2/19/2016)

    SQLRNNR (2/18/2016)

    I am seeing people claim to be an MCM for some of these interviews. I know full well they aren't an MCM....

    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

    February 22, 2016 at 5:32 am

    #1860051

  • RE: Are the posted questions getting worse?

    Ed Wagner (2/19/2016)

    GilaMonster (2/19/2016)

    SQLRNNR (2/18/2016)

    I am seeing people claim to be an MCM for some of these interviews. I know full well they aren't an MCM. I have also been...

    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

    February 19, 2016 at 8:46 pm

    #1859949

  • RE: Are the posted questions getting worse?

    TomThomson (2/19/2016)

    Luis Cazares (2/19/2016)

    Hugo Kornelis (2/19/2016)

    Jeff Moden (2/19/2016)

    In that same vein, I also won't work for a company that requires you to pass an "intelligence test" or "personality test". ...

    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

    February 19, 2016 at 2:19 pm

    #1859936

  • RE: Disabled job notification

    Chitown (2/18/2016)

    Luis Cazares (2/16/2016)What happens if the second job gets disabled as well?

    Why don't you simply set notifications for successful runs?

    I have thought about setting the notification for successful runs...

    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

    February 19, 2016 at 1:29 pm

    #1859932

  • RE: Are the posted questions getting worse?

    Hugo Kornelis (2/19/2016)

    Jeff Moden (2/19/2016)

    In that same vein, I also won't work for a company that requires you to pass an "intelligence test" or "personality test". They should automatically...

    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

    February 19, 2016 at 1:19 pm

    #1859931

  • RE: Lessons from Little Green Army Men

    A story about Andy playing with a small girl using little green army men? I feel like I've seen that somewhere else. A movie perhaps? 😀

    Thanks for the nice editorial.

    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

    February 19, 2016 at 11:14 am

    #1859906

Viewing 15 posts - 3,301 through 3,315 (of 8,731 total)