Let's contribute to make ours a perfect country

I like the dialogue from one of my favorite movies Rang De Basantiकोई देश परफेक्ट नहीं होता, उसे परफेक्ट बनाना पड़ता है

Everybody wants our country to be a perfect country, but it needs our contribution and dedication towards this. We took lot of efforts to make our sweet home neat, clean and peaceful. When it comes about country then we say इस देश का कुछ नहीं हो सकता

And yes if we will not take any initiative then the situation is not going to improve, if we can take 100% efforts for our home then at least we should take some efforts to make our country better.
I will not take your much time for speech; there are many people who can do this job better than me…


Here are few things which we can implement in our day to day life and in turns it will help to make our country better:

– Respect your country first
– Cast your vote. Do it wisely and carefully
– Do not buy smuggled or pirated goods
– Pay your tax
– Pay your employee well and treat them well
– Save water, electricity, paper and petrol
– Always ask for receipt/bill when you buy any goods
– Follow traffic rules and law
– Dispose your garbage properly
– Speak positively about our country
– Do not bribe and do not accept it as well
– Be a good parent. Teach your kids to love their country


If we will follow these little points then we can see the big change in our country. Please think about it… help our nation and give some time to it.

Ek anjani si parchai dikhai deti hai

Tanhaiyon me aksar ek goonj sunai deti hai, describes feeling of a person, who is apart from their loved one, and waiting for them.

तनहाइयों में असकर एक गूँज सुनाई देती है,
एक अनजानी सी परछाई दिखाई देती है...

उनकी निगाहों में दिखती है हमे एक हसीन दुनिया,
अब तो उनकी तस्वीर ज़र्रे ज़र्रे में दिखाई देती है

तनहाइयों में असकर एक गूँज सुनाई देती है,
एक अनजानी सी परछाई दिखाई देती है...

वो पायल का छनकना वो कंगन का खनकना,
उनकी मीठी बातों की एक धीमी लय सुनाई देती है…

तनाइयों में असकर एक गूँज सुनाई देती है,
एक अनजानी सी परछाई दिखाई देती है...

याद नहीं कब देखा था उनको आखिर बार…
पर फिर मिलने की एक उम्मीद हर वक़्त दिखाई देती है…

तनहाइयों में असकर एक गूँज सुनाई देती है,
एक अनजानी सी परछाई दिखाई देती है...
एक अनजानी सी परछाई दिखाई देती है...

Multiple Insert Statements using OpenXML

Sometimes we need to insert multiple rows into database table, while doing this we have to maintain transactions as well. We can prepare multiple insert statements and execute it, but it will take multiple database trips (if inserting from some application) and maintaining a transaction would be bit difficult in this case.


Problem

The grid/table contains multiple rows with three checkboxes in each row. The unique id field is a hidden column and it can be accessible through code behind.


User can select number of rows in the grid and save it. Expected result is all selected rows should be inserted into database table as below.


This multiple insertion process should be done in single transaction, if any insertion fails then it should roll back all changes and return an error else commit the transaction.

Solution

We can use XML parameter and OPENXML to achieve solution for the above problem. Prepare XML as string by iterating Grid/Table.

Created XML

<RootNode>
<ChildNodes Code="00001" Edit="1" />
<ChildNodes Code="00002" Add="1" Edit="1" Delete="1" />
<ChildNodes Code="00003" Edit="1" />
<ChildNodes Code="00153" Add="1" Edit="1" Delete="1" />
<ChildNodes Code="00004" Add="1" Edit="1" Delete="1" />
</RootNode>

RootNode: Root node of XML

ChildNodes: Child Node of XML

Code, Add, Edit, Delete: Attributes of Child nodes

Stored Procedure

Create Stored Procedure in SQL Server 2005 which will accept XML as parameter and insert data within single transaction.

