jcelko212 32090 - Tuesday, February 21, 2017 3:10 PMkevin.obrien 66193 - Monday, February 20, 2017 9:07 AMHi,I have a table - TagDetail - that stores the many-to-many relationship between Tag, ParentTask, and ChildTask tables.
Basically any 'Tag' can relate to many ParentTask items and many/any ChildTask items. Not all ChildTask items of a ParentTask need to be related to a Tag.
I am looking for the best way to create a new 'Tag detail' using a stored proc.Do I need to pass a list of ParentTasks, and a list of ChildTasks? Or what is the best way - do I need to rethink the design here?
Sample data:
Design:
Thanks!
In the future, could you follow basic netiquette that is been in place for 30 years? This means you post DDL instead of screenshots pictures and vague narrative. Are you working at a company where they give you only screenshots and vague narrative from which to program? If so, it is time for you to quit .
If you will simply be polite, follow netiquette's been established for decades, and not demand people read your mind, then you can get hundreds or thousands of dollars worth of free consulting. But if you do not some of us, not mentioning myself, will put your name in a file called "something derogatory"so that if anyone is looking for a reference on you in the database community, we will not say nice things about you 🙁
Please post DDL and follow ANSI/ISO standards when asking for help.