My World A Blog On All The Things That Happen In My Life

Spinach Alfredo pizza with bacon,  cheese and jalapeƱos. Lunch by @joshenoy@joshenoy sitting besides me on the balconyFor this Friday evening.  Beer + pizzaChuudi - 3 flowers and Durva grass tied together with a string. @.@joshenoy crafting a bunch of these. #nofilterChudi pooja at homeIMG_20140616_162916IMG_20140613_220028IMG_20140612_222607
Status » Grid 2 gameplay video - Faceoff run with the Nissan Fairlady Z: http://t.co/IiAPdIA9sS via @YouTube

Posts tagged query

Creating and Editing Parameterized Queries in Excel 2007
on 12/10/2010 - like it?

I spotted this question on Super User about creating parameterized queries in Excel 2007 and attempted to answer it – as I thought it would be pretty easy.

And well – it was easy – the part part where you create the query, that is. Now creating parameterized queries – now that’s something totally different. I searched around a bit for documentation on doing so – and found that any articles on the same were woefully inadequate. To be specific: There are plenty of articles on how to change the parameters – just head over to Properties -> Query Definition -> Parameters. Ok, cool. Now hang on, the Parameters button is disabled. How the heck am I supposed to get it enabled ? I had a ball of a time trying to figure out a way to do it – and in the end, found the answer, and posted it. Figured might as well post it here for my reference… and for others who are searching for a way to do the same.

(more…)

Tags: , , , , ,


The Power and Simplicity of Oracle Hierarchical Queries
on 19/01/2009 - like it?

They say “Necessity is the Power of Invention” – a quote which I fully understood the impact today. I’ve been trying to understand Oracle’s Hierarchical Queries for a while now, but never fully understood the situation under which or when it would be used. Yesterday I got a reason to use it. Let me begin.

(more…)

Tags: , , , ,


Query For Displaying The Calender of The Current Year using SQL
on 24/06/2008 - like it?

Another of things I got via IpMessenger, this query(yes, its a QUERY, not even a full-blown code) returns the calender of the current year. Do note this query will work only in Oracle.

Here’s the query.
(more…)

Tags: , , ,