Forum Replies Created

Viewing 15 posts - 3,001 through 3,015 (of 5,502 total)

  • RE: Help With Modifying this Code

    I'm not sure if the syntax is correct but IIRC this is the way to code the CASE statement in ACCESS

    ...

    Edit: Based on this link it seems like a homework...


    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]

    August 13, 2010 at 8:59 am

    #1206712

  • RE: Help With Modifying this Code

    What software is the solution for?

    You posted in the ACCESS forum so Lowells solution might not help if you're looking for ACCESS code. Please clarify.


    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]

    August 12, 2010 at 12:21 pm

    #1206265

  • RE: How do I get one row in a result set from 2 rows in parent table without using cursors.

    What is the table structure?

    Seems like you're using commas to separate columns in one example and at the same time as result delimiter within one column.

    To avoid confusion 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]

    August 12, 2010 at 4:21 am

    #1205896

  • RE: Plzz Help me in replacing the Cursor

    Duplicate post regarding the same subject.

    Discussion already started here.

    @anil-2: Why don't you try use the sample code already provided by Wayne and see if you can get it to 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]

    August 12, 2010 at 4:17 am

    #1205895

  • RE: How to break string and insert each substring

    Please search this site for "DelimitedString8K" to find a really fast T-SQL function or have a look at the TallyTable article referenced in my signature.

    There is an even fast CLR...


    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]

    August 12, 2010 at 4:04 am

    #1205888

  • RE: how to do this without a cursor?

    Four people answering your post all have different, but valid, questions.

    I strongly recommend you follow Waynes advice and read the article he pointed you at (which is the same article...


    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]

    August 11, 2010 at 4:31 pm

    #1205754

  • RE: sp_help on a view

    It seems like an "undocumented feature" (aka bug).

    I just tried what you described and got the very same effect. After re-running the ALTER VIEW statement without any modification of 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]

    August 11, 2010 at 4:21 pm

    #1205751

  • RE: Need Help with insert and update using sql server 2005

    Two basic concepts I use:

    1) if you want to insert just one row:

    IF EXISTS (SELECT 1 FROM targetTable t WHERE t.ID = @varId)

    UPDATE

    ELSE

    INSERT

    2) If...


    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]

    August 11, 2010 at 3:46 pm

    #1205747

  • RE: Are the posted questions getting worse?

    Steve,

    you asked for some improvement ideas for the SSC site: add the option to upload (and play) sound files :-D:-D

    Then we could actually hear the pronounciation of all 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]

    August 11, 2010 at 2:48 pm

    #1205722

  • RE: Binary Matrix table

    Something like the following?

    I'm using a subquery to get all valid numbers that will fit into your matrix (0 to 31) and use a binary test within a CASE statement.

    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]

    August 11, 2010 at 2:27 pm

    #1205714

  • RE: how to do this without a cursor?

    I second Wayne and will go one step further:

    Please describe what you define as "DaysBetween": calendar days, working days, business days or something totally different...

    If it's neither calendar (7 days...


    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]

    August 11, 2010 at 2:15 pm

    #1205708

  • RE: how generate series?

    I'm not sure how your final solution would look like...

    I'd use the following approach:

    DECLARE @tbl TABLE

    (

    start_ INT, end_ INT

    )

    INSERT INTO @tbl

    SELECT 1, 74 UNION...


    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]

    August 11, 2010 at 1:24 pm

    #1205688

  • RE: Help needed to generate an XML Structured output file

    Here's how I'd do it (looks a little messy though, maybe someone else will come up with a better solution..):

    SELECT

    CAST (

    (SELECT

    COUNT(*) AS CurrencyTotalCount,

    1 AS CurrencyRateInsertCount,

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

    August 11, 2010 at 12:40 pm

    #1205650

  • RE: problem reading a xml field: xmlns causing null result

    rscavilla (8/11/2010)

    Thank you Lutz, I did add the namespaces and it returned the correct values;

    ;with xmlnamespaces(default 'urn:hl7-org:v3')

    select Labelid,

    LabelXml.value('(/document/title)[1]', 'varchar(50)') AS 'Title',

    LabelXml.value('(/document/effectiveTime)[1]/@value', 'varchar(50)') as effectiveTime

    My issue now is unfamiliarity with 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]

    August 11, 2010 at 7:43 am

    #1205359

  • RE: Performance Tuning 40,000,000

    Please provide all table defs including all indexes on those tables as well as the actual execution plan for the query. You've been around long enough to know how 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]

    August 11, 2010 at 7:30 am

    #1205349

Viewing 15 posts - 3,001 through 3,015 (of 5,502 total)