Forum Replies Created

Viewing 15 posts - 4,021 through 4,035 (of 5,502 total)

  • RE: compare few columns in two rows....

    I frequently use three sources of knowledge (not limited to the stuff you mentioned):

    BooksOnline (the SQL Server help system usually installed toegether with SQL Server), this site and a test...


    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]

    March 9, 2010 at 3:49 pm

    #1131037

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (3/9/2010)

    Fantastic - now that we advertise for hair curlers, what will be next?

    Seems like a spam mail for an Expedia site using random text passage from "somewhere" as 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]

    March 9, 2010 at 1:57 pm

    #1130957

  • RE: Are the posted questions getting worse?

    Lynn Pettis (3/9/2010)

    I think it's time for trip to the desert. Anyone care to join me? I'll put the hippo on a leash. 😛

    May I join you? I'd...


    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]

    March 9, 2010 at 1:52 pm

    #1130953

  • RE: How do I show items dated 1 day from current date?

    simflex-897410 (3/9/2010)

    They said they are getting too many blank(null values) for the following fieldnames:

    ID number, Last and First Name, Defend Name, Hearing Type, Case Number, DA Number Event

    Of course...


    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]

    March 9, 2010 at 1:40 pm

    #1130943

  • RE: compare few columns in two rows....

    Well, then the following should work:

    (Side note: it still doesn't show P_ID 13 as ACTIVE though... 😉 )

    ;WITH cte AS

    (

    SELECT *, ROW_NUMBER() OVER(PARTITION BY P_id ORDER BY pri_key DESC)...


    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]

    March 9, 2010 at 1:31 pm

    #1130934

  • RE: compare few columns in two rows....

    Why do you consider OLD_PHONE = 6790 for P_ID =10 as being "old"?

    Shouldn't 6790 and 64687 be switched?


    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]

    March 9, 2010 at 1:19 pm

    #1130924

  • RE: Having total amount at every row level

    Looks like you're talking about the RunningTotal problem.

    The best resource I found so far is the following article by Jeff Moden:

    http://www.sqlservercentral.com/articles/T-SQL/68467/

    Please read it carefully especially in terms of the required...


    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]

    March 9, 2010 at 12:38 pm

    #1130894

  • RE: How do I show items dated 1 day from current date?

    lmu92 (3/9/2010)

    Lynn Pettis (3/9/2010)

    lmu92 (3/9/2010)

    So, please follow Lynns advice and change the join fom INNER to LEFT OUTER.

    I think you want a RIGHT OUTER JOIN the way the query 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]

    March 9, 2010 at 11:08 am

    #1130830

  • RE: How do I show items dated 1 day from current date?

    Lynn Pettis (3/9/2010)

    lmu92 (3/9/2010)

    So, please follow Lynns advice and change the join fom INNER to LEFT OUTER.

    I think you want a RIGHT OUTER JOIN the way the query is currently...


    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]

    March 9, 2010 at 10:45 am

    #1130817

  • RE: How do I show items dated 1 day from current date?

    So, please follow Lynns advice and change the join fom INNER to LEFT OUTER.


    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]

    March 9, 2010 at 10:24 am

    #1130806

  • RE: How do I show items dated 1 day from current date?

    Next step:

    Include one more table in your select:

    SELECT DEP.*

    FROM dbo.vwGJ1_APD GJ1_APD

    INNER JOIN dbo.DefendantEventPros DEP ON GJ1_APD.DANumber = DEP.VBKey

    WHERE (DEP.functionDate >= CONVERT(varchar(8), GETDATE(), 112)) AND (DEP.UserDelete = 0) AND...


    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]

    March 9, 2010 at 10:09 am

    #1130788

  • RE: Getting huge amount of data with XML as input parameter

    RBarryYoung (3/8/2010)

    Since you're on SQL 2008, pass the IDs in as a TVP (table-valued parameter) and receive the results back as a datatable. SQL CAT's test have generally shown...


    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]

    March 9, 2010 at 10:07 am

    #1130786

  • RE: auto increment on a datawarehouse table help

    I'm still not sure what the correct order of the subnumbers will be, but anyway, I'd use ROW_NUMBER:

    DECLARE @tbl TABLE

    (

    bookingkey int null,bookingno int, itemno int, itemtype varchar(20)

    )

    insert into @tbl(bookingno,itemno,itemtype)

    SELECT 1,...


    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]

    March 9, 2010 at 10:04 am

    #1130780

  • RE: How do I show items dated 1 day from current date?

    So it looks like your data don't include any rows for (DEP.UserDelete = 0) AND (DEP.EventID = 654) that are between today and March 16th.

    Try

    SELECT * FROM DefendantEventPros

    WHERE...


    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]

    March 9, 2010 at 9:55 am

    #1130765

  • RE: Convert XML to table without using sp_xml_preparedocument

    moonbrig (3/8/2010)

    Hi friends,

    I'm newbie in this forum. Anyone can give me any suggestion of open source tools to convert database from .sql to .CSV? I also try to find how...


    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]

    March 9, 2010 at 8:00 am

    #1130677

Viewing 15 posts - 4,021 through 4,035 (of 5,502 total)