Month: August 2010

Posted in SQL Server Uncategorized

Fine Duplicate rows & Delete duplicate rows

Fine duplicate row SELECT ColumnName, COUNT(ColumnName) AS ColumnName FROM tbl_Employee_M GROUP BY ColumnName HAVING ( COUNT(ColumnName) >…

Posted in SQL Server Uncategorized

Pivot in SQL Server

Declare @table1 table ( SalesPerson varchar(50), Product varchar(50), SalesAmount float ) insert into @table1(SalesPerson,Product, SalesAmount) values (‘Bob’,…

Posted in Crystal Report Uncategorized

Crystal report XML file as DataSource

Namespace: using CrystalDecisions.CrystalReports.Engine; using CrystalDecisions.Web; Global variable: CrystalDecisions.Web.Report rpt = new CrystalDecisions.Web.Report(); CrystalDecisions.CrystalReports.Engine.ReportDocument rpt1; Onbutton or Page…

Posted in Asp.Net Uncategorized

Client System TimeZone Offset

The getTimezoneOffset method returns an integer value representing the number of minutes between the time on the…