Forum Replies Created

Viewing 15 posts - 3,496 through 3,510 (of 5,502 total)

  • RE: Slelect Problem: kind of like a pivot but different

    I don't really understand what your table actually looks like.

    Would you please post the table def, some sample data, your expected result and what you've tried so far? For details...


    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]

    May 17, 2010 at 2:16 pm

    #1168450

  • RE: t-sql to list last 2 times job failure

    rpatil22 (5/17/2010)

    I want if last run of job failed then that date and time and same job when previously failed.

    So, I guess sp_help_jobhistory together with ROW_NUMBER() will help here. Please...


    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]

    May 17, 2010 at 2:10 pm

    #1168446

  • RE: xml schema definition for the database tables

    Please have a look at BOL (BooksOnLine, the SQL Server gelp system usually installed together with SQL Server, accessible via F1 from Management Studio). Search for the "CREATE XML SCHEMA...


    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]

    May 17, 2010 at 2:07 pm

    #1168445

  • RE: Enforce entry in one of two fields

    Would a CHECK constraint help?

    ALTER TABLE YourTable

    ADD CONSTRAINT chkCol1Col2 CHECK ( ISNULL(col1,col2) IS NOT NULL );

    This constraint would allow you to insert a NULL value either for Col1 or Col2...


    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]

    May 17, 2010 at 2:04 pm

    #1168444

  • RE: Can I make a query fail without killing the connection?

    Henry Treftz (5/17/2010)

    It is a currently running query. So what I want to do is basically do send of a raiserror to an existing connection...

    What exactly do...


    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]

    May 17, 2010 at 1:52 pm

    #1168441

  • RE: Can I make a query fail without killing the connection?

    Richard M. (5/17/2010)

    lmu92 (5/17/2010)

    Not sure what you're trying to do but maybe RAISERROR will help (see BOL for details).

    ... you can't "inject" an error to another SPID....

    As far...


    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]

    May 17, 2010 at 1:22 pm

    #1168431

  • RE: Can I make a query fail without killing the connection?

    Not sure what you're trying to do but maybe RAISERROR will help (see BOL for details).


    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]

    May 17, 2010 at 12:36 pm

    #1168414

  • RE: sql dba resume

    Another strong hint: you might want to remove your email address. If people feel the need to provide you with a sample they can drop you a PM...


    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]

    May 17, 2010 at 12:33 pm

    #1168413

  • RE: t-sql to list last 2 times job failure

    The requirement is not clear. Do you want to list only jobs where the last run and the one before failed, job that have failed twice (as per available log...


    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]

    May 17, 2010 at 12:31 pm

    #1168412

  • RE: How to Convert Rows into Columns?

    duplicate post.

    Already answered here


    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]

    May 16, 2010 at 6:36 pm

    #1168087

  • RE: Reduce the time spent on cross process communication

    neelsmail (5/16/2010)

    > You still haven't explained what you're trying to do 10,000 times a second...

    I thought I did.. but perhaps I didn't understand your question.

    I am trying to call the...


    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]

    May 16, 2010 at 12:10 pm

    #1168031

  • RE: call procedure from another procedure

    So, what does that sproc do that takes 3min?


    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]

    May 16, 2010 at 3:21 am

    #1167997

  • RE: call procedure from another procedure

    Mad-Dog (5/16/2010)

    ok.

    how can i do the service broker event to call this sp?

    THX

    Nope, it's the other way around: you SEND a message to the Service Broker queue and within the...


    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]

    May 16, 2010 at 3:04 am

    #1167995

  • RE: Data Archival - text, XML, excel, db output

    I wouldn't bother with the current design and start from scratch: what are the input tables and values and what is the expected result.

    Don't worry about the current DTS design...


    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]

    May 16, 2010 at 2:51 am

    #1167994

  • RE: call procedure from another procedure

    One option:

    Determine the condition when the 3min-sproc needs to be called either within your 2se-sproc or in the next step in the job agent. Based on that condition fire a...


    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]

    May 16, 2010 at 2:42 am

    #1167992

Viewing 15 posts - 3,496 through 3,510 (of 5,502 total)