Overblog Follow this blog
Administration Create my blog
Balavardhan Reddy Narani

Top posts

  • 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.)...

  • 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,...

  • 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...

  • 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...

  • 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...

  • 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?"...

  • 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...

  • 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...

  • 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...

  • 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...

  • 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...

  • 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...

  • 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)...

  • 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...

  • 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...

  • 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...

  • 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...

  • 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...

  • 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...

  • Function To Split a String and Store in Table in SQLServer2005.

    07 March 2009 ( #SQL Server2005 )

    Here By I am providing a function to Split the String by deliminator in Sql Server This Function requires two Parameters 1). String to Split 2). Deliminator to split the string based on character SQL Server Function CREATE FUNCTION [dbo].[udf_List2Table]...

  • Access one Database Server Object in another Database server

    07 March 2009 ( #SQL Server2005 )

    Access one Database Server Object in another Database server To access one DB Server from another DB server we required Linked Server object , whcih was created to access another DB Server Below are the methods to Create Linked Servers Required System...

  • Query to Delete Duplicate Records from a Table

    07 March 2009 ( #SQL Server2005 )

    Delete Duplicate Records From a Table Table Structure Name : Employee Columns : Emp_ID Identity Column EMP_Name DOB SEX if you want delete the Duplicate Records based on EMP_Name Column which was existed Previously (i.e. Delete Duplicate Emp_name records...

  • Update Column Name Set values to Column of table in Sqlserver

    07 March 2009 ( #SQL Server2005 )

    Here by i am provinding a query to update a Column name of table and set teh new values into that column and we can view the Old column and values and Updated column name and newly set value of the column. Update < TableName> Set <> = <>...

  • Query to get Multiple rows data in Single Line from the Sql Server Database Without Using STUFF Command

    07 March 2009 ( #SQL Server2005 )

    By the Below Query you will get Multiple rows data in Single Line from the Sql Server Database select <> as "text()", ',' as "text()" from <> for xml path('') Ex : My Table structure Create Table #temp1(MyID Int) Insert Into #temp1(1) Insert...

  • Bulk Update in Sqlserver

    07 March 2009 ( #SQL Server2005 )

    Bulk Update in Sqlserver Here by I am providing example how to update mutile columns by a single query Table Structures Employee Table EmployeeID First Name Last Name JobName RoleID Description Status Jobs Table JobName RoleID Description Roles Table...

1 2 3 4 > >>