SET ANSI_NULLS ON
SET
ANSI_PADDING ON
GO
IF OBJECT_ID('dbo.usp_AddMultipleData') IS NOT NULL
DROP PROCEDURE dbo.usp_AddMultipleData
GO
CREATE PROCEDURE [dbo].[usp_AddMultipleData]
@nAssociatedRows VARCHAR(MAX), -- This will have all Selected rwos which needs to be inserted
-- String will have data in XML Format
@nOutput BIT -- Store output result
-- E:- Error S:- Success
AS
-- Declare Transaction
DECLARE @sqlTransaction VARCHAR(20)
BEGIN TRY
-- Set output flag as succes
SET @nOutput = 'S'
-- Begin transaction
BEGIN TRANSACTION @sqlTransaction
-- Declare Handle to open XML
DECLARE @XmlDocumentHandle INT
-- Check if XML has any value then execute below steps
IF @nAssociatedRows <> ''
BEGIN
-- Open XML and create document
EXEC sp_xml_preparedocument @XmlDocumentHandle OUTPUT,@nAssociatedRows
-- Select records from XML and insert it into table variable
INSERT INTO Table_Name
SELECT Code,[Add],Edit,[Delete]
FROM OPENXML(@XmlDocumentHandle,'RootNode/ChildNodes',1)
WITH
(
Code VARCHAR(10),[Add] INT,Edit INT,[Delete] INT
)
-- Remove the creted document.
EXEC sp_xml_removedocument @XmlDocumentHandle
COMMIT TRANSACTION @sqlTransaction
END
END TRY
-- If error
BEGIN CATCH
-- Rollback Transaction
ROLLBACK TRANSACTION @sqlTransaction
-- Set error message
SET @nOutput = 'E'
END CATCH
GO

By executing this procedure at database end will insert all the rows passed as XML or this procedure can be called in any code behind (VB, C#).

More details about OpenXML



Dumb Charades

First time I played Dumb Charades game about four years ago; being a rookie player there was some hesitation while acting. But now, I just love this game and I am ready to play anywhere & anytime.
Being a great fan of Dumb Charade, I want to share the knowledge and some modifications of this game.

Summary
Dumb Charades is a word/movie guessing game. It is an acting game in which one player acts out a word or movie name, and the other players guess the word or movie name. There is specific time limit decided to do the act and guess the word or movie name.

Standard Rules
The rules of Dumb Charades can vary depending upon number of players, language, choice etc. There are some rules which are common to most players:-

1. The players divide into two teams.
2. Word/movie name should be written on chits and team will pick one chit from it.
3. Only one person (Actor) comes in front to get a chit from the pool with a word/ movie name.
4. Actor stands at least 5 feet away from partners.
5. No sounds or lip movements are allowed. Actor cannot point to object or person to show something.
6. Actor will have 5 minutes to explain the movie name and if their team will guess the correct movie then they will get 100 points

Modified Rules
Bidding :---

1. After reading a movie name actor can bid that he/she can do it in 2 minutes (Though, they will still have 5 minutes to do it)
2. If their team will guess the correct movie name then they will get 150 points if they complete it successfully in 2 minutes
3. If they cannot guess it within 2 minutes then they will lose -50 points and they can continue with rest of the time to make 100 points
4. No other negative points will be for not guessing a movie name

Spitting word :---
1. If actor feels like they cannot do this act without breaking/splitting a word, then the person can raise his hand and ask for break a word permission
2. Then they can split a word only once but they will have to lose -20 points for that

Changing Actor :---

1. If actor thinks their other team member can do it easily then, they can call some other person from their team. They will have to lose 20 points for it

Some Standard Protocols
1. First with fingers you show the number of words. Then for each word one can explain with fingers how many letters in it (if it is allowed).
2. You can thumb down for Hindi/Guajarati word or to show it is old film
3. Thumb up for English name or to show new film
4. Little shake of the horizontal hand to show medium time period film
5. You can show numbers when words involves some numbers
6. Sign like box to show that the film has a name or something like that.
7. You can use shake your hand a little so as your partner understands that he should change a little grammar in the letter.
8. Point to moustache to show you are explaining a hero's name in case you know who lead actor in the film was and point a finger to your forehead to show that you are showing heroin.
9. Touch your finger to ear to show sounds like means… Sona, Khona, Hona, Rona

Some Standard Signals
Color :---
Point to your tongue, then point to an object of the color you're trying to convey.

Close, keep guessing :---
Frantically wave your hands about to keep the guesses coming, or pretend to fan yourself, as if to say "getting hotter".

Not even close, I'll start over :---

Wave hand in a wide sweep, as if to say "go away!" Alternatively, pretend to shiver, as if to say "getting colder".

Stop yelling at me, all of you
:---
Throw your arms down to your sides, like a mummy, and jump up and down 3 times like a little baby.

A synonym :---

Clasp your hands together and then, rotating your clasped hands from the wrists, simulate multiple figures 8's.

The antonym :---

Form each hand into a hitchhiker's thumb signal, then with the backs of the hands facing away from you, cross your forearms and make the thumbs travel in opposing directions, thus "opposite".

Stop, work on something else
:---
Hold both arms out in front of you, palms of your hands waving, facing your teammates, while simultaneously shaking your head, eyes closed.

Some Difficult Hindi Movie Name
Malhaar --- Maqbool --- Kasoor --- Asambhav --- Zubeida
Chitchor --- Astitva --- Anurodh --- Yalgar --- Virgati
Ankansha --- Virasat --- Sultanaat --- Shalimar --- Thakshak
Parineeta --- Vajood --- Insaniyat --- Majboor --- Haqeekat
Khwaish --- Dharmatma --- Gardish --- Aagnishakshi --- Vishwatma

You can give some difficult word as well if movie name is easy to act.
Hope you all must be excited about it, and all set to play this game.... have fun cheers :)

