선택 한 월의 주를 datepart를 사용해서 구할려고 합니다.

다음과 같이 구할 수는 있는데.. 프로그램에 적용시킬려면 넘 조잡해보입니다..ㅡㅡ;;

좋은 script 없나요?

select distinct datepart(wk, a) as bb
from (
select '20050601' as a
union select '20050602' as a
union select '20050603' as a
union select '20050604' as a
union select '20050605' as a
union select '20050606' as a
union select '20050607' as a
union select '20050608' as a
union select '20050609' as a
union select '20050610' as a
union select '20050611' as a
union select '20050612' as a
union select '20050613' as a
union select '20050614' as a
union select '20050615' as a
union select '20050616' as a
union select '20050617' as a
union select '20050618' as a
union select '20050619' as a
union select '20050620' as a
union select '20050621' as a
union select '20050622' as a
union select '20050623' as a
union select '20050624' as a
union select '20050625' as a
union select '20050626' as a
union select '20050627' as a
union select '20050628' as a
union select '20050629' as a
union select '20050630' as a
) aa
order by datepart(wk, a)

실행해보면 값은 이렇게 나옴니다.

bb
23
24
25
26
27