No, I have not chosen anything at all.

That's why I posted the tables I have so far so you can help me redesign them the way you think will help...

Ok, thanks

So, then this would be good enough:

CREATE TABLE [dbo].[Judges](

[JudgeCode] [nvarchar](50) NOT NULL,

[JudgeName] [nvarchar](50)...

Ok, if I may, can I please start with the table designs?

If you guys feel that the tables are ok, then I will begin to show the codes for each...

BT, Scott, it is very clear to me how great you are guys are with SQL.

I really appreciate it.

The one thing I still will like addressed, unless I am missing...

Thanks again all,

At this point, with guns pointing on my head to get this done, it really doesn't matter whether it is one or more tables.

BT, please take no offense...

hi BT,

when you get a moment, can you please explain your logic, along with the db design a bit more?

I just want to be sure it is doing what the...

Greetings again.

I love the ideas very much.

However, there is one thing that is still missing.

Did I neglect to mention this earlier, man!

Ok, there is something called Transfer Case.

Yes, I did...

P.S. I don't think there's a limit on how many posts you can have, so I wouldn't worry about it. We're just here to help if we can

Mike, thanks alot...

Thank you very, very much.

That worked like a dream.

Again, thanks a lot.

Goldie, that works a treat.

Thank you very much.

To all, I am very, very sorry, I fibbed.

I said i would give it all I got before coming back to but unfortunately,...

no, I am doing this with Sql Server Reporting Services; nothing to do with .net.

So, I build the sql using query analyzer. When I get the results I am after,...

Thanks a lot again, Goldie.

I am still struggling with the dynamic date. I will continue to try to figure it out.

It isn't making sense to me. I am more of...

Thank you Lutz.

You are absolute ANGELS.

Since I discovered this great forum, I have not been disappointed.

I will do the best I can to show that I am interested in learning.

Thanks(AGAIN)...

I want to sincerely and wholeheartedly thank you ALL for your kindness.

I really appreciate it.

I ran all 3 scripts and they appear to work real good.

I know that Goldie's is...

Excuse me?