Viewing 15 posts - 1 through 15 (of 160 total)
Evil Kraig F (1/22/2012)
meichner (1/20/2012)
January 23, 2012 at 9:45 am
Evil Kraig F (1/20/2012)
meichner (1/20/2012)
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...
January 20, 2012 at 6:58 pm
sgtwilko (9/12/2011)
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...
September 13, 2011 at 1:39 pm
CELKO (9/13/2011)
September 13, 2011 at 1:23 pm
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...
September 12, 2011 at 11:19 am
Welsh Corgi (9/12/2011)
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...
September 12, 2011 at 9:33 am
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...
September 11, 2011 at 9:48 am
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...
September 9, 2011 at 9:18 am
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?...
September 8, 2011 at 9:37 am
Ninja, thanks for the help. Worked like a charm.
July 25, 2011 at 11:29 am
Thanks for the help. I can't wait to try it when I get to the office.
July 22, 2011 at 8:38 am
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...
July 22, 2011 at 7:35 am
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...
July 20, 2011 at 3:44 pm
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 +...
August 31, 2010 at 1:05 pm
ColdCoffee (7/30/2010)
July 30, 2010 at 7:11 am
Viewing 15 posts - 1 through 15 (of 160 total)