Monthly Archives: March 2015

SQL Server PIVOT tutorial

Pivot can be a little tricky to use. I will explain with the help of example — Create Table First create table student( id int not null primary key identity, rno int not null, subject varchar(30), score int, outof int) … Continue reading

Posted in SQL Server 2008 | Tagged , , | Leave a comment

Redirect in PHP not working

header(“Location: http://www.website.com/”); is generally enough to redirect your page but most of the time it does not work because it requires that no data should be sent to the client before the header, or rather header should be the first … Continue reading

Posted in Tutorials/Tips, Uncategorized | Leave a comment

Looping through gridview in C# always return empty

I had a gridview which was bounded to a datasource (datatable in my case) in code behind in C#. Code was something like this foreach (GridViewRow Row in GV_Items.Rows) { string str = Row.Cells[0].Text; } This was always returning empty … Continue reading

Posted in Tutorials/Tips | Tagged , | Leave a comment

excel add title to chart

Tutorial on how to add title to Excel Chart 1. Click on Excel Chart 2. Chart Tool appears in the ribbon bar. 3. In the “Design” TAB, “Chart Layout” group, select the first one which contains title. 4. Title will … Continue reading

Posted in Tutorials/Tips | Tagged , | Leave a comment

print 4 charts one page excel

This is really simple. Create four charts as you would normally do Create a new sheet Copy and past the 4 charts to the new page. Place them (and resize them) so that they appear one page. Do print preview … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment

IMAP vs POP3

There are two main protocol for accessing your emails via client. IMAP and POP3. The following are the main differences [table] IMAP, POP3 IMAP coordinates with the server, POP3 does not coordinates with the server Email synched via IMAP are … Continue reading

Posted in Tutorials/Tips | Leave a comment

windows cannot print due to a problem with the current printer setup

This is a work around for the above problem, your printer cannot print because of margin set in the printer setting. A quick work around is as follows: 1. Print to PDF Printer (If you don’t have one, install one. … Continue reading

Posted in Tutorials/Tips, Uncategorized | Tagged | Leave a comment

Getting RAW Data in LIMTON TIS Time Management System

I had to pull raw data of an employee who hare marked his/her attendance more than 2 times (probably thinking to trick the system or otherwise), the regular table HRTAttendance show only In and Out time. In case of multiple … Continue reading

Posted in Tutorials/Tips | Tagged , , | Leave a comment

Get No of Sundays in a month SQL Server

The following stored procedure returns number of sundays in given month. It takes date as parameter. Month and year is extract from the date. CREATE FUNCTION GetSundays (@giveDate DATETIME) RETURNS INT AS BEGIN DECLARE @firstday DATETIME, @lastday DATETIME SELECT @firstday … Continue reading

Posted in SQL Server 2008 | Tagged , | Leave a comment

SQL Condition in WHERE Clause

How would you set a condition in where clause in SQL Server? For example you have a parameter @ProjectID. If @ProjectID is 1, then select all employee with EmployeeNo 1000. If @ProjectID=2 then select all employee with employeeNo betweeen 1000 … Continue reading

Posted in SQL Server 2008 | Tagged , | Leave a comment