Forum Replies Created

Viewing 15 posts - 3,796 through 3,810 (of 5,502 total)

  • RE: Dynamically retrieve the data from XML

    You don't have to use dynamic SQL. However, if there are many nodes under col1Data you should compare the performance of the following solution to the dynamic SQL version... Thinking...


    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]

    April 14, 2010 at 12:09 pm

    #1151613

  • RE: Service Broker

    One of my preferred sites: http://rusanu.com/articles/


    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]

    April 14, 2010 at 11:45 am

    #1151597

  • RE: Need Highest MAX on 2 variables

    Sasidhar Pulivarthi (4/14/2010)

    Select Cust,MAX(OrderDate) Maxdate,MAX(SeqNo) MaxSQno

    from tblname group by Cust

    Actually, this won't give the expected result... The MAX() function is applied to each field separately. See the following...


    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]

    April 14, 2010 at 11:11 am

    #1151567

  • RE: not allow the user to copy the report

    Aspet Golestanian Namagerdi (4/13/2010)

    I have created some Reports which are being sent in PDF format,through email to client.How can I configure these reports,so the clients will not be able 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]

    April 14, 2010 at 10:58 am

    #1151555

  • RE: How to tune/speed up a procedure

    gregory.anderson (4/14/2010)

    Can you give me a quick example of a set-based solution (I'll google at the same time) to see how that would be done, and if it will work...


    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]

    April 14, 2010 at 10:44 am

    #1151542

  • RE: How to get ID of the Max Date based on year

    Identical solutions, posted at the very same time. Must be the best solution then... 😀

    Side note: '' = 44sec. That's the closest I've seen so far for posting identical solutions...


    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]

    April 14, 2010 at 10:12 am

    #1151512

  • RE: How to tune/speed up a procedure

    gregory.anderson (4/14/2010)

    ...I am processing this where I do a Select Top 1 blah Where (criteria here) and assign the values in my select statement to variables. ...

    Is it possible 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]

    April 14, 2010 at 9:59 am

    #1151494

  • RE: How to get ID of the Max Date based on year

    Something like this?

    DECLARE @tbl TABLE (ID INT, SurveyDate DATETIME, FY INT )

    INSERT INTO @tbl

    SELECT 100 ,'8/25/2009', 2009 UNION ALL

    SELECT 200 ,'8/26/2009', 2009 UNION ALL

    SELECT 300 ,'8/29/2009', 2009 UNION ALL

    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]

    April 14, 2010 at 9:51 am

    #1151480

  • RE: dateDiff question

    There are several ways to do it. One would be to join to a calendar table that would include a column where weekdays can be identified.

    An example of a calendar...


    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]

    April 14, 2010 at 9:45 am

    #1151474

  • RE: performance problem in production database

    Please be a little more specific what you mean by "database performance is slow". AFAIK, a database itself cannot be slow: if there is no activity at all (neither insert...


    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]

    April 13, 2010 at 4:20 pm

    #1151052

  • RE: Help with XML

    I'm not sure if that's exactly what you're looking for... But at least it should give you something to start with.

    The tricky part to get different node names is 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]

    April 13, 2010 at 12:41 pm

    #1150970

  • RE: Understanding and Using APPLY (Part 1)

    CirquedeSQLeil (4/12/2010)

    Paul White NZ (4/10/2010)

    I would like to express my sincere thanks to the following people, for their help in producing this article:

    Amanda Lawrence

    Jeff Moden MVP

    Chris Morris

    Lutz Müller

    Jason Brimhall[/url]

    Thank you...


    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]

    April 12, 2010 at 12:34 pm

    #1150250

  • RE: Data verification question

    SELECT cols

    FROM YourTable

    where YourColumn like '%[0-9]%'

    will return only rows with numbers.

    SELECT cols

    FROM YourTable

    where YourColumn like '%[^0-9]%'

    will return only rows at least one...


    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]

    April 12, 2010 at 11:59 am

    #1150231

  • RE: Group values based on two columns of data

    DerbyNeal (4/12/2010)

    Lutz - Thank you for your time and effort. (Unfortunately?) this posting was raised to pose several questions regarding change requirements focusing on 2 SQL tables, using T-SQL, so...


    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]

    April 12, 2010 at 10:38 am

    #1150177

  • RE: Help with XML

    Okay, we have the table def. But where are the INSERT statements?

    You posted the expected result the second time... 😉


    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]

    April 12, 2010 at 10:33 am

    #1150168

Viewing 15 posts - 3,796 through 3,810 (of 5,502 total)