Last post Jul 09, 2019 02:20 AM by Yang Shen
Jul 07, 2019 07:50 PM|mazhar khan india|LINK
Below is my alert master table where form fields of View_Candidateinfo will match
Sno ColumnName Value
1 TeachersAvailable Sometimes
2 CameraAvailable No
3 WaterFacility No
Below is my View to match the how many alerts are avaible and insert into Table_Output
CandidateId FullName Mobile TeachersAvailable CameraAvailable WaterFacility
1 Mazhar 7207542655 Yes No No
I want output like below to inset record into new table(Table_Output)
CandidateId ColumnName Value
1 CameraAvailable No
1 WaterFacility No
Jul 09, 2019 02:20 AM|Yang Shen|LINK
Hi mazhar khan india,
In SQL, a view is a virtual table based on the result-set of an SQL statement.
The fields in a view are fields from one or more real tables in the database.
However, from the View_Candidateinfo you provide, it is difficult to guess where the first three columns came from and how the last three columns were assigned.
Are there any other tables that you did not provide?
If you can provide more detailed information about how you set your View_Candidateinfo, it may help us solve your problems as soon as possible.