Hi Kraig, thanks for your comment, I tried to said that, relationship 1 to many, sry my mistake, I need to improve my english.

back to topic, I decide to...

Hi Paul

Thanks for reply, this doubt is in general for "link tables",actually im work in this.

the relationship is (role)1..N to 0..1(groups)

I want to make role groups, as you ask.

Imagine this...

Thanks for reply Steve, is all that I wanted to know, have a nice day 🙂

Thanks for fast repply Steve,

Thank you for your suggestions on points (1 and 2), I will do as you said.

About point 3,...

Thanks for reply ChrisM@Work

I have the same structure in my city table, I refer to (state region) with entity cat (federative entity), my doubt here is, is correct to apply...

Can someone tell me an opinion about this design?, is bad to use composite key in that way, is better to use subrogate? and what is better way to perform...

Maybe not that you need, but this works

DECLARE

@id int,

@weight int,

@Field varchar(12),

@Result int

-- Test values

--SET @iD = 3

--SET @weight = 28

IF NOT EXISTS(SELECT id FROM [dbo].[weights]...

Yes, ChrisM@Work, next table is

CREATE TABLE [dbo].[b]city.cat[/b](

[b]Country_iD[/b] [smallint] NOT NULL,

[b]Entity_iD[/b] [smallint] NOT NULL,

[b]City_iD[/b] [smallint] NOT NULL,

[b]City[/b] [varchar](64) NOT NULL,

CONSTRAINT [PK_City_iD] PRIMARY KEY CLUSTERED (

[b]Country_iD[/b] ASC,

[b]Entity_iD[/b] ASC,

[b]City_iD[/b] ASC

)WITH (PAD_INDEX =...

Sorry, the correct code in Entity.cat is:

CONSTRAINT [PK_Entity_iD] PRIMARY KEY CLUSTERED (

[Country_iD] ASC,

[Entity_iD] ASC

)

Thanks for your help and help me to clear that idea, now I understand is not necesary...