Run Code  | API  | Code Wall  | Users  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

While Loop in SQL Server for Multiple Entries

Language: Layout:
View schema
Execution time: 0,02 sec, rows selected: 27, rows affected: 11, absolute service time: 0,17 sec, absolute service time: 0,18 sec 
fork mode |  history  | discussion
   Keyid Keyname value1 KeyListId
1 5000 Environment Prototype 1000
2 5000 Environment Development 1001
3 5000 Environment QA 1002
4 5000 Environment UAT 1003
5 5000 Environment Production 1004
   ProjectID ProjectName
1 1000 ELM
   JenkinID ProjectName EnvironmentID
1 1000 ELM_Prot 1000
2 1001 ELM_Deve 1001
3 1002 ELM_QA 1002
4 1003 ELM_UAT 1003
5 1004 ELM_Prod 1004