Forum Replies Created

Viewing 15 posts - 1,051 through 1,065 (of 5,502 total)

  • RE: Help with SQL Query

    The following approach might cover for some missing Home Addrees values, too (that would be eliminated by the LEFT OUTER JOIN approach).

    But the CrossTab method posted by R.P.Rozema is definitely...


    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 30, 2011 at 2:45 pm

    #1375246

  • RE: Help with SQL Query

    You could also have a look at the CrossTab article referenced in my signature.


    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 30, 2011 at 2:25 pm

    #1375234

  • RE: Sql Server Broker Starting Conversation but not Passing to remote server

    Maybe Rusanus Blog[/url] can help you to narrow down the issue.

    You'll need to figure out "how far" the message is transferred and work from there.


    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 30, 2011 at 2:22 pm

    #1375231

  • RE: Confusion about schema

    Let's see if I can help to clarify a few things:

    I thought a user always had a schema?

    Yes and no. A user always has a DEFAULT schema.

    As per BOL:

    WITH...


    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 30, 2011 at 2:03 pm

    #1375226

  • RE: My Tempdb is Full

    What is the exact error message you get?

    Is the db set to a max size or is can it grow unlimited but the drive full?


    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 30, 2011 at 10:10 am

    #1375109

  • RE: Difference b/n SQL 2005 64 bit and 32 bit ??

    Lavanyasri (8/30/2011)

    HI ,

    sorry . I got solution please close the ticket.

    There's no reason to be sorry.

    Instead you should post the solution you found so others migt benefit.


    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 30, 2011 at 9:57 am

    #1375101

  • RE: Help in joining two fields

    Did you try to iterate through the example I posted?

    You might find that the concept you described won't lead to a valid solution since we would need a value 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]

    August 29, 2011 at 11:52 am

    #1374625

  • RE: Help in joining two fields

    pandeesh (8/29/2011)

    As a rule, we can have first matching combination to be selected:

    for Mr.Lutz example,we can put A1 for first occuring combination(30,30,20,20).

    Please let me know if you need any more...


    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 29, 2011 at 10:52 am

    #1374584

  • RE: Help in joining two fields

    Nope, no (easy) way to solve it from my point of view.

    How would you sort the following:

    A1,1,100

    A2,1,200

    1,60

    1,30

    1,30

    1,20

    1,55

    1,20

    1,15

    1,30

    1,25

    1,5

    1,20

    There are multiple possible solution and it would require a minimum of three steps...


    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 29, 2011 at 10:30 am

    #1374566

  • RE: Return one row from multiple rows based on order of tests in where clause

    Yes.

    But you don't have to have the statement in the SELECT list. All that's required is it has to be a valid statement that can be used in the 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 27, 2011 at 1:16 am

    #1374198

  • RE: Migration of the same data in several directions

    How will you decide if a product is already in the target database? Obviously, you can't use the ProductId so you have to use the "natural key". And what 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]

    August 26, 2011 at 2:03 pm

    #1374095

  • RE: Are the posted questions getting worse?

    Grant Fritchey (8/26/2011)

    Need the advice of the Thread.

    Putting together an article on the most common backup errors (apart from not having one) and how to avoid them. I have four...


    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 26, 2011 at 11:52 am

    #1374017

  • RE: Return one row from multiple rows based on order of tests in where clause

    tshad (8/26/2011)

    That was what I was looking for.

    I added in the Order by without the Top just to see how it would order and it worked great.

    3Main2MainClass

    2MainNULLMainClass

    1MainNULLNULL

    Not sure what this...


    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 26, 2011 at 11:26 am

    #1373996

  • RE: Can't save a table

    The interesting part is:

    You can always add a column at the end, but not in between (which makes sense, since the forme is a simple alter table add column).

    It seems...


    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 26, 2011 at 7:55 am

    #1373771

  • RE: Data from two databases

    One more issue:

    If you know for sure there won't be any duplicate values you could use UNION ALL instead of UNION. Otherwise SQL Server would have to perform an aggregation...


    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 26, 2011 at 4:55 am

    #1373654

Viewing 15 posts - 1,051 through 1,065 (of 5,502 total)