Well it could have been worse, next time I'll suggest a cursor...
... within a loop... ... within a cursor... ... with in a loop... ... with temp tables... ... with some added recursion :OD We should see who can come up with the most useless use of an SP, you can be the judge :O) Ade -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 17 July 2003 13:23 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] random variable selection.. >Good point. I just didn't like the tone of the reply. > > >I will never understand why some people get flustered to replies on these >lists. If you feel there is a better way of doing something, then point it >out, but don't be rude about it. > Yeah sorry... Full of icky summer cold, so the question and the response got my blood pressure up more than it should have done. BUT it does really get on my nerves when people want to use SPs for no real good reason. >And anyway, I'm a little rusty on using CASE in SQL so it was a good reason >to give it a go. Sometimes I feel like a little challenge, and today is one >of those days. > ~lol~ I had noticed that you were replying a lot today... ;o) Regards Stephen -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
