Get Information In Horizontal View

Question

5.00/5 (1 vote)

See more:

I have an query in which i want to show records in horizntal rows for eg.

SQL

select count(*) from registration where joiningdate between '01-sep-2011' and '10-sep-2011'  
union   
select  count(*) from registration where joiningdate between '01-sep-2011' and '10-sep-2011' and product_receipt is null

Posted 22-Dec-11 0:11am

puneetisonfire89

Updated 22-Dec-11 0:13am

Karthik Harve

v2

Add a Solution

Comments

Karthik Harve 22-Dec-11 6:13am

[Edit] pre tags added.

Slacker007 22-Dec-11 6:20am

What is your question, exactly?

puneetisonfire89 22-Dec-11 6:28am

sir i want to show details in horizontal way.. not in Vertical

Slacker007 22-Dec-11 6:32am

First, don't call me sir :) I work for a living. Second, your question appears to be very bleak to me. I think you need to add more information as to what you exactly want to do besides just "wanting" horizontal versus vertical.

thatraja 22-Dec-11 6:26am

Horizontal View? what? Not clear

puneetisonfire89 22-Dec-11 6:38am

kk..
here i put query resulting this

6 ALD
8 BGS
13 BGS
21 BRL
42 BRL
16 BXR
33 BXR
1 DB
6 DK
7 DK
111 DPA
192 DPA
109 GA
190 GA
11 GKP
69 GKP
5 GP
33 GP
1 HB
2 JD
5 JD
7 LUC
15 LUC
10 MDB
23 MDB
8 MDP
21 MDP
67 RG
176 RG
1 RT
14 RT

Bt I need this Format

8 BGS 6 ALD
21 BRL 13 BGS
16 BXR 42 BRL
6 DK 33 BXR
111 DPA 1 DB
109 GA 7 DK
11 GKP 192 DPA
5 GP 190 GA
2 JD 69 GKP
7 LUC 33 GP
10 MDB 1 HB
8 MDP 5 JD
67 RG 15 LUC
1 RT 23 MDB
21 MDP
176 RG
14 RT

4 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)

Wendelius · Answer 1 · 2011-12-22T04:55:00

Solution 2

Typically formatting shouldn't be done with SQL. The purpose of SQL is to fetch and manipulate data, not to format it. Formatting should be done on the client side, in the application calling the database.

Posted 22-Dec-11 4:55am

Wendelius

Comments

Amir Mahfoozi 22-Dec-11 11:54am

+5 I agree with you.

Wendelius 22-Dec-11 11:56am

Thank you Amir :)

sheraj ahmad · Answer 2 · 2011-12-22T01:45:00

try this,hope it will help you.

SQL

with a as
 (
 select row_number() over(order by (select 1)) as rownumber,id,view1 from heview --here ur table name and column names ie id.. 
 ),
 b as
 (
   select row_number() over(order by (select 1)) as rownumber,id,view1 from  a where rownumber%2 <>0
 ),
 c as
 (
   select row_number() over(order by (select 1)) as rownumber,id,view1 from  a where rownumber%2 =0
 )
select c.id,c.view1,b.id,b.view1 from b,c where b.rownumber=c.rownumber

Spopy · Answer 3 · 2012-01-17T02:19:00

Solution 4

Maybe you can use case statment

select count(*) Total,
Sum( Case When product_receipt Is Null then 1
Else 0
End) Total_Receipt_Null
From registration
Where joiningdate
between '01-sep-2011' and '10-sep-2011'

Posted 17-Jan-12 2:19am

Spopy

puneetisonfire89 · Answer 4 · 2012-01-16T22:47:00

Solution 3

it gd bt row_number() is not works in sql 2000

Posted 16-Jan-12 22:47pm