Forum Replies Created

Viewing 15 posts - 3,946 through 3,960 (of 5,502 total)

  • RE: How to query cross-database in Service Broker activated Stored Procedure

    Most probably the following link will help you to resolve that problem:

    http://rusanu.com/2006/03/07/call-a-procedure-in-another-database-from-an-activated-procedure/


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    March 18, 2010 at 6:15 pm

    #1136393

  • RE: Extract Monthly report but Different DATE Format data into SQL server 2005 Database

    I was talking about a datetime column. The data would be stored in the database standard edit: internal format and, if formatting of result sets is required, this would either...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    March 18, 2010 at 3:26 pm

    #1136346

  • RE: Increasing the value of an identity column based off a column value?

    There is no column [DonorID] in your sample table. Where

    City, state and zip as well as some other columns defined as VARCHAR(8000) seems to be "slightly oversized".

    Finally: Your sample data...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    March 18, 2010 at 3:06 pm

    #1136333

  • RE: Extract Monthly report but Different DATE Format data into SQL server 2005 Database

    The following code would allow you to convert ISO8601 with time zone (aka as style 127) into a valid datetime format.

    SELECT CAST('2008-09-18T15:52:00.000-04:00' AS XML).value('xs:dateTime(.[1])', 'datetime')

    I strongly recommend to enforce using...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    March 18, 2010 at 1:10 pm

    #1136236

  • RE: Nested Loop Joins on Temp Tables

    @ryan-2:

    Maybe you could convince your "DBA" to start a thread here at SSC with a title like "What are the benefits/costs of disabled statistics on tempdb?"

    Side note: Usage of "DBA"...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    March 17, 2010 at 5:42 pm

    #1135641

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (3/17/2010)

    tstaker (3/17/2010)

    Just thought of a great idea for an article for one of you forum vets. Top 10 DBAs Myths

    That should stir up plenty of controversy. Maybe...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    March 17, 2010 at 5:32 pm

    #1135639

  • RE: Increasing the value of an identity column based off a column value?

    mth13 (3/17/2010)

    ...

    The table which holds the donors just needs to be ordered by receipt; that way, like receipts are together. This Table2 still holds all six donors, and I need...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    March 17, 2010 at 4:56 pm

    #1135628

  • RE: Representing a hierarchy from comma separated values

    Please clarify the interpretation of the "hierarchy".

    Example: 'grandson1,son1,grandfather1' can mean anything:

    Some scenarios:

    a)

    Parent: grandfather1

    Child1: son1

    Child2: grandson1

    b)

    Parent: grandfather1

    Child: son1

    Parent: son1

    Child: grandson1

    c)

    Parent: son1

    LeftChild: grandson1

    ...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    March 17, 2010 at 3:21 pm

    #1135577

  • RE: Increasing the value of an identity column based off a column value?

    @steve-2: You're right. Row_number and the like is not an option here. Unfortunately.

    @mike-2: If the data you have actually look like the sample you descirbed it's fairly easy (DELETE ID>4).

    Therefore,...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    March 17, 2010 at 2:39 pm

    #1135553

  • RE: Querying reserved words?

    assuming SS2K5 I'd use a table holding all reserved words I'd like to chek (e.g. from this web site: https://publib.boulder.ibm.com/infocenter/wasinfo/v6r1/index.jsp?topic=/com.ibm.etools.ejbbatchdeploy.doc/topics/rsqlMSSQLSERVER_2005.html

    )

    and join that to sys.syscolumns.name and sys.sysobjects.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    March 17, 2010 at 12:37 pm

    #1135487

  • RE: insert data in batches

    Would it be possible for you to post the procedure?

    Mabe we can help to speed it up a little bit.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    March 17, 2010 at 11:19 am

    #1135431

  • RE: Enabling and Setting up DatabaseMail in SSE2005

    As to my knowledge SSE2005 is not set up to use sp_send_dbmail by default. There are some important files missing.

    However, there seems to be a solution where it's possible to...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    March 16, 2010 at 6:33 pm

    #1134938

  • RE: T-Sql Problem

    The Dixie Flatline (3/16/2010)

    ...

    Take Lutz up on his offer. He knows what he's talking about. ...

    :blush: May I quote you when talking to my boss next...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    March 16, 2010 at 5:33 pm

    #1134922

  • RE: Are the posted questions getting worse?

    Slightly off-topic:

    Anybody interested in helping me out here?

    I'm starting (already started?) to leave my comfort-zone and don't want to misguide the OP...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    March 16, 2010 at 4:36 pm

    #1134908

  • RE: need to combine multiple rows to a single row

    Please have a look at the CrossTab article referenced in my signature.

    If the number of uniqueNum columns is unknown, you might want to have a look into the DynamicCrossTab article...


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

    March 16, 2010 at 4:30 pm

    #1134906

Viewing 15 posts - 3,946 through 3,960 (of 5,502 total)