Zebradillo

Posted by Picasa

Comments

Post a Comment

Popular posts from this blog

Non-cursor cursors

So I've been doing SQL queries for a while now, but only just worked out that 99 times out of 100, whenever you think you need a cursor, you probably don't. You probably need some sort of loop and some sort of track of where you are...but the answer to that is NOT a cursor. For example: You have a list of portfolios that you wish to value, but you need to call a proc/function against each in turn, so doing a single query is out of the question. The answer would appear to be a cursor, iterating over a list. WRONG. Here's how NOT to do it: DECLARE pfo_cursor CURSOR FOR SELECT pfo FROM #id OPEN pfo_cursor FETCH NEXT FROM pfo_cursor INTO @pfoLoop WHILE @@FETCH_STATUS = 0 ...do stuff with @pfoLoop FETCH NEXT FROM pfo_cursor INTO @pfoLoop CLOSE DEALLOCATE And here's a quicker, easier, cheaper, better way: SET @pfoLoop = (SELECT TOP 1 pfo FROM #id ORDER BY pfo) WHILE @pfoLoop is not null BEGIN ...do stuff with @pfoLoop SET @pfoLoop = (...
Read more

I've been away, but now I'm back

Apologies for the lack of updates. Not that I expect anyone is actually reading such an ill-kempt blog. I have been spectacularly busy both at work and at home. However over the following weeks I will be attempting to catch up with a few technical bits and pieces which I have been meaning to share with the world. Lastly, but most importantly, I am sorry to announce the passing on of the original mono-rail cat. Whitby died peacefully in her sleep, in her favourite spot (the hot water pipe which runs under the bathroom) a few months ago now. My wife misses her more than I do. RIP.
Read more