Thangaraj P.V. - Professional Profile

Action

Author

Authority

Debator

Editor

Enquirer

Organiser

Participant

If Owner

Member Types

Have no restrictions on voting frequency

silver

Bypass spam checks when posting content

silver

gold

SubEditor, Mentor, Protector, Editor

Store personal files in your account area

platinum

SubEditor, Editor

Have live hyperlinks in your profile

bronze

silver

SubEditor, Protector, Editor

Have the ability to include a biography in your profile

bronze

silver

SubEditor, Protector, Editor

Edit a Question in Q&A

silver

Yes

SubEditor, Protector, Editor

Edit an Answer in Q&A

silver

Yes

SubEditor, Protector, Editor

Delete a Question in Q&A

Yes

SubEditor, Protector, Editor

Delete an Answer in Q&A

Yes

SubEditor, Protector, Editor

Report an Article

silver

SubEditor, Mentor, Protector, Editor

Approve/Disapprove a pending Article

gold

SubEditor, Mentor, Protector, Editor

Edit other members' articles

SubEditor, Protector, Editor

Create an article without requiring moderation

platinum

SubEditor, Mentor, Protector, Editor

Approve/Disapprove a pending Question

Protector

Approve/Disapprove a pending Answer

Protector

Report a forum message

silver

bronze

Protector, Editor

Approve/Disapprove a pending Forum Message

Protector

Have the ability to send direct emails to members in the forums

Protector

Create a new tag

silver

Modify a tag

silver

I have the database tables similar to the below

Table 1: Elements

Fields Name	Data Type
Parent_Element_Id	Integer
Element_Id	Integer
Element_Name	Varchar

Table 2: Reports

Fields Name	Data Type
Report_ID	varChar
Report_Description	varChar
Stores_Id	varChar
Month_Start_Date	DateTime
Month_End_Date	DateTime

Table 3: Reprots_Detail

Fields Name	Data Type
Report_ID	DateTime
Element_ID	Integer
Element_Value	Double

for Example, I have the values in database like this below...

Table Name: Reports

Report_ID	Report_Description	Stores_Id	Month_Start_Date	Month_End_Date
R0001	aaaaaaaaaaaaaaaaaa	S00001	01-20-2004	02-19-2004
R0002	ssssssssssssssssss	S00002	01-20-2004	02-19-2004
R0003	dddddddddddddddddd	S00002	02-20-2004	03-19-2004
R0004	ffffffffffffffffff	S00001	02-20-2004	03-19-2004
R0005	gggggggggggggggggg	S00001	03-20-2004	04-19-2004
R0006	hhhhhhhhhhhhhhhhhh	S00003	01-20-2004	02-19-2004
.........

Table Name: Elements

Parament_Element_Id	Element_Id	Element_Name
0	1	Anabond
0	2	Bobin
0	3	Coolent
1	11	Anabond 202
1	12	Anabond 101
1	13	Anabond xxx
3	31	Water/Gel Based
3	32	Oil Based
32	321	xxxxxxx
32	322	yyyyyyy
32	321	zzzzzzz
........

Table Name: Reports_Detail

Report_Id	Element_Id	Element_Value
R0001	321	43
R0001	322	23
R0001	323	54
R0001	11	110
R0004	321	23
R0004	322	55
R0004	11	643
R0004	12	500
.........

my table values are like this.

I want to write the stored Procedure and display the values such that, my SP will not have the headers as column

name of tables. but I want to have like

if Store_Id = S00001 selected, then

my SP should give the the value like

Parament_Element_Id	Element_Id	Element_Name	R0001	R0004	R0005	......
0	1	Anabond
0	2	Bobin
0	3	Coolent
1	11	Anabond 202	110	643
1	12	Anabond 101	500
1	13	Anabond xxx
3	31	Water/Gel Based
3	32	Oil Based
32	321	xxxxxxx	43	23
32	322	yyyyyyy	23	55
32	321	zzzzzzz	54
........