Forum Replies Created

Viewing 15 posts - 1 through 15 (of 160 total)

  • RE: I am hoping there is a simple way to accomplish this selection

    Evil Kraig F (1/22/2012)


    meichner (1/20/2012)


    I do have a question about your note. Am I correct that if I had a connection between the 'u' and 'm' that I would not...

  • RE: I am hoping there is a simple way to accomplish this selection

    Evil Kraig F (1/20/2012)


    meichner (1/20/2012)


    UserGroups

    Primary Key GroupCode

    Description VarChar(50)

    Users

    Primary Key UserID

    Foreign Key GroupCode

    UserName VarChar(50)

    Menu Items

    Primary Key MenuID

    Foreign Key GroupCode

    MenuName VarChar(50)

    I want to be able to display every possible combination of UserName...

  • RE: A design question

    sgtwilko (9/12/2011)


    Hi,

    I would agree with Evil Kraig F when he states that you don't want the contacts or addresses belonging to multiple customers. Also when he states that you...

  • RE: A design question

    CELKO (9/13/2011)


    >> According to my boss, the design that I created is too complicated, but I think its fine. I was wondering if I could get some direction so that...

  • RE: A design question

    Welsh Corgi (9/12/2011)


    @meichner,

    I meant that you were not going to get shot. :hehe:

    I feel for you for you are in a tough situation. Been there done that.

    Regards

    Can I take it...

  • RE: A design question

    Welsh Corgi (9/12/2011)


    @meichner,

    Don't you love it when a boss does not know anything about something but they insist in using the authoritative leadership style.

    Look at the bright side, at least...

  • RE: A design question

    LutzM (9/9/2011)


    I'd probably go with the approach your boss mentioned with the exception that i wouldn't allow any update but rather add "valid_from" and "valid_to" columns.

    I have never used valid...

  • RE: A design question

    First I would like to thank everyone for there help.

    I was surprised to find that after giving my design some thought, that my boss decided to go with a slightly...

  • RE: A design question

    Evil Kraig F (9/7/2011)

    I'm hoping those primary keys in contact/addresses are three separate columns, or I'd have to shoot you. 😉

    Can a contact belong to more then one customer?...

  • RE: Selecting Conditional Totals

    Ninja, thanks for the help. Worked like a charm.

  • RE: Selecting Conditional Totals

    Thanks for the help. I can't wait to try it when I get to the office.

  • RE: Selecting Conditional Totals

    I am still not in the office so I can't try out Ninja's solution. I do however have one question. I don't have a great deal of experience when...

  • RE: Selecting Conditional Totals

    Thank you for the suggestions. I got called out of the office for the next day or so. I will try the suggestions when I get back to the...

  • RE: A question about COALESCE and Nulls

    WayneS (8/31/2010)


    David Webb-200187 (8/31/2010)


    Shouldn't the coalesce be around the column, not the variable?

    For the way it's coded, it actually needs to be around BOTH.

    declare @Notes VarChar(Max)

    Select @Notes = COALESCE(@Notes +...

  • RE: A question about Set Ansi Nulls on and off

    ColdCoffee (7/30/2010)


    To add to it, the default setting of your PROD DB should have the Right Click on DB - Properties - Options - Miscellanous - ANSI NULL default -...

Viewing 15 posts - 1 through 15 (of 160 total)