Urgent Help required

Question

Urgent Help required

Raghunath Garlapati

Ten Centuries

Points: 1122
More actions
December 8, 2009 at 11:59 pm

#214655

Hi ,
I have got a requirement to make a Report,below are the details.
Id,Name,EStartDate,PPAID,EEndDate
1,01_Event1106_Pretoria,6/11/2010,1,6/11/2010
2,01_Event1006_Soweto,6/11/2010,1,6/11/2010
3,01_Event1106_Pretoria,6/11/2010,2,6/11/2010
4,01_Event1006_Soweto,6/11/2010,2,6/11/2010
5,01_Event1106_Pretoria,6/11/2010,3,6/11/2010
6,01_Event1006_Soweto,6/11/2010,3,6/11/2010
so from the above table you can observer that for each PPA Id there are 2 rows which is for instance i told but that count is not fixed.
Now the output should be
Column1 to columnN of first row to be followed by second rows Colunn1 to clolumn N for each PPAId
so finally one row should be there for each PPA.
but no of Rows for each PPAId is not Fixed.
Please help me to solve this , actually i have 7 tables like this where finally from the seven tables i should get only one row in the Report for PPAID.
/********************************************************
Technology is just a tool,in terms of getting the kids working together and motivating them,the teacher is the most important.
********************************************************/

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Ray K SSC-Dedicated Points: 31163 More actions · Answer 1

This is painful to read. Can you post an example (a small sample should suffice) of what the output should look like? You'll probably get more responses that way.

+--------------------------------------------------------------------------------------+
Check out my blog at https://pianorayk.wordpress.com/

LutzM SSC Guru Points: 107049 More actions · Answer 2

Please read and follow the first link in my signature on how to post sample data.

The way the question is described doesn't really help to answer easily.

Maybe Dynamic Cross Tab would help... (a link to a great article regarding this subject can also be found in my signature).

Side note: Marking a thread as "Urgent" won't help at all to get replies faster. Ready to use data and expected output will.

The easier you make it for us to figure out what you're looking for the faster someone will try to answer your question.

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Jeff Moden SSC Guru Points: 1004324 More actions · Answer 3

I agree... if something is actually "urgent", take a little of your own urgent time to make it possible to respond quickly to your post... read the article Lutz pointed you to. Otherwise, things just aren't "urgent" because we'll be busy helping the folks that read and follow the methods in the article.

As a sidebar, the word "urgent" is one of the worst things you can label your post as because it's been abused so very badly on this forum for so long.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Raghunath Garlapati Ten Centuries Points: 1122 More actions · Answer 4

Hi ,

Sorry for not entering properly,

I have modified the post

Id, Name, EStartDate, PPAID, EEndDate

1, 01_Event1106_Pretoria, 6/11/2010, 1(PPAID), 6/11/2010

2, 01_Event1006_Soweto, 6/11/2010, 1(PPAID), 6/11/2010

3, 01_Event1106_Pretoria, 6/11/2010, 2(PPAID), 6/11/2010

4, 01_Event1006_Soweto, 6/11/2010, 2(PPAID), 6/11/2010

5, 01_Event1106_Pretoria, 6/11/2010, 3(PPAID), 6/11/2010

6, 01_Event1006_Soweto, 6/11/2010, 3(PPAID), 6/11/2010

so from the above table you can observer that for each PPA Id there are 2 rows.

Sorry

the output should be like

say for PPAID 1 there are 2 rows from the above example so those 2 rows should come like next by next means column--Id to EEndDate of Frst row followed by Column--Id to EEndDate of second row of same PPAID.

It should look like

Id, Name, EStartDate, PPAID, EEndDate Id, Name, EStartDate, EEndDate

1, 01_Event1106_Pretoria, 6/11/2010, 1, 6/11/2010 2, 01_Event1006_Soweto, 6/11/2010, 1, 6/11/2010

so finally one row should be there for each PPA.

but number of Rows for each PPAId is not Fixed.

Please help me to solve this , actually i have 7 tables like this where finally from the seven tables i should get only one row in the Report for PPAID.

/********************************************************
Technology is just a tool,in terms of getting the kids working together and motivating them,the teacher is the most important.
********************************************************/

Raghunath Garlapati Ten Centuries Points: 1122 More actions · Answer 5

Sorry for late reply to lutz iam actually trying the same in .NET and i was bit busy on that, As this report should go live tommorow iam just exploring other possibilities any ways sorry for late response and for using the worst thing or word "URGENT"...I too understand that you wil be busy in answering other posts please understand my situation Thanks for your help

/********************************************************
Technology is just a tool,in terms of getting the kids working together and motivating them,the teacher is the most important.
********************************************************/

Jeff Moden SSC Guru Points: 1004324 More actions · Answer 6

I do understand... that's why I you should post the data in the format requested... you'll get help a lot faster.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)