SQLUSA

Microsoft SQL Server 2005 Best Practices

How to architect math drill sproc for addition?

 

Execute the following script in Query Editor to create and apply an addition drills stored procedure:


USE AdventureWorks
GO
CREATE PROC MathTrainerAddition ( @DrillNumber int , @Level int, @Result bit)
AS
BEGIN
DECLARE @Counter smallint
DECLARE @Drill table (Sequence int, [Left] int, [Right] int, Result varchar(15))
SET @Counter = 1
WHILE @Counter <= @DrillNumber
BEGIN
INSERT @Drill
SELECT @Counter, @Level * RAND(), @Level* RAND(),''
SET @Counter = @Counter + 1
END
SELECT convert(varchar,Sequence)+'. '
+convert(varchar,[Left])+' + '
+ convert(varchar, [Right])+ ' = '
FROM @Drill
IF @Result = 1
BEGIN
UPDATE @Drill SET Result = convert(varchar,([Left] + [Right]))
SELECT convert(varchar,Sequence)+'. '
+convert(varchar,[Left])+' + '
+ convert(varchar, [Right])+ ' = '
+Result
FROM @Drill
END
GO

exec MathTrainerAddition 60, 30, 1
GO


 

SQLUSA - The Best SQL Server 2005 Training in the World
 
 
SQLUSA.com Home Page