Looping

Question

Post reply

Looping

smutallib.syed

SSC-Addicted

Points: 430
More actions
March 15, 2012 at 9:23 pm

#265843

Comments posted to this topic are about the item Looping
March 16, 2012 at 3:15 am

This was removed by the editor as SPAM

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

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

baabhu SSCertifiable Points: 6205 More actions · Answer 1

Seriously?

These type of errors I used to do when I learn looping.

Never the less +1 to me.

Thanks for the very easy question.

happycat59 One Orange Chip Points: 29389 More actions · Answer 2

Whilst it might take a while, eventually you will get an error when you run out of disk space. So, I kinda think that the correct answer is most likely that you will get an error at line 8 (the INSERT statement).

sam.dahl Hall of Fame Points: 3112 More actions · Answer 3

You're presuming I will stop the execution. :hehe:

But assuming I do stop execution:

The answer depends on how you measure your results.

At the end of running the code and after stopping the execution my transaction remains open.

If I then commit the transaction I get the result you described.

However if I roll it back I don't get any records.

Or am I to assume that the commit transaction line in the code provided was to be executed after execution was stopped?

edit: I assumed read committed, perhaps I shouldn't have

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 4

Easy point for me on Friday. :w00t:

However, any answer containing the word "unlimited" is wrong by default.

ps: do not test this in production! 😀

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

kapfundestanley SSCertifiable Points: 5637 More actions · Answer 5

Nice but tricky question.Thanks.

“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

paul s-306273 SSChampion Points: 10730 More actions · Answer 6

happycat59 (3/15/2012)
Whilst it might take a while, eventually you will get an error when you run out of disk space. So, I kinda think that the correct answer is most likely that you will get an error at line 8 (the INSERT statement).

Yes, run the code and see what error you REALLY do get...

Andrew Watson-478275 SSCarpal Tunnel Points: 4652 More actions · Answer 7

I got this one wrong despite knowing what the "correct" answer was, because I elected to treat the word unlimited literally. You will get an error unless you've got unlimited disk space (which would be nice).

Carlo Romagnano SSC-Insane Points: 22670 More actions · Answer 8

I get it right, but I do not like this kind of question.

😎

M&M SSC-Insane Points: 21700 More actions · Answer 9

Good question, could get this one wrong easily 🙂

M&M

Michael Riemer SSCertifiable Points: 5190 More actions · Answer 10

I agree that the answer was one of the last two, and although I got it right by elimination (I figured you were testing the looping logic rather than "unlimited" options) I think with the wording of the questions the error is probably more correct.

You will always error if you don't stop the query once you run out of disc space! You will need to run the Commit (which isn't mentioned) to have all the values of 1 maintained in the DB!

Toreador SSChampion Points: 11366 More actions · Answer 11

The correct answer is 'error at line 8', when you run out of disk space, so the closest answer is 'error at line 7'.

Stuart Davies SSCoach Points: 19505 More actions · Answer 12

Easy point to end the week on - thanks

-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx

Thomas Abraham SSChampion Points: 10761 More actions · Answer 13

Thanks for the question. It's nice to see questions from newer people. While I always appreciate the questions posted by the mainstay contributors to the site, it's good to see new participants as well.

[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn