Friday, January 25, 2019
saAction
DECLARE @OnlineRegTokenPerDay INT
SET @OnlineRegTokenPerDay=10
declare @dteStart date
declare @dteEnd date
declare @dtStart smalldatetime
declare @dtEnd smalldatetime
Select @dteStart = GETDATE()+2
Select @dteEnd = GETDATE()+20
CREATE TABLE #working_hours (FullDates SMALLDATETIME);
while @dteStart <= @dteEnd
BEGIN
print @dteStart
IF datename(WEEKDAY, @dteStart) <> 'Saturday'
AND DATENAME(WEEKDAY, @dteStart) <> 'Sunday'
AND @dteStart...
Subscribe to:
Posts
(
Atom
)
