Forum Replies Created

Viewing 15 posts - 2,851 through 2,865 (of 5,502 total)

  • RE: Update Seq

    Something like

    SELECT ROW_NUMBER() OVER(PARTITION BY EMPID, ROLE ORDER BY ROLE)


    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]

    September 8, 2010 at 8:06 am

    #1217962

  • RE: SQL Query

    call4ljw (9/8/2010)

    Editted accordingly...

    Not really....

    Sample data in a ready to use format and expected result, 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]

    September 8, 2010 at 7:06 am

    #1217910

  • RE: Are the posted questions getting worse?

    WayneS (9/7/2010)

    Steve Jones - Editor (9/7/2010)

    WayneS (9/7/2010)

    Looks like Lutz is having to pull teeth to get the OP to read how to help himself out.

    Actually I picture Lutz as Wayne's...


    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]

    September 8, 2010 at 6:52 am

    #1217894

  • RE: SQL Query

    Please readand follow the advice given in the first article in my signature.

    It's unlikely you can motivate a lot of people looking at image references to see table descriptions.

    Please provide...


    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]

    September 8, 2010 at 4:24 am

    #1217822

  • RE: Integration of XQuery and T-SQL

    tonyclifton77 (9/8/2010)

    The language is supposed to be XQuery (I know the keywords shouldn't be in capital letters) 🙂

    My main problem is to transform the loop-construct to work with TSQL-Syntax,...


    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]

    September 8, 2010 at 4:13 am

    #1217818

  • RE: Need to select all elements of an XML document from an XML data type column

    @john-2:

    Since David addressing his issues implicit to your attention ignoring other posts, I leave this thread in your hands.


    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]

    September 7, 2010 at 4:43 pm

    #1217673

  • RE: Import 2010-09-07T10:40:03 with BCP Utility?

    I tried using different kinds of format files but I heven't been able to import directly into the target table.

    When I'm facing such circumstances and can't find a workaround I...


    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]

    September 7, 2010 at 3:32 pm

    #1217646

  • RE: Need to select all elements of an XML document from an XML data type column

    I might have a solution but I need some sample data to test it against.

    Especially, there's one issue that needs clarification: let's assume your first xml column has 5 nodes...


    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]

    September 7, 2010 at 3:24 pm

    #1217641

  • RE: Are the posted questions getting worse?

    jcrawf02 (9/7/2010)

    LutzM (9/7/2010)

    jcrawf02 (9/7/2010)

    Do you suppose 5 minutes to return one row of data will be too much for end users? 😛

    Now I just have to figure out what 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]

    September 7, 2010 at 3:00 pm

    #1217620

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (9/7/2010)

    WayneS (9/7/2010)

    Looks like Lutz is having to pull teeth to get the OP to read how to help himself out.

    Actually I picture Lutz as Wayne's avatar.

    As...


    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]

    September 7, 2010 at 2:38 pm

    #1217603

  • RE: Import 2010-09-07T10:40:03 with BCP Utility?

    Did you try using bulk insert instead of bcp? Seems to work...

    I created a file test.txt holding 2010-09-07 10:40:03.000.

    The following code did work without any issues:

    DECLARE @tbl TABLE

    (

    col1 DATETIME...


    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]

    September 7, 2010 at 2:16 pm

    #1217593

  • RE: Tips for writing queries needed

    mashikoo (9/7/2010)

    Here is the an example of the end result:

    Last name first name Status

    Doe John ...


    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]

    September 7, 2010 at 1:46 pm

    #1217576

  • RE: Tips for writing queries needed

    As stated before:

    Please read and follow the instructions given in the article referenced as the first link in my signature ("How to get fast answers to your question").

    You 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]

    September 7, 2010 at 1:36 pm

    #1217572

  • RE: Tips for writing queries needed

    What exactly do you want to achieve with your approach? It's still not clear.

    Again, please read and follow the instructions given in the article referenced as the first link in...


    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]

    September 7, 2010 at 1:19 pm

    #1217555

  • RE: Are the posted questions getting worse?

    jcrawf02 (9/7/2010)

    Do you suppose 5 minutes to return one row of data will be too much for end users? 😛

    Now I just have to figure out what the hell I...


    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]

    September 7, 2010 at 1:07 pm

    #1217548

Viewing 15 posts - 2,851 through 2,865 (of 5,502 total)