Forum Replies Created

Viewing 15 posts - 42,811 through 42,825 (of 59,063 total)

  • RE: CLR Fail to load

    jqd2001 (7/21/2009)

    There are a lot of business rules regarding output that are difficult to express in T-SQL.

    Unless it has to do with effecient RegEx, I've not known that to be...

    --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)

    July 22, 2009 at 6:26 am

    #1028243

  • RE: SQL View

    frecal (7/22/2009)

    I am using it as one to many ..one parent can have multipe relationships.

    the query only really will indicate that the record has a relationship with another record in...

    --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)

    July 22, 2009 at 6:17 am

    #1028238

  • RE: order by alphanumeric value

    Thanks for the feedback... heh... wish I caught it before the first time I got burned by it. 😛

    --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)

    July 22, 2009 at 6:09 am

    #1028233

  • RE: split field into numbers and join to table

    My humble apologies... looking back at this thread, I was wrong because I misread the intention. I allowed my fervor against having a CSV column in a table...

    --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)

    July 22, 2009 at 6:05 am

    #1028227

  • RE: Pulling Filename from Windows directory into table

    The following method is a bit slow so far as I'm concerned, but it's also pretty safe. Let me know if you need something a whole lot faster with...

    --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)

    July 21, 2009 at 10:40 pm

    #1028086

  • RE: CLR Fail to load

    jqd2001 (7/21/2009)

    Jeff,

    The CLR Function, exec select statement, using datareader to iterate through, return result set in a table. The assembly marked SAFE.

    Server is 64bit developer edition. We have a...

    --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)

    July 21, 2009 at 10:07 pm

    #1028082

  • RE: SQL View

    frecal (7/20/2009)

    I have been trying to work this out from some of the other requests but havnt had much luck so thought id post another one.

    I have Name table with...

    --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)

    July 21, 2009 at 8:48 pm

    #1028065

  • RE: Return Value = 0, should be newly inserted primary key

    I've never used PowerShell but I'm interested in it... anyone got an idea on this problem? Thanks.

    --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)

    July 21, 2009 at 7:45 pm

    #1028055

  • RE: Data getting deleted automatically

    You might also want to make that trigger an "Instead of" trigger so that not only are you capturing the information you want to catch the culprit, you're also preventing...

    --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)

    July 21, 2009 at 7:38 pm

    #1028054

  • RE: order by alphanumeric value

    Using code very similar to Dave's otherwise great example, try this...

    create table #temp

    (

    Response varchar(500)

    );

     

    insert into #temp values(0)

    insert into #temp values(1)

    insert into #temp values(2)

    insert into #temp values(10)

    insert into #temp values(3)

    insert into...

    --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)

    July 21, 2009 at 7:32 pm

    #1028053

  • RE: order by alphanumeric value

    keerthy.vishweshwarachar (7/21/2009)

    Great!!

    This is what I required...

    Thanks

    Ummm... be careful... try it with the value like '1e2'. Never use "IsNumeric" as an "IsAllDigits" function because it's not. 😉

    --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)

    July 21, 2009 at 6:42 pm

    #1028047

  • RE: microsoft support

    Heh... on the flip side, who cares? If you've got system with the latest sp and some of the hot fixes and it's been up and running for...

    --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)

    July 21, 2009 at 6:36 pm

    #1028046

  • RE: sqlservr.exe showing high CPU

    It could be normal for the apps you're running or there might be a scheduled job that runs every 5 minutes or it could be replication or it could be....

    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)

    July 21, 2009 at 6:30 pm

    #1028044

  • RE: ORDER BY [DATE] producing unordered result

    jay.jose (7/21/2009)

    I'll be posting more problems as they arise ^_^

    I recommend you study the article at the first link in my signature lines below before you do that. You'll...

    --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)

    July 21, 2009 at 6:24 pm

    #1028042

  • RE: Table partitioned on date

    sturner (7/21/2009)

    before you move to a partitioning solution you should look at the table design and the reasons why the table is getting so big or your performance is getting...

    --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)

    July 21, 2009 at 6:20 pm

    #1028041

Viewing 15 posts - 42,811 through 42,825 (of 59,063 total)