how to display sql table in custom format

Question

3.00/5 (2 votes)

See more:

hi

I have a sql table in this format

SQL

leavecode  leavename       leavecount      employeename      department

  ML           Medical         10            sanjay             programming

  CL           Casual          5             sanjay             programming

  ML           Medical         5             Chandru            Marketing

  CL           Casual          6             Chandru            Marketing

I need to display in this format using gridview or any other control

SQL

employeename        ML         CL        department

 Sanjay             10         5         programming

 Chandru            5          6         Marketing

Posted 9-Feb-12 23:02pm

arun 2012

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Aniket Yadav · Answer 1 · 2012-02-09T23:07:00

Solution 1

check this link

http://www.sqllion.com/2009/05/group-by-clause-sql-server-2005-vs-2008/[^]

It Will Help You

Posted 9-Feb-12 23:07pm

Aniket Yadav

Manoj Kumar Choubey · Answer 2 · 2012-02-09T23:08:00

use Union Query to do it
check folling link :

http://www.java2s.com/Code/Oracle/Result-Set/AUNIONquerythatusesanORDERBYclause.htm[^]

and Use Group By

following Query can work in ms access

SQL

Select EmployeeName  sum(ML) as ML,Sum(CL) as CL ,DepartMent  from (
Select EmployeeName , LeaveCount as ML , 0 as CL , DepartMent from tableName
Union
Select EmployeeName , 0 as ML , LeaveCount as CL , DepartMent from tableName)
grup by EmployeeName ,DepartMent

anbukrish · Answer 3 · 2012-02-10T00:10:00

Hi,
Please use follow stored procedure, you can get as per your wise

SQL

SELECT Employeename,[ML],[CL],Department
FROM 
	(SELECT
		Employeename,
		Leavecode,		
		Department,
		Leavecount		
	FROM	
		Employee
	GROUP BY Employeename,Leavecode,Department,Leavecount	
	) DataTable
PIVOT
(	
	MAX(Leavecount)
	FOR Leavecode
	IN
	(
		[ML],[CL]
	)	
)PivotTable

Regards,
anbukrish

how to display sql table in custom format

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0