Forum Replies Created

Viewing 15 posts - 2,371 through 2,385 (of 5,502 total)

  • RE: count no of months n days

    What logic do you want to apply to define a month?

    Would it be based on the number of full month between the two dates or based on a fixed number...


    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]

    December 21, 2010 at 3:43 pm

    #1265315

  • RE: Sql query Output in XML format

    Please post table def and (fake) sample data matching your expected result as described in the first link in my signature.

    Some of us (including me) would like to test our...


    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]

    December 21, 2010 at 2:49 pm

    #1265296

  • RE: Help needed with code

    It seems like there are three options to consider: a lookup table, a (more or less) simple string concatenation or a combination of both.

    If you write T-SQL code you should...


    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]

    December 21, 2010 at 2:43 pm

    #1265292

  • RE: if else error

    Mistake #1: you're obviously using Oracle 😀

    #2: assuming some logic implemented into the SQL systax Oracle is using, I'd get rid of all of the semicolons, since a semicolon should...


    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]

    December 21, 2010 at 2:25 pm

    #1265282

  • RE: Howto: Produce 1 XML dataset from several queries

    Unfortunately, we don't have any table def or sample data to play with.

    But based on the identical structure within each rec node I'd recommend to use a UNION statement 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]

    December 20, 2010 at 12:13 pm

    #1264744

  • RE: Searching a Stored Procedure definition (probable parse)

    Since you already have the objects used in a sproc you could query sys.sql_modules with PATINDEX() in a recursive CTE to find ho often it's referenced.

    I honestly doubt you'll be...


    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]

    December 19, 2010 at 3:33 pm

    #1264458

  • RE: Searching a Stored Procedure definition (probable parse)

    Instead of parsing the sproc, wouldn't one of the following object dependency functions be more efficient (introduced in SS2K8)?

    sys.dm_sql_referenced_entities

    sys.dm_sql_referencing_entities

    sys.sql_expression_dependencies


    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]

    December 19, 2010 at 2:46 pm

    #1264456

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (12/17/2010)

    Paul White NZ (12/17/2010)

    Gianluca Sartori (12/17/2010)

    Has anyone tried SQLComplete intellisense[/url]? I'm trying it and it doesn't look bad at all. Since I work on 2005 servers it comes...


    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]

    December 18, 2010 at 4:12 am

    #1264349

  • RE: Top N for each group in a counted series

    If you could provide a ready to use result set based on the query you have below, I think we can design the table on our side so you 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]

    December 18, 2010 at 4:06 am

    #1264348

  • RE: datepart week - 53 and 54 weeks?

    The reason is simple (more or less):

    A new week will start on Sunday as per the standard setting of SQL Server (U.S. English).

    Jan 1st 2028 is a Saturday. Jan 2nd...


    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]

    December 18, 2010 at 3:46 am

    #1264347

  • RE: Are the posted questions getting worse?

    Luke L (12/17/2010)

    Jack Corbett (12/17/2010)

    I've used VirtualPC, but its lack of 64 bit guest support is annoying. I know several others who use VritualBox and if I had 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]

    December 17, 2010 at 1:34 pm

    #1264232

  • RE: Get Monthly total in sp

    Please read the first article in my signature on how to ask a question in this forum.

    It'll show you how to post table def and sample data in a ready...


    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]

    December 17, 2010 at 10:51 am

    #1264174

  • RE: Can cursor avoided here?

    Why do you transfer all the data across the network twice? Just to set @inputcount = @@ROWCOUNT? It would be much more efficient to use a count(*) from OPENQUERY() 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]

    December 17, 2010 at 10:39 am

    #1264169

  • RE: Round to next 1000 or 100 without Ceiling function

    To summarize Tom's statement: "It depends!" 😀 (Tom, correct me, if I'm wrong)


    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]

    December 16, 2010 at 4:52 pm

    #1263797

  • RE: Looping though XML Subnode and pass the Identity value

    You run multiple queries against the same (namespaced) xml source.

    Therefore, you'd need to declare the names pace for each and every query against that xml source. Right now it's just...


    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]

    December 16, 2010 at 4:42 pm

    #1263792

Viewing 15 posts - 2,371 through 2,385 (of 5,502 total)