Overblog
Follow this blog Administration + Create my blog

Top posts

  • SQL Server Rank functions, RANK, NTILE, DENSE_RANK, ROW_NUMBER

    20 April 2010 ( #SQL Server2005 )

    Transact-SQL provides the following ranking functions: -RANK -NTILE -DENSE_RANK -ROW_NUMBER Rank() - Applies to monotonically increasing number for each value in the set Row_Number() - simply assigns sequential numbering to the records of a result-set...

  • Articale on Ajax

    09 March 2009 ( #ASP.Net )

    Ajax: Ajax (also known as AJAX), shorthand for "Asynchronous JavaScript and XML", is a development technique used for creating interactive web applications. The intent is to make web pages feel more responsive by exchanging small amounts of data with...

  • Advanced Reporting with Matrix Control in SSRS

    27 January 2010 ( #SSRS )

    Here I will show you how to get these custom aggregates on a matrix report and will cover a few interesting reporting techniques along the way Cells-by-Cells technique – This helps us achieve a bit more usability with the somewhat limited framework of...

  • A Short Story -- About Relation Ship

    09 March 2009 ( #Life )

    Little girl and her father were crossing a bridge. The father was kind of scared so he asked his little daughter, "Sweetheart, please hold my hand so that you don't fall into the river." The little girl said, "No, Dad. You hold my hand." "What's the difference?"...

  • Cross-Tab or PIVOT in SQL-Server2005

    07 March 2009 ( #SQL Server2005 )

    Cross-Tab or PIVOT in SQL-Server2005 With the new PIVOT operator in SQL Server 2005, the CASE statement and GROUP BY statements are no longer necessary. (Every PIVOT query involves an aggregation of some type, so you can omit the GROUP BY statement.)...

  • An Article about Love -- Swamy Vivekananda

    09 March 2009 ( #Life )

    I once had a friend who grew to be very close to me. Once when we were sitting at the edge of a swimming pool, she filled the palm of her hand with some water and held it before me, and said this: "You see this water carefully contained on my hand? It...

  • Beginning of Reporting Services 2005

    20 January 2010 ( #SSRS )

    SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can be used to prepare and deliver a variety of interactive and printed reports. It is administered via a web interface. Reporting services features...

  • An interview on CNBC with Warren Buffet

    12 March 2009 ( #Life )

    There was a one hour interview on CNBC with Warren Buffet, one of the richest men in the world, who has donated $31 billion to charity. Here are some very interesting aspects of his life: 1. He bought his first share of stock at age 11 and he now regrets...

  • Secrets of good relationships

    17 March 2009 ( #Life )

    TRUST is a very important factor for all relationships. When trust is broken, it is the end of the relationship. Lack of trust leads to suspicion, suspicion generates anger, anger causes enmity and enmity may result in separation. A telephone operator...

  • Why should the wedding ring be worn on the fourth finger?

    29 July 2009 ( #Life )

    There is a beautiful and convincing explanation given by the Chinese..... Thumb represents your Parents Second (Index) finger represents your Siblings Middle finger represents your-Self Fourth (Ring) finger represents your Life Partner & the Last (Little)...

  • Life

    09 March 2009 ( #Life )

    Life As we grow up, we learn that even the one person that wasn't supposed to ever let you down probably will. You will have your heart broken probably more than once, and it's harder every time. You'll break hearts too, so remember how it felt when yours...

  • Beginning SQL Server 2005 - First Sample SSRS

    20 January 2010 ( #SSRS )

    The easiest way to create a report in Report Designer is to use the Report Wizard. Like all wizards, the Report Wizard walks you through the process in step-by-step fashion. You can make the following choices in the wizard: To create a simple report using...

  • How to access Parent Window Control in Child Window

    09 March 2009 ( #ASP.Net )

    Access Control which is in Parent Data grid/Grid View in Child Window. Bind the Data Grid Control with Data and call a PopUp Window from any one item in that to fill the control of Data Grid which is in particular row. by clicking on the Get Remarks,...

  • Article on Sqlserver Indexes

    27 July 2009 ( #SQL Server2005 )

    One of the most powerful way to get high performance in a SQL Server database is the index. Indexes speed up the your querying process by providing swift access to rows in the data tables, like the way a book’s index helps you find information quickly...

  • Small story - with beautiful message

    12 March 2009 ( #Life )

    The train has started moving. It is packed with people of all ages, mostly with the working men and women and young college guys and gals. Near the window, seated a old man with his 30 year old son. As the train moves by, the son is overwhelmed with joy...

  • Beautiful Quotes

    12 March 2009 ( #Life )

    There are hundreds of languages in the world but a smile speaks them all. And the best smile is the one which shines through troubles Keep Smiling ……. Every Little Smile can touch Somebody's heart May U find hundreds of reasons to smile today and May...

  • SSRS - Matrix Control

    21 January 2010 ( #SSRS )

    In SQL Reporting Services, the Matrix control provides a crosstab view of data, similar in behavior to a PivotTable. Rows and columns will have intersecting points of data which is often useful in time based reporting. Matrix components are great for...

  • sayings of swamy vivekananda

    12 March 2009 ( #Life )

    sayings of swamy vivekananda some of the sayings of swamy vivekananda My ideal, indeed, can be put into a few words, and that is to preach unto mankind their divinity, and how to make it manifest in every movement of life. Religion is the manifestation...

  • iTextSharp

    06 June 2012

    Getting Started with iTextSharp For the ASP.NET developers out there, if you need to generate PDF reports from your code, there is an open source library called iText# (iTextSharp) that is worth checking out. iTextSharp is a port of the Java iText library...

  • Bind GridView With Data and Serial Number as First Column

    07 March 2009 ( #ASP.Net )

    Bind Serial Number as First Column to GridView Add a Template Filed to Grid View Ex: ...

  • Artical on Webservice II

    07 March 2009 ( #ASP.Net )

    By the Previous Post I Explained about web service. By this Post I Explaining, How to Publish Web service and How to Call Web Services From Remote Server Step 1) Create A Web Service and Build it. Step 2) Publish Web Service into a Remote Server. Steps...

  • Lunch With God

    16 March 2009 ( #Life )

    A little boy wanted to meet God . He knew it was a long trip to where God lived, so he packed his suitcase with a bag of potato chips and a six-pack of root beer and started his journey. When he had gone about three blocks, he met an old woman. She was...

  • Lessons on Life

    23 March 2009 ( #Life )

    Lessons on Life There was a man who had four sons. He wanted his sons to learn not to judge things too quickly. So he sent them each on a quest, in turn, to go and look at a pear tree that was a great distance away. The first son went in the winter, the...

  • Defragmenting Indexes in SQL Server

    05 February 2010 ( #SQL Server2005 )

    When data is inserted, deleted, or updated in a SQL Server tables, the indexes which are defined for that tables are automatically updated to reflect those changes. When these indexes are modified, the information stored in them becomes fragmented, resulting...

  • Export Gridview data to Excel

    18 February 2010 ( #ASP.Net )

    i) Get the Data from the Database and Bind it to the Gridview ii) Set Gridview Allowpaging property to "False" Write the below code to export the entire Gridview data to Excel sheet private void ExportGridView() { string style = @"