Convert rows to columns in SQL Server 2005

Hi,

I need to convert rows to columns, much like the PIVOT command, but without an aggregate function.

I have two tables that holds an invoices data::

This table holds only the available fields in an invoice. it does not hold any actual invoice data:
CREATE TABLE [dbo].[InvoicesFields](
      [CustomerCode] [int] NOT NULL,
      [FieldCode] [smallint] NOT NULL,
      [Description] [nvarchar](50) COLLATE SQL_Latin1_General_CP1255_CI_AS NOT NULL,
 CONSTRAINT [PK_InvoicesFields] PRIMARY KEY CLUSTERED
(
      [CustomerCode] ASC,
      [FieldCode] ASC,
)

for example, if an invoice for customer 123 has 2 fields, invoice date and invoice number then the table has the following 2 rows:
123,1,Invoice Date
123,2,Invoice Number

The second table holds the actual data of the invoice:
CREATE TABLE [dbo].[InvoicesFieldsData](
      [CustomerCode] [int] NOT NULL,
      [InvoiceCode] [bigint] NOT NULL,
      [FieldCode] [smallint] NOT NULL,
      [FieldData] [nvarchar](1000) COLLATE SQL_Latin1_General_CP1255_CI_AS NOT NULL
) ON [PRIMARY]

If I have one invoice with code=1001, invoice date=1/1/1980, invoice number=56789 then I will have the following 2 rows in the table:
123, 1001, 1, 1/1/1980
123, 1001, 2, 56789

Now, what I need is a sql that will return the fieldcode as columns. lets say I have only 2 field codes: 1=invoicedate, 2=invoicenumber, I need a table that looks like that:
table columns:
customercode, invoicecode, 1, 2
table rows:
123, 1001, 1/1/1980, 56789

Is that possible?
Thanks in advance!