[RESOLVED] MS SQL - Function -> Transpose data into table

[Ecniv]

Hi

I have a table structure returning field names and values...

I have a need to transpose this data via a function in MS SQL, but having very limited experience and knowledge of tsql, I wanted to check whether it is possible before looking into how...

What I have atm

CREATE FUNCTION [dbo].[GetTabelaParametro] ( @nomeparam varchar(200), @idparametrovlr int )
        RETURNS @tabela TABLE (  
            nome varchar(200),
            valor varchar(200)
        )
    
    AS
    BEGIN
       
        INSERT INTO @tabela ( nome, valor )
    	
        SELECT 
                pvi.Nome,
                pvi.valor
        
        FROM
                parametrosnew pn
INNER JOIN parametrovlrsnew pvn ON pn.idparametro = pvn.idparametro
INNER JOIN parametrovlrsitens pvi ON pvn.IdParametroVlr = pvi.IdParametroVlr
     WHERE
                pn.nomeparam = @nomeparam
         AND pvn.IdParametroVlr = @idparametrovlr
        
        RETURN
       
    END

Which just does the extract.

Question:
With the 'returns' can I just declare it to be a table and not specify columns?