The above attached are the few columns snap shot for your reference
I have a table with 550+ columns (volume up, volume down, mute,channel up, channel down, 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10+, blue, white, yellow, red, green, brightness, brightness down, brightness up, disc, disc 1 , disc 2 , disc 3, play, play 1, pause, pause 1, play/pause, rewind, fast forward, skip down, skip up and so on..............)
The project aim is to capture the functions exits for a remote control (different brads and models across globe)in to sql database.
Each remote may have minimum 5 functions and maximum 150 functions.
In the front end tool i will select the the functions(from drop down list) available for that particular remote(AA0001) so that after i complete the task in from end the functions selected from drop down list becomes the input parameters.
Then the selected function will be marked as 1 and rest other(non selected functions in front end tool) marked as default 0.
Please let me know is there any way to pass only limited no of input parameters to stored procedure and non passed parameters are default 0.
Looking for ward for your help.