Idea to create table fr the below scenario

Transact-SQL
1

remote data.JPG1089×155 33.4 KB

i had a requirement.

please do needful.

There are around 700 Universal Functions list is uploaded for your reference in UNV_Fun table,
all the functions are unique.

There is another table UID in which Unique remote Remote_ID I.e AA0001 last up 100000 with a change is sequence AA0001 to AA9999,AB0001 to AB9999,AC,AD

Requirement is For each Remote_UID(AA0001) there will be around out of 700 functions only 40 to 50 Universal function bit is '1' and rest of the universal functions set to '0'(By default).

My motto is to tell which UIDs is having data for which universal functions.

please tel me how to proceed in-order to develop these kind of scenario.

2

Do you mean you have a table with 700 columns -- one for each Universal Function?

3

no.... if to see second picture.....
for each UID(AA0001,AA0002.......AA9999) there are 700 columns with data default '0' or if it have function then '1'

4

Why did you say "no"? The answer is "yes". There are 700 columns!

5

Hi britton,

Yes each uid has 700+ columns(
Univ Fucntions like ( digit……………1,
digit……………2,
Power……………power toggle,
Power……………power On,
Power……………power Off,
Display……………brightness down,
Display……………brightness up
And so on)

Please let me know how to design a table with above requirement.