SQL Server 2008
-
Hi Guys, I want to know the table creation for the problem described below. I have a 26 parameters for a customer feed back, and i have a set of sites , some sites don't have some parameters in my 26 points, and some site want more then 26 points, so i thought to create table like id(int),parametename(Nvarchar(max)),site1(bit),site2(bit),site3(bit),site4(bit) and i will allow in UI to check which point is applicable for which site, this solution is for time being, my concern is id the site name may add in future that time we have to change the parameter table and modify the insert and update methods as well as Store procedure, How can avoid the re-coding by creating customized table. Please suggest me the solution. Thanks and regards Vishwa
-
Hi Guys, I want to know the table creation for the problem described below. I have a 26 parameters for a customer feed back, and i have a set of sites , some sites don't have some parameters in my 26 points, and some site want more then 26 points, so i thought to create table like id(int),parametename(Nvarchar(max)),site1(bit),site2(bit),site3(bit),site4(bit) and i will allow in UI to check which point is applicable for which site, this solution is for time being, my concern is id the site name may add in future that time we have to change the parameter table and modify the insert and update methods as well as Store procedure, How can avoid the re-coding by creating customized table. Please suggest me the solution. Thanks and regards Vishwa
You should have a table that stores the list of sites identified by a SiteID column. And then you can store the values in your table with these columns id(int),parametename(Nvarchar(max)),SiteID(int),value(bit) Whenever there is a new site is to be added, just add it to the site table and insert a new row with that id in this table.
-
Hi Guys, I want to know the table creation for the problem described below. I have a 26 parameters for a customer feed back, and i have a set of sites , some sites don't have some parameters in my 26 points, and some site want more then 26 points, so i thought to create table like id(int),parametename(Nvarchar(max)),site1(bit),site2(bit),site3(bit),site4(bit) and i will allow in UI to check which point is applicable for which site, this solution is for time being, my concern is id the site name may add in future that time we have to change the parameter table and modify the insert and update methods as well as Store procedure, How can avoid the re-coding by creating customized table. Please suggest me the solution. Thanks and regards Vishwa