너는 진정 전자인을 아는가?

with r AS 
( select cast('2020-01-01' as date) lv
union all
select dateadd(dd, 1, lv) from r where dateadd(dd, 1, lv) <= cast('2020-01-31' as date)
) select * from r
;

1~31일까지 출력이 됩니다.

 select ts.lv  from 
(select convert(char(10),dateadd(d,number,'2020-01-01'),120) lv
from master..spt_values 
where type = 'P' and number <= datediff(d,'2020-01-01','2020-01-31')
) ts

상위와 동일

http://www.drpro.kr/

https://blog.naver.com/liokingim/221680822316

https://www.youtube.com/watch?v=M7j3J1sTDFc

https://www.youtube.com/watch?v=h5Rzt3neoZQ

https://www.youtube.com/watch?v=vZofi2hgiAE

https://www.youtube.com/watch?v=kxZoou0KevE

https://www.youtube.com/watch?v=mgiH0_h8p-U

https://www.youtube.com/watch?v=-E-_IRJU5w0

$(document).ready(function(){
  
  $("input[name*='sUserResult']").click(function(){
   var st = $(this).val();
    alert(st); //<--선택한값체크
    
    var ttt= $("input[name*='sUserResult']:radio:checked");
  
    alert(ttt.length); //nationality의 checked갯수 체크
    
    if(ttt.length != 2){
     alert("누락된 설문이 존재합니다.");
    }
  });
  
  
  });


input name="sUserResult[1]" type="radio" value="1">1
input name="sUserResult[1]" type="radio" value="2">2
input name="sUserResult[1]" type="radio" value="3">3
input name="sUserResult[1]" type="radio" value="4">4





input name="sUserResult[2]" type="radio" value="1">1
input name="sUserResult[2]" type="radio" value="2">2
input name="sUserResult[2]" type="radio" value="3">3
input name="sUserResult[2]" type="radio" value="4">4