How can I retrieve a recordset from a matrix-like table?

I have a table defined as (int Row, int Column, money Data); as it were a matrix.

Which is the more efficient way of retrieving a result set with the following form?

Column1 Column2 Column3
---- ---- ----
Data11 Data12 Data13
Data21 Data22 Data23
Data31 Data32 Data33
... ... ...


Thanks a lot in advance.Lookup "Crosstab queries" in Books Online, and you will see a perfect example of how to do what you want to do.

How can I force money field works with comma instead dot?

How can I force money field works with comma instead dot?
Hi,
How can I force money field works with comma instead dot?
The default language of my Data Base is Portuguese.
Because I have to make something as below to work ok:
LgValor = Request("txtValor")
LgValor = Replace(LgValor,",",".")
So I have to put always this in the bank: 99999.99 .....
Thanks,
VILMAR
BRAZILFor input, you cannot have comma instead of dot. This is how the SQL language and SQL Server work,
quite simply.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Vilmar Brazão de Oliveira" <suporte@.hitecnet.com.br> wrote in message
news:e9KLP4ZxDHA.1680@.TK2MSFTNGP12.phx.gbl...
> How can I force money field works with comma instead dot?
> Hi,
> How can I force money field works with comma instead dot?
> The default language of my Data Base is Portuguese.
> Because I have to make something as below to work ok:
> LgValor = Request("txtValor")
> LgValor = Replace(LgValor,",",".")
> So I have to put always this in the bank: 99999.99 .....
> Thanks,
> VILMAR
> BRAZIL
>