Need a Query

Question

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

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

bhushanvinay SSCrazy Points: 2253 More actions · Answer 1

Couldnt realy follow it.

do you want to order by or some thing?

not clear.

is it a calculated col.

if you send some details like create table and insert into commands and then say the result probaly some one will help you out.

Regards
Vinay

hayzer Say Hey Kid Points: 713 More actions · Answer 2

put more detail on your question so as that somebody can help you about your problem...

Vijaya Kadiyala SSCrazy Eights Points: 9119 More actions · Answer 3

If you are looking for SQL then the best way to put is :

Input Sample Data and Output Sample Data and few lines about the requirement.

Thanks -- Vijaya Kadiyala
www.dotnetvj.com
SQL Server Articles For Beginers

Meera SSCommitted Points: 1966 More actions · Answer 4

Ok Sorry for my xplanation

Kindly assume T1, T2, T3 - Tables

T1 |

----

P1 |

C3 |

C2 |

T2|

---

C3 |

C2 |

C1 |

R1 |

T3

---

Col1 - Col2

P1 - C3

C3 - C2

C2 - C1

C1 - R1

All those values are linked as Chain in third Table T3 in 2 cols, but the start of the Chain is P1 which leads to C3 --> C2 --> C1 --> R1.

So need to show tht P1 is the start for all those commencing values.

Now, need a query which ll display those as like below,

Col1-Col2

P1 - C3

P1 - C2

P1 - C1

P1 - R1

Kindly help me to arrive at teh query... plz

Thanks for ur Help!!