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,>