Re: help in writing query

Hi Scott,<br />Thanks for the information. This is very useful for me.<br />I will be careful when forming the column.
<br/><br />Thanks,<br />-maria<br /><br /><div class="gmail_quote">On Tue, Jun 10, 2008 at 3:16 PM, Scott Marlowe
<<ahref="mailto:scott.marlowe@gmail.com">scott.marlowe@gmail.com</a>> wrote:<br /><blockquote class="gmail_quote"
style="border-left:1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="Ih2E3d">On
Tue,Jun 10, 2008 at 11:51 AM, maria s <<a href="mailto:psmg01@gmail.com">psmg01@gmail.com</a>> wrote:<br /> >
HiRosario,<br /> > Thanks for the link. I hope this will solve my problem.<br /><br /></div>It should be able to.
 Notethat crosstab functions expect "square"<br /> inputs from the select they run.  I.e. you can't have empty
columns,<br/> you need to replace NULL output with something like a space or empty<br /> string.<br /><br /> This is
badinput for crosstab:<br /><br /> col1 col2 col3<br /> 1 2 3<br /> 2 3 NULL<br /> 3 NULL 6<br /><br /> But this will
work:<br/><br /> col1 col2 col3<br /> 1 2 3<br /> 2 3 '' <- an empty string<br /> 3 '' 6<br /><br /> The crosstab
functionsare wonderfully useful btw, once you figure all<br /> the little quirks like this out.<br
/></blockquote></div><br/>