Do you not own any references on ASP.NET ? Does google not work where you live ? EIther you're not explaining this right ( possible, as the only code you've posted is SQL ), or you're struggling with something quite trivial. Christian Graus Driven to the arms of OSX by Vista. Please read this[^] if you don't like the answer I gave to your question. "! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.

Yes I fully agree with Scott M Use distinct clause :) Niladri Biswas

Mathew P V wrote: i am trying to display the leave allotted for a permanent employee but since in the table there are three permanent employees records its showing the type of leave three times what should i do First of all this is ASP.NET Forum. Second thing I am not able to understand your problem. Please put your query in DB Forum with proper details. cheers, Abhijit CodeProject MVP Web Site:abhijitjana.net

Vasudevan Deepak Kumar wrote: OMG! That would invite trouble sometimes. The poster might get really attracted by such initial offer and CTRL+A, CTRL+V his Visual Studio file. Do you really want to get torched by that scorching torture? Then use the word "snippet". Seriously - I'm tired trying to help sometimes because most people don't actually want help. But I do my best, and if cutting out one barrier helps me help someone then I can put up with the occasional nutter who posts everything. The majority do not. Man who stand on hill with mouth open wait long time for roast duck to drop in

i used timespan diff=calendar1.selecteddate.substract(calendar2.selecteddate); and now its working thank you for your valuable suggestion i will do the same. modified on Tuesday, June 2, 2009 6:06 AM

it is showing an error like "'System.Web.UI.WebControls.Calendar' does not contain a definition for 'Date' and no extension method 'Date' accepting a first argument of type 'System.Web.UI.WebControls.Calendar' could be found (are you missing a using directive or an assembly reference?)"

You are welcome. I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post.