• Using SQL 2005

    Float columns are returned as NULL...

    CREATE PROCEDURE InsUpd_Master_invoicedetail

    @LinkID int ,

    @BU varchar (8),

    @orgBU varchar (8),

    @DB varchar (8),

    @InvoiceNo varchar (32),

    @SONo nvarchar (64),

    NULL

    NULL

    NULL

    NULL

    If I select Insert to new query window I get

    INSERT INTO [EProg_Master].[dbo].[Master_InvoiceDetail]

    ([BU]

    ,[orgBU]

    ,[DB]

    ,[InvoiceNo]

    ,[SONo]

    ,[ComPct1]

    ,[ComPct2]

    ,[ComPct3]

    ,[ComPct4]

    VALUES

    (<BU, varchar(8),>

    ,<orgBU, varchar(8),>

    ,<DB, varchar(8),>

    ,<InvoiceNo, varchar(32),>

    ,<SONo, nvarchar(32),>

    ,<ComPct1, float,>

    ,<ComPct2, float,>

    ,<ComPct3, float,>

    ,<ComPct4, float,>