SET NOCOUNT ON
--=======================================================================================
-- Recursive method shown by (Name with-held)
--=======================================================================================
  PRINT '========== Recursive method =========='
--===== Turn on some performance counters ===============================================
    SET STATISTICS IO ON
    SET STATISTICS TIME ON
DECLARE @BitBucket DATETIME --Holds display output so display times aren't measured.

--===== Execute the code being tested ===================================================
DECLARE @DateVal DATETIME
    SET @DateVal = '2008-01-01'

;with mycte as
     (
       select @DateVal AS DateVal
       union all
       select DateVal + 1
         from    mycte    
         where   DateVal + 1 < DATEADD(yy, 5, @DateVal)
     )
select @BitBucket = d.dateval
from mycte d
OPTION (MAXRECURSION 0)

--===== Turn off the performance counters and print a separator =========================
    SET STATISTICS TIME OFF
    SET STATISTICS IO OFF
  PRINT REPLICATE('=',90)
GO

--=======================================================================================
-- Tally table method by Jeff Moden
--=======================================================================================
  PRINT '========== Tally table method =========='
--===== Turn on some performance counters ===============================================
    SET STATISTICS IO ON
    SET STATISTICS TIME ON
DECLARE @BitBucket DATETIME --Holds display output so display times aren't measured.

--===== Execute the code being tested ===================================================
DECLARE @StartDate AS DATETIME
    SET @StartDate = '2008-01-01'

SELECT TOP (DATEDIFF(dd,@StartDate,DATEADD(yy,5,@StartDate)))
        @BitBucket = @StartDate-1+t.N 
   FROM Tally t
  ORDER BY N

--===== Turn off the performance counters and print a separator =========================
    SET STATISTICS TIME OFF
    SET STATISTICS IO OFF
  PRINT REPLICATE('=',90)

DECLARE @SQL NVARCHAR(MAX)

 SELECT @SQL = COALESCE(@SQL+CHAR(10),'') + 'DBCC CheckDB(' + QUOTENAME(Name) + ')'
   FROM Master.sys.Databases
  WHERE Database_ID > 4

  PRINT @SQL
   EXEC (@SQL)

SET NOCOUNT ON

declare @query varchar(100), @id int

declare BadCursor Cursor for
  select top 100000 ID from [tblLogTransactions]

open BadCursor
fetch next from BadCursor into @id
while @@fetch_status = 0
begin
 select @query = 'declare @i int; set @i = ' + convert(varchar,@id)
 exec(@query)
 fetch next from BadCursor into @id
end
close BadCursor
deallocate BadCursor
go

SET NOCOUNT ON
declare @query varchar(100), @id int
CREATE TABLE #muchWorseProblem (ID int primary key clustered)

INSERT INTO #muchWorseProblem (ID)
select top 100000 ID from [tblLogTransactions]

while (select count(*) from #muchWorseProblem) > 0
begin
  select top 1 @id = ID from #muchWorseProblem
  select @query = 'declare @i int; set @i = ' + convert(varchar,@id)
  exec(@query)
  delete from #muchWorseProblem where id = @id
end

SET NOCOUNT ON
declare @query varchar(100), @id int
DECLARE @muchWorseProblem TABLE (ID int primary key clustered)

INSERT INTO @muchWorseProblem (ID)
select top 100000 ID from [tblLogTransactions]

while (select count(*) from @muchWorseProblem) > 0
begin
  select top 1 @id = ID from @muchWorseProblem
  select @query = 'declare @i int; set @i = ' + convert(varchar,@id)
  exec(@query)
  delete from @muchWorseProblem where id = @id
end

declare @i int;
set @i = 0;

while 1=1
begin
  select top 1 @id2 = ID from @muchWorseProblem
  
  if @id2 is null
	break;

  select @query = 'declare @i int; set @i = ' + convert(varchar,@id2)
  exec(@query)
  delete from @muchWorseProblem where id = @id2
	set @id2 = null
end