Forum Replies Created

Viewing 15 posts - 5,461 through 5,475 (of 5,502 total)

  • RE: Foren Key Confilct

    Like I said, both of them are a kind of "dirty"...

    If the data volume you need to handle allows the first option then you probably should stay with that solution,...


    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 24, 2009 at 11:14 am

    #965432

  • RE: Foren Key Confilct

    your procedure is basically correct and supports the existing table structure. But the table structure ist the problem. 😀

    If you cannot alter the table structure you have several ways 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]

    March 24, 2009 at 10:39 am

    #965389

  • RE: Insert Trigger Help

    It seems like there no issue on the SQL Server Side.

    I haven't used ACCES in a while, but did you try requery your data and refresh the form after that?


    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 24, 2009 at 1:21 am

    #964991

  • RE: Foren Key Confilct

    Hi,

    it looks like you're having a self-referencing foreign key (foreign key [EDucationCodedomainIdno] references the prim key [educationcodeidno] of the same table).

    Obviously, there has been a delete statement that affected 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 23, 2009 at 6:06 pm

    #964911

  • RE: Which country is best for Outsourcing?

    I'm just wondering:

    is your question related to the country to outsource from or to outsource to? :hehe:

    Aside of that, you're normally not outsorcing to a country but to a company....


    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 23, 2009 at 4:26 pm

    #964858

  • RE: How to Join XML dataset and SQL Dataset in SSSRS

    Hi,

    after doing some extended (google) research it looks like there is no way of directly joining two SSRS datasets together.

    Out there in the wide wide web two options are discussed...


    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 23, 2009 at 3:56 pm

    #964849

  • RE: Integrity check getting an error

    Please don't double post!

    For those who are going to look deeper into this issue, answers already started at thread http://www.sqlservercentral.com/Forums/FindPost681150.aspx

    Edit: link added


    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 22, 2009 at 4:36 pm

    #964188

  • RE: is possible thro a single query

    Would you be a little more specific on how do determine, which Items should be used to sum for the 80%?

    Example: Your requirement of "making 80% of the total Class...


    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 22, 2009 at 9:44 am

    #964133

  • RE: Danger Trigger Problem

    a few more thoughts on your concept / code snippets:

    Declare @bid int

    select @bid = BrandID from Inserted

    Update BrandsMachine

    set BrandID = @bid

    where BrandID is null

    You shouldn't store the result...


    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 22, 2009 at 9:02 am

    #964130

  • RE: How to Join XML dataset and SQL Dataset in SSSRS

    Are both data sets stored in a SQL Server (e.g. SS2K5)?

    If so, the easiest way would be to create a view on server side and go from there.

    If not, 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 21, 2009 at 5:35 pm

    #964038

  • RE: serial no

    I don't think it's the compatibility level...

    Looks more like a typo: ROWNUMBER vs. ROW_NUMBER()

    Underscores sometimes matter 😛

    The RowNumber function is for Reporting Services.


    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 21, 2009 at 6:56 am

    #963959

  • RE: Performance Issue with XML datatype

    Sorry, my original stated post was incorrect, so I had to edit (= delete) it....


    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 20, 2009 at 1:12 pm

    #963741

  • RE: Out Of Sequence OrderID Generated after Blocking

    Would it be possible to change the calling procedure to handle the double call by two parameter sets?

    Like

    CREATE PROCEDURE [dbo].[Add_Order] (

    @4FileID int null,

    @4OrdererID int null,

    @8FileID int null,

    @8OrdererID int null

    )

    and handle...


    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 19, 2009 at 1:41 am

    #962513

  • RE: OPENXML meta-properties to store hierarchial data

    Yet another thought:

    You could also use the max(Order_ID) instead of my +10 offset to generate new primary keys with ROW_NUMBER().

    Therewith you could avoid the addtl. column. But instead of adding...


    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 19, 2009 at 1:14 am

    #962509

  • RE: OPENXML meta-properties to store hierarchial data

    Hi,

    as promised i looked a little deeper into the subject this evening and I think I found a way to deal with it without additional (permanent) tables.

    The biggest disadvantage 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]

    March 18, 2009 at 4:56 pm

    #962344

Viewing 15 posts - 5,461 through 5,475 (of 5,502 total)