1.測試:一般就是 玩 系統, 但其實是有方法論的, 請參考http://www.books.com.tw/exep/prod/booksfile.php?it...
我會使用CTE遞迴+Outer JOIN完成他 ;WITH CTE AS ( SELECT DATEADD(wk, DATEDIFF(wk,0,MIN(Wo...
1.拿這篇裡的(?\D+?[縣市])(?\D+?(市區|鎮區|鎮市|[鄉鎮市區]))?(?\D+?[村里])?(?\d+[鄰])?(?\D+?(村路|[路街道段...