خرید بک لینک

I want to insert value retued from this table into a table . Direct 'insert into' is not working . How Can i do this

;WITH N(N)AS 
(SELECT 1 FROM(VALUES(1),(1),(1),(1),(1),(1))M(N)),
tally(N)AS(SELECT ROW_NUMBER()OVER(ORDER BY N.N)FROM N,N a)
SELECT N day,datefromparts(@year,@month,N) date , DATENAME(dw,datefromparts(@year,@month,N)) dayname
FROM tally
WHERE N <= day(EOMONTH(datefromparts(@year,@month,1)))

 AND DATEPART(dw,datefromparts(@year,@month,N)) = 5        -- Thursday
 AND DATEPART(d,datefromparts(@year,@month,N)) BETWEEN  @dayFrom AND @dayTo 

برچسب: نویسنده: استخدام کار تاريخ: چهارشنبه 3 خرداد 1396 ساعت: 22:05

صفحه بندی