Forum Replies Created

Viewing 15 posts - 4,966 through 4,980 (of 5,502 total)

  • RE: help with one sql query

    XingThing (9/14/2009)

    would adding an identity column help?

    From my personal point of view and with respect to the original question: no.

    Even with an identity column a mixed insert or an update...


    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 14, 2009 at 2:59 pm

    #1053462

  • RE: help with one sql query

    Greg Snidow (9/14/2009)

    Then what happens when you try location >= 'A9' ?

    Well, you're right, the ORDER BY Clause will lead to wrong results 🙁

    Nevertheless, I'd "blame" it on the 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]

    September 14, 2009 at 2:33 pm

    #1053448

  • RE: Advice on XML data Variable declaring, Inserting, Reading, Deleting ??

    At this point I'd like to ask you to do some research.

    Here are two possible sources:

    http://www.sqlservercentral.com/articles/SS2K5+-+XML/3022/

    and

    BOL, section "FOR XML clause".

    To play around with the various options of FOR XML is...


    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 14, 2009 at 12:27 pm

    #1053377

  • RE: Are the posted questions getting worse?

    jcrawf02 (9/14/2009)

    Lutz, gotta tell you, you're a genius! Your direction given in http://www.sqlservercentral.com/Forums/Topic785337-1291-1.aspx has answered all questions, no more need for forums.

    To quote:

    The answer is simple as well:

    SELECT *...


    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 14, 2009 at 12:15 pm

    #1053373

  • RE: Date Formatting

    jsheikabdullah (9/14/2009)

    In the front end can u tell me the logic how to do it

    For what type of front end?


    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 14, 2009 at 2:09 am

    #1053000

  • RE: Date Formatting

    Where do you want to convert the date format - SSRS or Database?

    If the latter I strongly recommend against it. Date formatting should be done at the front end side...


    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 14, 2009 at 1:13 am

    #1052974

  • RE: Can't Import Data Fast Enough - Optimize or rethink the design?

    It is a 4-core server, I don't know how many are dedicated to SQL, how can I check this?

    In Management Studio, right click on the Server in the Object...


    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 13, 2009 at 4:14 pm

    #1052875

  • RE: Can't Import Data Fast Enough - Optimize or rethink the design?

    Does your console app allow for parallel processing?

    What is the hardware configuration of your Server? (e.g. How many CPU's and how many of them usable for SQL Server?)

    Do you import...


    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 13, 2009 at 2:22 pm

    #1052852

  • RE: SSRS Deployment is so troublesome!!

    Duplicate post.

    Please continue 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]

    September 13, 2009 at 11:16 am

    #1052841

  • RE: Help! Error converting data type nvarchar to float.

    Hi phanatico,

    posting way over 400 lines of VB code in an SQL forum probably won't find many volunteers to look at it...

    You should try to narrow the issue down 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]

    September 13, 2009 at 6:40 am

    #1052810

  • RE: Advice on XML data Variable declaring, Inserting, Reading, Deleting ??

    venu_ksheerasagaram (9/13/2009)

    Thank you Lutz,

    Thanks a lot.

    You're very welcome. 🙂

    If you'd like to (or have to) look deeper into XQuery I'd like to redirect you to one of my...


    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 13, 2009 at 6:32 am

    #1052807

  • RE: Advice on XML data Variable declaring, Inserting, Reading, Deleting ??

    Change your select clause to

    SELECT c.value('Name[1]', 'varchar(50)'),

    c.value('EmpNtId[1]', 'varchar(30)'),

    c.value('CreateBy[1]', 'varchar(30)'),

    ...


    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 13, 2009 at 6:18 am

    #1052802

  • RE: Advice on XML data Variable declaring, Inserting, Reading, Deleting ??

    Paul White (9/13/2009)

    Thanks Lutz. Let's try that again, with the xml formatter (see below).

    If that fails, I'll attach it as a file!

    It fails, but it's successful at the same...


    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 13, 2009 at 5:57 am

    #1052797

  • RE: Advice on XML data Variable declaring, Inserting, Reading, Deleting ??

    Did you copy it straight from the front end or did you use the "Quote" button to see the "real code"?

    Reason: SSC displays XML data not exactly as 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 13, 2009 at 5:42 am

    #1052791

  • RE: Complex updates

    Following please find an untested proposal.

    It should be verified using a test system and not used for production directly.

    Since you didn't provide any sample data nor expected results we don't...


    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 12, 2009 at 11:40 am

    #1052723

Viewing 15 posts - 4,966 through 4,980 (of 5,502 total)