May 19, 2014 at 8:56 am
Comments posted to this topic are about the item Stairway to T-SQL: Beyond The Basics Level 7: Controlling the Flow of Your T-SQL
Gregory A. Larsen, MVP
June 25, 2014 at 11:06 am
What are some real-life examples of using the While statement that don't involve RBAR code?
July 18, 2016 at 2:51 pm
I made a slight change to your code:
DECLARE @I INT = 0;
WHILE @I <[highlight="#ffff11"]=[/highlight] 10
BEGIN
IF @I%2 = 0
IF TAN(@I) > 0
PRINT 'Value ' + CAST(@I as char(1)) + ' is EVEN and the TANGENT is greater than zero'
ELSE
PRINT 'Value ' + CAST(@I as char(1)) + ' is EVEN and the TANGENT is less than or equal to zero'
ELSE
IF TAN(@I) > 0
PRINT 'Value ' + CAST(@I as char(1)) + ' is ODD and the TANGENT is greater than zero'
ELSE
PRINT 'Value ' + CAST(@I as char(1)) + ' is ODD and the TANGENT is less than or equal to zero'
SET @I += 1;
END
And the output I got is:
Value 0 is EVEN and the TANGENT is less than or equal to zero
Value 1 is ODD and the TANGENT is greater than zero
Value 2 is EVEN and the TANGENT is less than or equal to zero
Value 3 is ODD and the TANGENT is less than or equal to zero
Value 4 is EVEN and the TANGENT is greater than zero
Value 5 is ODD and the TANGENT is less than or equal to zero
Value 6 is EVEN and the TANGENT is less than or equal to zero
Value 7 is ODD and the TANGENT is greater than zero
Value 8 is EVEN and the TANGENT is less than or equal to zero
Value 9 is ODD and the TANGENT is less than or equal to zero
Value [highlight="#ffff11"]*[/highlight] is EVEN and the TANGENT is greater than zero
How do I handle this?
-----------------------------------------------------------------------
Known is a DROP, Unknown is an OCEAN.:ermm:
July 18, 2016 at 9:29 pm
Marcia J (6/25/2014)
What are some real-life examples of using the While statement that don't involve RBAR code?
Creating dynamic SQL for backups.
The "Bin Fill" and "Load Balancing" problems are classic problems that are difficult to solve without an explicit loop.
--Jeff Moden
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply