Re: [SQL] help in writing query

Hi Pavel, Thank you for your reply. I tried the query and it is returning result as , for a single entry in sample info in separate rows The result of the query as 1, prop1,value1 1,prop2,value2 2,prop1,value1 2 prop2,value2 2 prop3,value3 but i want the output as single row per sample id like

Re: [SQL] help in writing query

maria s escreveu: I tried the query and it is returning result as , for a single entry in sample info in separate rows The result of the query as 1, prop1,value1 1,prop2,value2 2,prop1,value1 2 prop2,value2 2 prop3,value3 but i want the output as single row per sample id like

Re: [SQL] help in writing query

2008/6/10 maria s [EMAIL PROTECTED]: Hi Pavel, Thank you for your reply. I tried the query and it is returning result as , for a single entry in sample info in separate rows The result of the query as 1, prop1,value1 1,prop2,value2 2,prop1,value1 2 prop2,value2 2 prop3,value3 but i

Re: [SQL] help in writing query

Hi Rosario, Thanks for the link. I hope this will solve my problem. Thanks, Maria On Tue, Jun 10, 2008 at 11:34 AM, Osvaldo Rosario Kussama [EMAIL PROTECTED] wrote: maria s escreveu: I tried the query and it is returning result as , for a single entry in sample info in separate rows The

Re: [SQL] help in writing query

On Tue, Jun 10, 2008 at 11:51 AM, maria s [EMAIL PROTECTED] wrote: Hi Rosario, Thanks for the link. I hope this will solve my problem. It should be able to. Note that crosstab functions expect square inputs from the select they run. I.e. you can't have empty columns, you need to replace NULL

Re: [SQL] help in writing query

Hi Scott, Thanks for the information. This is very useful for me. I will be careful when forming the column. Thanks, -maria On Tue, Jun 10, 2008 at 3:16 PM, Scott Marlowe [EMAIL PROTECTED] wrote: On Tue, Jun 10, 2008 at 11:51 AM, maria s [EMAIL PROTECTED] wrote: Hi Rosario, Thanks for the