Filed under: Coding

An SQL puzzle

Check out this little snippet of SQL: [sourcecode language="sql"] SELECT PRAMvtID, PRAMvtRALoadDteTme, PRAMvtRAStatus, PRAMvtRAType, PRAMvtRAApprvlStatus, PRAMvtCompany, PRAMvtDeliveryNetwrk, PRAMvtMeasurePoint, PRAMvtSalesMonth, PRAMvtTicketNo INTO #complete_tkts FROM PAPRAMovement d WHERE PRAMvtID IN (SELECT PRAMvtID FROM PAPRAMovement dd WHERE dd.PRAMvtCompany = d.PRAMvtCompany AND dd.PRAMvtDeliveryNetwrk = d.PRAMvtDeliveryNetwrk AND dd.PRAMvtMeasurePoint = d.PRAMvtMeasurePoint AND dd.PRAMvtSalesMonth = d.PRAMvtSalesMonth AND dd.PRAMvtTicketNo = d.PRAMvtTicketNo AND dd.PRAMvtRAStatus = 'C' ) [/sourcecode]

Read the rest of this post »

Coding (vs) Logic 1

Yes sir!! it is a battle of clans! Today all thoughts all ideas are going to come down here. And i am holding nothing back. It is a great war this. In the world of software development there are those believe that it is the Coding that matters more than the logic! startling claims indeed. And maybe that is the reason why they have been loosing as well. Logic undeniably is ultra important when it comes to developing software. Those who somehow claim that coding skills can outshine logical abilities, obviously have issues with their logic. But then i sat down thinking all these years and more so in the past few months, thinking if there was/is any logic in what they said. Can coding truly be as important as the logic, where it is built upon that very logic?

Read the rest of this post »

Code Formatter for Blogger

This was something that my friend was asking me the other day, after he got a pang of envy looking at my code formatting in my wordpress blog (this blog). Ofcourse, there is no inbuilt method for formatting code in blogger. There are roundabout manners by which you can do it, but its too much trouble to ask for. So, instead of explaining all the weird methods in the world, i decided to Google for an online solution and hit upon this: http://alexgorbatchev.com/SyntaxHighlighter/

Read the rest of this post »

My Ruby Notes

[This post will be my Ruby Notes which i will keep updating. It is more like a personal Ruby manual.] Numbers: [sourcecode language="ruby"] population = 12_000_000_000 # means the same thing as population = 12000000000 [/sourcecode] Variables: begins with a small letter => normal variable begins with a capital letter => Constant begins with a $ => Global Variable begins with a : (colon) e.g. :a => Symbol begins with an @ => Instance Variable begins with an @@ => Class Variable in between two |'s e.g. |x| => Block arguments

Read the rest of this post »

Retrieving all the Methods in a Service

Well, today i was in a real fix. I was asked to work out a manner by which i show all the methods of a service in a combo-box. Now, people told me to ideally have a look at the proxy and type out the method names as they were and then create a static list of strings which i could then bind to the combo-box. WOW!! So simple ain't it?!? "And what if the list of methods were to change", i asked. The reply came, well, you can guess what the reply was.

Read the rest of this post »

Hello Ruby

This is probably my 1st line  of Ruby Code that i am blogging here. Learning Rubys these days. So here it is - [sourcecode language="ruby"] 10.times{ print "Hello Ruby."} [/sourcecode]   I must thank Partiosh Chhibber, my friend for his help with this post.

Calling Async Service Calls Iteratively in Silverlight

Well, i was posed with a rather strange situation today when i had to make Async Svc Calls from a Silverlight UI code. The issue was that i had to call a single service method in an iterative fashion, ideally in a loop. But the problem was that i was doing a lot of processing in the completed event handlers and the order of the processing was making a difference to my UI.

Read the rest of this post »

Code Integration

It has been a week of thorough introspection and rough hours at work. With ever changing requirements and demands of the software world and its clients, i guess any developer goes through this phase early in his career. The phase where he not only has to produce good code but also keep changing it as per those requirements, and fast!! And all the while, you have to produce bug free code. So what is the secret? How do you keep writing good error free code, with the fast paced changes? Well, let me break the bad news to you: No one can write bug free code in its entirety with significant changes in the software model/requirements being made every other day. But here is the good news: You can reduce the number of bugs by being careful about the changes that you incorporate in your software/code. And this whole process of being careful is called Integration testing.

Read the rest of this post »