Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
grandhi
Starting Member
31 Posts |
 Posted - 2013-05-06 : 04:41:01
|
| Hi All, I don't know, whether it is correct a correct question or not?In my App,I have 2 PopupMenus names are ProductBrand,both are Associated to each other means.At the initial time,First popupmenu (Product) have the list {A,B,C,D} and Second PopupMenu have {1,2,3,4}.If you select A from First popupmenu,then if you can observe second popupmenu list ,it will have associated values like {1,2,3}.like If you select any value from any popupmenu,That corresponding associated values will be available in another Popupmenu.Popupmenu logica wise,everyThing was fine,But the problem was How can create Tables for this Associations.I hope,you understand what my problem.Can anyone help me?Thank You. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
grandhi
Starting Member
31 Posts |
Posted - 2013-05-06 : 05:35:42
|
| @visakh16,How can I set storedprocrdures in my DB.I am using MSSQL server 2012.can you tell me one thing,Is it possible to insert two values in single column. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-05-06 : 06:17:19
|
| you need to write stored procedures code using CREATE PROC...statement and execute the code in your db to create itIts possible to insert two values. use INSERT...SELECT syntax or use table value constructor asINSERT table (column) VALUES(value1),(value2)------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
grandhi
Starting Member
31 Posts |
Posted - 2013-05-07 : 01:09:47
|
| Thank you Visakh16... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-05-07 : 01:10:44
|
| you're welcome------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
|
|
How can I create tables depending on requirments?