Stairway to T-SQL: Beyond The Basics Level 7: Controlling the Flow of Your T-SQL

Question

Post reply

Stairway to T-SQL: Beyond The Basics Level 7: Controlling the Flow of Your T-SQL

Greg Larsen

SSC-Insane

Points: 20966
More actions
May 19, 2014 at 8:56 am

#307477

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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Marcia J SSCertifiable Points: 5649 More actions · Answer 1

What are some real-life examples of using the While statement that don't involve RBAR code?

Bangaaram SSC-Addicted Points: 465 More actions · Answer 2

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:

Jeff Moden SSC Guru Points: 1003851 More actions · Answer 3

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

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)