Forum Replies Created

Viewing 15 posts - 5,311 through 5,325 (of 8,753 total)

  • RE: Day wise and date range calculation with looping or dynamic data

    There are few ways of doing this, my guess is that you are not close to any of them but in order to help you find an acceptable solution, you...

    May 14, 2015 at 11:48 am

    #1797946

  • RE: SP and table query fails with object not found error after assinging sysadmin server role to the login

    kranp (5/14/2015)

    I am logged in sql as 'dw' login.

    When I execute the stored proc

    EXEC br_********Data

    Error:

    Msg 2812, Level 16, State 62, Line 1

    Could not find stored procedure 'br_********Data'.

    Must repeat Lynn's...

    May 14, 2015 at 11:41 am

    #1797944

  • RE: Your Cloud Held Hostage – Could It Happen?

    Steve Jones - SSC Editor (5/12/2015)

    Netflix started with relatively little bandwidth from their end. They can compete, or Steve's Video Service can compete, because few people use it. A 5Mbps...

    May 13, 2015 at 12:44 pm

    #1797648

  • RE: Today's Random Word!

    crookj (5/13/2015)

    djj (5/13/2015)

    Ed Wagner (5/13/2015)

    DonlSimpson (5/12/2015)

    TomThomson (5/12/2015)

    Ed Wagner (5/12/2015)

    Eirikur Eiriksson (5/12/2015)

    djj (5/12/2015)

    Ed Wagner (5/12/2015)

    Revenant (5/12/2015)

    SQLRNNR (5/12/2015)

    djj (5/12/2015)

    BWFC (5/12/2015)

    SQLRNNR (5/12/2015)

    whereisSQL? (5/12/2015)

    BWFC (5/12/2015)

    Intelligence

    Business

    Oxymoron

    Subjective

    Objective

    Lens

    Magnify

    Quantify

    Numbers

    Meaning

    Life

    Cycle

    Circle

    Ring

    Nazgûl

    Middle Earth

    Tree

    barrow-wight

    Ghost

    May 13, 2015 at 7:20 am

    #1797521

  • RE: Today's Random Word!

    djj (5/12/2015)

    Ed Wagner (5/12/2015)

    Revenant (5/12/2015)

    SQLRNNR (5/12/2015)

    djj (5/12/2015)

    BWFC (5/12/2015)

    SQLRNNR (5/12/2015)

    whereisSQL? (5/12/2015)

    BWFC (5/12/2015)

    Intelligence

    Business

    Oxymoron

    Subjective

    Objective

    Lens

    Magnify

    Quantify

    Numbers

    Meaning

    Life

    Cycle

    May 12, 2015 at 1:54 pm

    #1797376

  • RE: Your Cloud Held Hostage – Could It Happen?

    Eric M Russell (5/12/2015)

    Honestly, the apartment building across the street from your business could hold your database hostage every day between 5PM - midnight when folks start streaming Netflix...

    May 12, 2015 at 1:54 pm

    #1797375

  • RE: where is sql server TVF return type stored in system tables

    Bill Talada (5/11/2015)

    Eirikur Eiriksson (5/11/2015)

    Bill Talada (5/11/2015)

    Regular functions store the return value as parameter zero in sys.parameters but I can't find the TVF table definition for the following sample function....

    May 11, 2015 at 3:28 pm

    #1797118

  • RE: Today's Random Word!

    DonlSimpson (5/11/2015)

    Ed Wagner (5/11/2015)

    Revenant (5/11/2015)

    Eirikur Eiriksson (5/11/2015)

    SQLRNNR (5/11/2015)

    Ed Wagner (5/11/2015)

    Eirikur Eiriksson (5/11/2015)

    crookj (5/11/2015)

    Ed Wagner (5/11/2015)

    SQLRNNR (5/11/2015)

    rose

    Name

    Alias

    Ambiguity

    Dangerous

    sore

    Breakable

    Breakaway

    Session

    Court

    establishment

    May 11, 2015 at 3:00 pm

    #1797113

  • RE: Run block in stored procedure only during specific timeframe

    skilly2 (5/11/2015)

    I have a stored procedure that runs every 5 minutes. I have one block in the procedure that will only run if there are records in a temp...

    May 11, 2015 at 2:53 pm

    #1797111

  • RE: Index on calculated field with UDF?

    Lynn Pettis (5/11/2015)

    Raymond van Laake (5/11/2015)

    Hmm, yes was considering using a trigger... thanks for all your inputs

    When you use the GUI to make some changes to a table, SSMS will...

    May 11, 2015 at 2:34 pm

    #1797103

  • RE: where is sql server TVF return type stored in system tables

    Bill Talada (5/11/2015)

    Regular functions store the return value as parameter zero in sys.parameters but I can't find the TVF table definition for the following sample function. Is the function's...

    May 11, 2015 at 2:33 pm

    #1797102

  • RE: Calculate age - Most easiest way

    Iwas Bornready (5/11/2015)

    Wow, who knew age would generate so many responses.

    It is a sensitive subject:-D

    😎

    May 11, 2015 at 2:09 pm

    #1797095

  • RE: Index on calculated field with UDF?

    Raymond van Laake (5/11/2015)

    Sounds like it should work, however when I change my formula to:

    RTRIM(([dbo].[fx_formatTelnr]([project],[user_tel])))

    I still get the error.

    What strikes me is the following:I am trying to persist the field...

    May 11, 2015 at 2:06 pm

    #1797092

  • RE: Today's Random Word!

    SQLRNNR (5/11/2015)

    Ed Wagner (5/11/2015)

    Eirikur Eiriksson (5/11/2015)

    crookj (5/11/2015)

    Ed Wagner (5/11/2015)

    SQLRNNR (5/11/2015)

    rose

    Name

    Alias

    Ambiguity

    Dangerous

    sore

    Breakable

    May 11, 2015 at 1:43 pm

    #1797085

  • RE: Index on calculated field with UDF?

    Further on Jeff's post, simpler logic can be wrapped in SQL deterministic functions.

    😎

    This function is not deterministic although it is only a simple subtraction of two columns

    CREATE FUNCTION dbo.SVF_SUBTRACT_TAX_FROM_TOTAL

    (

    ...

    May 11, 2015 at 12:52 pm

    #1797068

Viewing 15 posts - 5,311 through 5,325 (of 8,753 total)