What do you mean by a dynamic query? All queries that you pass values into are Dynamic by design since they can change as different users call the query.

In so far as 3NF that is not something you are going to read 1 article about and then be able to develop a database using that Normal Form. Normal Form takes time to understand (once you have worked with it for awhile its easy, but starting out it can be daunting)

And yes your query is extremely spaghetti-fied, i suggest taking a look at some of these links:

http://www.sommarskog.se/dyn-search.html
http://weblogs.sqlteam.com/jeffs/arc...1/02/2460.aspx
http://www.databasejournal.com/featu...le.php/3441981

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

Third normal form: The table must be in 2nd Normal form, and all columns in the table must be fully dependent on the primary key, and nothing but the primary key.

When a relation table is not in 3rd normal form and you want to bring it into 3NF then you typically move the fields to another table or set of tables that have foreign keys to the table that contains the primary key of the data the field is actaully dependent on. Make sense?

Remember CJ Dates little memory tool for the first 3 normal forms:
Each column must be dependent on the key, the whole key, and nothing but the key, so help me Codd.

(If you don't know who Codd is, look up E.F Codd!)



Woody Z
http://www.learntoprogramnow.com

IMHO, you cant convey, adequately, what 3NF is without stating what 1NF and 2NF require since each normalization relies on the previous form.

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

...no, I do not know who Codd is! What do you mean; "look it E.F Codd"? But do you know what codd is in norwegian? You probably does...

Mvh
grstad

Codd created the Relational model for database management.

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

That is true, but it is always in the rules.

Woody Z
http://www.learntoprogramnow.com

I meant Look UP. Sorry for the typo. However, E.F. Codd was a researcher at IBM in the 70's and 80's. When I started programming, there were no commercially available relational databases - and when I read his papers it made a very powerful influence on the way I think about data. Anyway, have a look at this link just for fun if you have the time to give you an interesting start on learning about the history of RDBMS:
http://www.itworld.com/nl/db_mgr/05072001/
or
http://en.wikipedia.org/wiki/Edgar_F._Codd

I know what Norwegian Cod is, but not Norwegian Codd. Is there a difference? I hope it is not X rated.

Woody Z
http://www.learntoprogramnow.com

To whom it might concern...

http://www.interaktonline.com/Suppor...=24&id_asc=215

grstad

Hei Woodyz!

...sorry about my Codd-talk. It was a stale joke. I will not go any further with it...

Thank you for the url's...

Mvh
grstad