DROP TABLE IF EXISTS #tmpBusicasapodnyam1
DECLARE @nowDate datetime = getdate() 
DECLARE @DateRange datetime
DECLARE @startdat datetime = '2021-12-10 00:00:00.000'
DECLARE @i INT = 0
DECLARE @kolDays INT
DECLARE @def VARCHAR(20)
DECLARE @sql_str VARCHAR(MAX)
SET @kolDays = datediff(DAY,@startdat,@nowDate) 
DECLARE @tablDateRange TABLE(DateRange datetime)
while @i < @kolDays
BEGIN    
    INSERT INTO @tablDateRange (DateRange)
    SELECT dateadd(DAY,@i,@startdat)
    SET @i = @i + 1
END;
 
 
CREATE TABLE #tmpBusicasapodnyam1 
    (market_name VARCHAR(255), market_id DOUBLE PRECISION, dep_special DOUBLE PRECISION, bonus_used_brt DOUBLE PRECISION)
    ALTER TABLE #tmpBusicasapodnyam1 ADD datecurra VARCHAR(MAX);
 
DECLARE idx_cursor CURSOR LOCAL FOR SELECT DateRange FROM @tablDateRange;
OPEN idx_cursor;
FETCH NEXT FROM idx_cursor
INTO @DateRange;
WHILE @@fetch_status = 0
BEGIN
    DECLARE @dateEnd datetime = dateadd(HOUR, 23,@DateRange)    
    SET @sql_str = 'alter table #tmpBusicasapodnyam1 add constraint df_datecurra default '  + CAST(@DateRange AS VARCHAR(MAX)) + '  for datecurra'
    EXEC(@sql_str)
    INSERT INTO #tmpBusicasapodnyam1 (market_name , market_id , dep_special , bonus_used_brt)
    EXEC get_otchet @pstart_date = @DateRange, @pend_date = @dateEnd
    SET @sql_str = 'ALTER TABLE #tmpBusicasapodnyam1 DROP CONSTRAINT df_datecurra'
    EXEC(@sql_str)
    
    FETCH NEXT FROM idx_cursor
    INTO @DateRange;
END;
CLOSE idx_cursor;
DEALLOCATE idx_cursor;
SELECT *
FROM #tmpBusicasapodnyam1