While loop Testing

Question

While loop Testing

Shiva N

Hall of Fame

Points: 3125
More actions
September 9, 2014 at 10:26 pm

#296080

Comments posted to this topic are about the item While loop Testing
Thanks,
Shiva N
Database Consultant

Viewing 15 posts - 1 through 15 (of 20 total)

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

Koen Verbeeck SSC Guru Points: 259165 More actions · Answer 1

Interesting, albeit megalomaniacal question 😀

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Umer Akram SSC-Insane Points: 22209 More actions · Answer 2

Woww .... to many nested While loops 🙂

Nice question, as its reminded the nested loop depth. Thanks for sharing.

I wonder what Jeff Moden have to say about this ... :hehe:

Sorin Petcu Hall of Fame Points: 3195 More actions · Answer 3

You have a bug in your code here: SET @strend = @strend + ' SET @intloopCounter=@intloopCounter+1 END '

and the variable should be @intLoopCounter, case letters depends. With your code on any SQL place it throws errors.

In Theory, theory and practice are the same...In practice, they are not.

Vimal Lohani SSCommitted Points: 1650 More actions · Answer 4

Tricky....

good one...

Vimal LohaniSQL DBA | MCP (70-461,70-462)==============================The greatest barrier to success is the fear of failure ** Success is a journey not a destination**Think before you print, SAVE TREES, Protect Mother Nature

Hany Helmy SSChampion Points: 13921 More actions · Answer 5

Good question, if you read it carefully you will get the answer right.

Thanx

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Anipaul SSC-Insane Points: 24681 More actions · Answer 6

Anipaul

SSC-Insane

Points: 24681

September 10, 2014 at 3:20 am

#1744351

Nice one .....

Bangla Hall of Fame Points: 3137 More actions · Answer 7

twin.devil (9/10/2014)
Woww .... to many nested While loops 🙂
Nice question, as its reminded the nested loop depth. Thanks for sharing.
I wonder what Jeff Moden have to say about this ... :hehe:

Yep...

Erwin Oosterhoorn SSCrazy Points: 2320 More actions · Answer 8

Due to an error in the variable name I chose the wrong answer. Interesting to read more about while loop levels, although who would ever need/create a query with that many while loops is baffling me. 😉

Ed Wagner SSC Guru Points: 287026 More actions · Answer 9

An interesting question to be sure, but as a general rule, I can't stand loops. On those rare occasions when they're necessary, I'll begrudgingly use one, but I still don't like them.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Rune Bivrin SSCrazy Eights Points: 8626 More actions · Answer 10

I think the only thing I take away from this question is confirmation that dynamic SQL must be avoided, but if you need it you should at least name your variables with a little more care...

Just because you're right doesn't mean everybody else is wrong.

Sean Lange SSC Guru Points: 286609 More actions · Answer 11

Personally I detest questions like this. This is testing our ability to be a human compiler and debug code that faced with in the real world I would toss out and rewrite. To me this does not follow the spirit of the QOTD which is to test our knowledge of various aspects of sql server. It doesn't help that the site does a rather lousy job of formatting. While I don't like the question I applaud the effort and hope to see more questions from Shiva in the future.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

SQLRNNR SSC Guru Points: 281344 More actions · Answer 12

Thanks Shiva

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

abjames Old Hand Points: 341 More actions · Answer 13

I got a different error than was indicated,

Msg 102, Level 15, State 1, Line 1289

Incorrect syntax near 'END'.

But when I reduced @intMaxLoop from 162 to 161, it worked. So I chose that option, which was wrong. Humph.

pmadhavapeddi22 SSCertifiable Points: 5306 More actions · Answer 14

After seeing the code , I checked the options for answers, when I saw the option, "display shiva 2 times"

some how I felt this is the answer

By any chance do you wanted your name to be displayed in the everyone's result set who ever tries this quesion 😛