Forum Replies Created

Viewing 15 posts - 421 through 435 (of 5,502 total)

  • RE: Inner Join with SubQuery

    here's a test scenario in a ready to use format, returning the expected(?) result.

    So, I don't see anything wrong with the code.

    declare @tbl table(vndnbr int, InvNbr int, InvAmt numeric(18,6),ChkNbr int)

    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]

    June 11, 2013 at 9:27 am

    #1623017

  • RE: First day of april in a given year

    But the most "elegant" way most probably still is the calendar table:

    SELECT TOP 1 dateValue

    FROM myCalendar

    WHERE dateName ='Monday'

    AND dateValue >= CAST(CAST(YEAR(@MyDate) AS CHAR(4)) +'0401' AS DATETIME)

    ORDER BY dateValue

    😉


    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]

    June 11, 2013 at 9:17 am

    #1623010

  • RE: First day of april in a given year

    I'm not sure If I really understood your question: but the first day of April in any given year is always April, 1st.

    What are you looking for? The Day of...


    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]

    June 11, 2013 at 8:10 am

    #1622953

  • RE: Query running slow

    Can you post the actual execution plan of the query together with the query itself?

    There are numerous reasons for a query "suddenly" taking longer than expected:

    Examples:

    dramatic growth of rows 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]

    March 29, 2013 at 3:09 am

    #1601945

  • RE: data update strategy

    You could use the OUTPUT clause and store old and new values in a review table using the INSERTED and DELETED internal tables.

    Ideally, this would be part of the 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]

    March 29, 2013 at 2:59 am

    #1601944

  • RE: Display SSIS log details in Drill- Down SSRS report

    duplicate post. No replies please.

    Please reply here: http://www.sqlservercentral.com/Forums/FindPost1436837.aspx.


    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 29, 2013 at 2:26 am

    #1601942

  • RE: column selection on dynamic basis

    Now that is a slightly different story...

    You asked a question in a SQL Server forum without even mentioning you're talking about MS Access. 🙁

    You might find someone around answering your...


    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]

    February 28, 2013 at 10:27 am

    #1592093

  • RE: Stored procedure runs faster than the code it contains...

    Do you use exactly the same code as used in the sproc?

    Or did you replace a few variables in the query with hardcoded values?

    It seems like the compiled version of...


    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]

    February 26, 2013 at 5:32 pm

    #1591352

  • RE: column selection on dynamic basis

    Based on Stevens easy to use sample data (STRONG hint for future questions... 😉 ) here's my approach. The main difference is the "depending column" having a static header ("FaultType",...


    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]

    February 26, 2013 at 6:33 am

    #1591167

  • RE: About making select queries in Microsoft Access

    Here are some hints:

    a) Don't start a project the night before it's due if the subject is something you're struggling with

    b) Please note that this is a SQL Server forum...


    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]

    February 25, 2013 at 3:18 pm

    #1590955

  • RE: column selection on dynamic basis

    Assuming the same WHERE clause is used, you could use the CASE statement in your SELECT statement.


    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]

    February 24, 2013 at 12:56 pm

    #1590674

  • RE: create and print html file using SQL Server Agent job

    I don't think there's anything unfortunate from my point of view, since you provided a solution even before I encoutered the problem! 😀

    So, thank you in advance!!!


    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]

    February 24, 2013 at 12:16 pm

    #1590669

  • RE: create and print html file using SQL Server Agent job

    After spending some more time searching for alternatives I found a software (http://www.coolutils.com/TotalHTMLConverterX) that doesn't need any GUI communication. Seems like it's the solution I've been looking for.


    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]

    February 24, 2013 at 11:00 am

    #1590661

  • RE: stuck on trying to do a large import

    You'll need to standardize the input source before even trying the BULK INSERT.

    SQL Server is a great tool but it cannot "guess" what the final result should look like from...


    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]

    February 24, 2013 at 3:13 am

    #1590639

  • RE: Query Help

    You might want to look into the CROSS APPLY syntax (use it to get the Top 2 vender_inv ORDER BY SaleID DESC) together with a cte or subquery 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]

    February 24, 2013 at 3:10 am

    #1590638

Viewing 15 posts - 421 through 435 (of 5,502 total)