Forum Replies Created

Viewing 15 posts - 4,396 through 4,410 (of 5,502 total)

  • RE: Get date/time for each record inserted in a table

    The only place I can think of would be the transaction log file.

    Other than that: AFAIK there is no hidden date recorded.


    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]

    January 28, 2010 at 10:03 am

    #1110179

  • RE: How to create X records where x comes from a column in another table.

    Gagne (1/28/2010)

    Lutz thanks for the reply. I've learned about Tally tables here in the forum and I already have a few but the "Cross Apply" is new to me....


    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]

    January 28, 2010 at 9:31 am

    #1110157

  • RE: SQL Mail does not work with the 64-bit version of SQL Server

    @Lynn: you might want to prepare your tent to hold a bunch of people arriving shortly... 😉

    Can we just stop by or do we need to show an invitation?


    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]

    January 28, 2010 at 9:25 am

    #1110150

  • RE: How to create X records where x comes from a column in another table.

    You'd need a CROSS APPLY against a table holding some numbers (aka Tally table - please see the related link in my signature).

    Based on a tally table the code would...


    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]

    January 28, 2010 at 9:22 am

    #1110143

  • RE: SQL Mail does not work with the 64-bit version of SQL Server

    Krasavita (1/28/2010)

    RESPECT PEOPLE

    You've crossed the line of professionalism twice already in this thread.

    I strongly recommend to step back from the keyboard for a moment, take a deep breath and think...


    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]

    January 28, 2010 at 9:13 am

    #1110136

  • RE: (No column name) in Select statement

    sol.nt (1/28/2010)

    I get from some sps which i can not sure what i will have, because they were written by many people.

    sol

    I don't understand the business case / concept....

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

    January 28, 2010 at 8:45 am

    #1110111

  • RE: Deciding on Using CLR Code/Assemblies or plain T-SQL to implement logic/rules in SSIS package

    Maybe you can replace some views with CTEs / subqueries instead of having a view for each calculation.

    For unit testing you could use the OUTPUT clause and store the results...


    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]

    January 28, 2010 at 7:27 am

    #1110001

  • RE: create view - one to many table

    ColdPolarBear (1/27/2010)

    Thanks for response - However, I am looking for a dynamic solution. Your suggestion creates a new table based only the data that I provided as sample data. I...


    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]

    January 27, 2010 at 4:55 pm

    #1109666

  • RE: create view - one to many table

    It's more an issue of CrossTabs or even DynamicCrossTabs.

    I gues it can be done in CrystalReports, but I'm not sure (never worked with it...).

    You might want to have a look...


    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]

    January 27, 2010 at 2:54 pm

    #1109608

  • RE: Please solve this sql query

    The result you get is exactly what you've been asking SQL Server to do:

    select -- print the output

    8 -- output is supposed to be the number "8". If you'd like...


    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]

    January 27, 2010 at 1:55 pm

    #1109583

  • RE: Query not covering ALL possibilities -- Need help fixing issues regarding a few out liers

    Glad it worked. 😀

    Btw: Did you notice how I "translated" your "descriptive sample data" into ready to use SQL code?

    If you provide data in such a format you'll increase 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]

    January 27, 2010 at 12:54 pm

    #1109535

  • RE: Msg 8134, Level 16, State 1, Line 1,Divide by zero error encountered.,Warning: Null value is eliminated by an aggregate or other SET operation.

    Lynn Pettis (1/27/2010)

    lmu92 (1/27/2010)

    Seems like I totally missed the point. Sorry about that... :blush:

    Okay, I'm lost on how you are lost. Please, what did you miss? It was...


    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]

    January 27, 2010 at 12:46 pm

    #1109528

  • RE: Msg 8134, Level 16, State 1, Line 1,Divide by zero error encountered.,Warning: Null value is eliminated by an aggregate or other SET operation.

    Seems like I totally missed the point. Sorry about that... :blush:


    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]

    January 27, 2010 at 12:03 pm

    #1109499

  • RE: Msg 8134, Level 16, State 1, Line 1,Divide by zero error encountered.,Warning: Null value is eliminated by an aggregate or other SET operation.

    Maybe it's the wrong function you're using:

    AVG(NULLIF(F.WinningBid,0)/NULLIF(F.AuctionSellerReserve, 0))

    Straight from BOL (BooksOnLine):

    NULLIF returns the first expression if the two expressions are not equivalent. If the expressions are equivalent, NULLIF returns 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]

    January 27, 2010 at 11:15 am

    #1109463

  • RE: Query not covering ALL possibilities -- Need help fixing issues regarding a few out liers

    You need to link the CTE back to your original table. Since I don't have any other field unique field I used the addr field. I expect you have an...


    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]

    January 27, 2010 at 10:53 am

    #1109439

Viewing 15 posts - 4,396 through 4,410 (of 5,502 total)