Month: March 2014
Attendance UNPIVOT first then Pivot for count present, absent etc in SQL
Sample data download: here Declare @tempAttendance table(EmpID int, EmpName varchar(50), edate int, ecode varchar(5)) insert into @tempAttendance…
Dynamically create columns in a temp table and generate pivot report
Sample Data download: http://goo.gl/lcOf8z Generate excel report as below. Username, Address, City, State, Zip, Question 1, Question…
Add Comma into number using javascript
<script> addCommas = function(input){ // If the regex doesn’t match, `replace` returns the string unmodified return (input.toString()).replace(…