Picnic at Alibag and Kashid beach

My team was planning a picnic for a long time; finally we decided the destination - Alibag and Kashid beach. Though monsoon was not finished completely, we all were set to take a risk to visit a beach. I must say that risk was worth it and we enjoyed thoroughly the entire day.

Saturday 05 Sep, 2009 was the day and everybody was expected to gather by 6:00 AM. But as it was followed by Friday i.e. weekend... so, I had slept at 4.00 AM after finishing four rounds of Call Break :)

Within an hour I got a call from one my colleagues and I woke up with sleepy eyes and little hangover (well… you know). He asked me to be ready by 6.00 AM, I hanged up the phone and asleep again. Next time when my phone ranged when the watch was showing 6.00 AM (oh my god I was screwed…)

I got ready super quick and reached the meeting point. We jumped into our tempo traveler as we were already 1 hour late and started our journey. All expected people Vinod n family, Rajesh n family, Anurag n family, Shivraj n family, Amit 1, Amit2 and Rashmi was on time except me I guess ;)

The weather was awesome during journey specially at Lonavala , we had breakfast near Lonavala and continue the journey. We played Antakshari in a Bus till we reach destination, we got opportunity to listen to some fabulous singer from our group in this Antakshari session.


We reached Alibag at 10.30 AM I must say that was early, we were expecting at least 11.30 AM. However, we rocked to the Alibag beach and the High Tide at beach was little disappointing. We had some photo session at beach and roamed around the place for couple of hours.


The Low Tide was expected by 4:00 PM so, we decided to have lunch and move to Kashid. We went to Fulora restaurant which is famous for Sea food.



After the delicious lunch we all took a nap during journey to Kashid. We reached Kashid by 3:00 PM and thankfully there was no High Tide there. The Kashid beach was as usual awesome and clean. We had lot of fun and masti as Kashid Beach.




After having ultimate fun at beach we had tea and some snacks. We enjoyed the sunset at the beach and then we back to Pune.



Everybody was tired and all were sleeping during the return journey. This was an awesome picnic and my special appreciation goes to Vinod for taking initiative and other members for making this trip worthwhile.

More Pictres

Shayari collection

Few Shayari from my collection...
==========================================
पैमाने बने थे चल रहा था जाम का था दौर...
कितने पीते गये हम उनकी याद में ये किसने किया था गौर...
हर पैमाना भरा था मेरे टूटे हुए ख्वाबो से...
पर हमारे यार कह रहे थे एक और, बस एक
और....
==========================================
उनकी सादगी ने हमे यूँ दीवाना बना दिया…..
हर छोटी मुलाकात को एक प्यारा अफसाना बना दिया….
जब हमने उनसे पूछा की ये चाँद कैसा दिखता है…
उन्होंने अपने रुख से हसीं जुल्फों को हटा दिया…

==========================================
I will keep on posting, till then keep saying wah wah ;)

An awesome Shayari

Shayari, being my hobby, I would like to dedicate my first blog to Shayari… Though I have not created it, this one is my favorite… I am sure you will love this too…

दो जवां दिलो का ग़म दूरिया समझती हैं,
कौन याद करता है ये हिचकिया समझती हैं।
तुम तो खुद ही कातील हो तुम यह बात क्या जानो,
क्यों हुआ मैं दीवाना ये वादिया समझती हैं।
बाम से उतरती है जब हसीन दोशीजा,
जिस्म की नजाकत को ये सीढियां समझती हैं।
यूँ तो शहरे गुलशन को कितने लोग आते है,
फूल कौन तोड़ेगा ये डालिया समझती है।
जिसने कर लिया दिल में पहली बार घर दनिश,
उसको मेरी आँखों की पुतलिया समझती हैं।


Hmm I know there are some fundoo Urdu words…. Don’t worry I am here to explain ;)

बाम: Terrace
दोशीजा: Mistress
दनिश: Hacking (Ghar ya dil pe kabza)


These two are my most favorite lines

बाम से उतरती है जब हसीन दोशीजा,
जिस्म की नजाकत को ये सीढियां समझती हैं।


There are some my creations as well which I will post in later posts... Enjoy and don't forget to say वाह वाह :)