Forum Replies Created

Viewing 15 posts - 25,351 through 25,365 (of 59,099 total)

  • RE: Count for each account no -parent and childsql

    nutty (11/21/2013)

    Yes it does match what I want as output.

    However the trouble is, these child codes are common codes for various other parent codes.

    For example two different parents can share...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 21, 2013 at 2:36 pm

    #1668254

  • RE: What is SQL Server not good at?

    Steve Jones - SSC Editor (11/21/2013)

    Jeff Moden (11/20/2013)

    The article link in the post above doesn't work. It takes me to a "Not found" window.

    Do you mean the URL to...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 21, 2013 at 2:31 pm

    #1668251

  • RE: SQLCMD

    opc.three (11/20/2013)

    And the sysadmin members? ...oh that's right, you argue that you must trust them implicitly.

    Jeez, Orlando. If you can't trust an SQL Server Admin or a Windows Admin...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 21, 2013 at 8:27 am

    #1668136

  • RE: SQLCMD

    That's just it. There are no security challenges to it. I don't allow users to use xp_CmdShell directly. I don't allow apps to execute it directly (never...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 20, 2013 at 10:52 pm

    #1668025

  • RE: SQLCMD

    opc.three (11/20/2013)

    Jeff Moden (11/20/2013)

    opc.three (11/20/2013)

    Chances are I could accomplish this through a SQLCLR. I could definitely setup an Agent job that a low-priv user could run by executing a stored...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 20, 2013 at 10:36 pm

    #1668023

  • RE: SQLCMD

    opc.three (11/20/2013)

    Chances are I could accomplish this through a SQLCLR. I could definitely setup an Agent job that a low-priv user could run by executing a stored proc.

    Heh... who...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 20, 2013 at 10:29 pm

    #1668020

  • RE: What is SQL Server not good at?

    The article link in the post above doesn't work. It takes me to a "Not found" window.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 20, 2013 at 10:11 pm

    #1668019

  • RE: SQLCMD

    opc.three (11/20/2013)

    I can think of ways a non-SA could be setup so they could enable xp_cmdshell without the use of a proxy. Your point?

    I can think of ways a non-SA...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 20, 2013 at 9:50 pm

    #1668016

  • RE: Count for each account no -parent and childsql

    nutty (11/20/2013)

    Hi Guys

    I have a data where there are parent and child product.

    Each parent has got a unique code(P1) and a link code (L1) on their account

    and each...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 20, 2013 at 9:03 pm

    #1668009

  • RE: T-SQL join to same table n number of times

    jend (11/20/2013)

    Apologies for not being clear. This is a trimmed down table definition and some example data...

    CREATE TABLE [dbo].[ITEM_SUPERSESSION](

    [Superseeded_Item] [char](15) NOT NULL,

    [Superseeding_Item] [char](15) NOT NULL,

    CONSTRAINT [PK_ITEM_SUPERSESSION] PRIMARY KEY CLUSTERED...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 20, 2013 at 8:36 pm

    #1668007

  • RE: SQLCMD

    opc.three (11/20/2013)

    Jeff Moden (11/20/2013)

    opc.three (11/19/2013)

    Jeff Moden (11/5/2013)

    SQLRNNR (11/5/2013)

    Jeff Moden (11/5/2013)

    Heh... I had to think about it. For me, the correct answer would have started with "Exec xp_CmdShell". 😀

    not sp_configure??

    :w00t::-D

    Heck...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 20, 2013 at 5:52 pm

    #1667987

  • RE: Convert a field from numeric type to date format

    Heh... I remember some of the original computer games. If you can't move left, right, forward, back, up, or down, then change color!

    Add a persisted computed column to the...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 20, 2013 at 4:31 pm

    #1667967

  • RE: Pivot All Columns

    You could maintain some semblence of the meta-date for each "element" by using SQL_Variant for this.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 20, 2013 at 4:11 pm

    #1667963

  • RE: odd situation

    This is a very good example of why you should (and I don't use the word often) ALWAYS use the two part naming convention. 😉

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 20, 2013 at 4:03 pm

    #1667962

  • RE: Count for each account no -parent and childsql

    nutty (11/20/2013)

    Thanks for this.

    I am working in pl/sql and it says 'LEFT' as an invalid identifier

    Change the LEFT to a SUBSTRING starting at 1 with a length the same...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    November 20, 2013 at 4:01 pm

    #1667959

Viewing 15 posts - 25,351 through 25,365 (of 59,099 total)