Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Stairway to T-SQL: Beyond The Basics Level 7: Controlling the Flow of Your T-SQL Expand / Collapse
Author
Message
Posted Monday, May 19, 2014 8:56 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, August 17, 2016 10:41 PM
Points: 1,043, Visits: 290
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
Post #1572328
Posted Wednesday, June 25, 2014 11:06 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 7:53 PM
Points: 870, Visits: 1,885
What are some real-life examples of using the While statement that don't involve RBAR code?
Post #1586015
Posted Monday, July 18, 2016 2:51 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 18, 2016 2:48 PM
Points: 15, Visits: 51
I made a slight change to your code:

DECLARE @I INT = 0;
WHILE @I <= 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 * is EVEN and the TANGENT is greater than zero


How do I handle this?


-----------------------------------------------------------------------
Known is a DROP, Unknown is an OCEAN.
Post #1802702
Posted Monday, July 18, 2016 9:29 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 2:41 PM
Points: 42,081, Visits: 39,473
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."

Helpful Links:
How to post code problems
How to post performance problems
Post #1802747
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse