iscivanomar
asked on
Does the number of parameter in a stored procedure affect?
First I called the Stored Procedure:
res = procs.ProcessARWD(msg.Orde rRef, msg.Lgv, msg.DestinationLocation, msg.DestinationLevel, true, resultCode, resultMsg, resultTimeStamp).ToList<EF .ProcessMa sterMsg_Re sult>();
Second
I am creating a message by using type table in SQL Server 2008.
Type table
declare @ReturnValues AS dbo.[tvpReturnValue]
INSERT INTO @ReturnValues
(
MessageType, MissionRef, Priority,
Row, ProductType, LoadAidType,
LgvSearchEnable,LevelSearc hEnabled, SideSearchEnabled, PressureGaugeEnabled,
Stability, TrackingID,
LPN, RFID, OrderNumber,
PickLocation, PickPosition, PickLevel, PickHeight, PickDistance,
DropLocation, DropPosition,
DropLevel, DropHeight, DropDistance,
WeightPalletsInLocation , NumPallets, SequenceNumber, WrappedStatus, ShipmentNr
)
VALUES
(
'DPOS', @TaskNumber, 10,
@Row, 1, ISNULL(@palletTypeFromDB,1 ),
1, 1, 1, 1,
ISNULL(@stabilityStatusFro mDB, 1), NULL,
@Lpn, @graiCode, NULL,
NULL, 0, 0, 0, 0,
@NextStorageOpPointName, @positionLgvCs,
@LevelLgvCs, @Height, 0,
@TotalWeight , @NumPallets , @SequenceNumber , @wrappedStatus , @ShipmentNumber
)
Then, I return the values with:select *
from @ReturnValues
END TRY
The ReturnValues should be now in res but I am not getting all of them.
@TotalWeight and @NumPallets are the main ones that I need.
any ideas will be good.
Thank you.
res = procs.ProcessARWD(msg.Orde
Second
I am creating a message by using type table in SQL Server 2008.
Type table
declare @ReturnValues AS dbo.[tvpReturnValue]
INSERT INTO @ReturnValues
(
MessageType, MissionRef, Priority,
Row, ProductType, LoadAidType,
LgvSearchEnable,LevelSearc
Stability, TrackingID,
LPN, RFID, OrderNumber,
PickLocation, PickPosition, PickLevel, PickHeight, PickDistance,
DropLocation, DropPosition,
DropLevel, DropHeight, DropDistance,
WeightPalletsInLocation , NumPallets, SequenceNumber, WrappedStatus, ShipmentNr
)
VALUES
(
'DPOS', @TaskNumber, 10,
@Row, 1, ISNULL(@palletTypeFromDB,1
1, 1, 1, 1,
ISNULL(@stabilityStatusFro
@Lpn, @graiCode, NULL,
NULL, 0, 0, 0, 0,
@NextStorageOpPointName, @positionLgvCs,
@LevelLgvCs, @Height, 0,
@TotalWeight , @NumPallets , @SequenceNumber , @wrappedStatus , @ShipmentNumber
)
Then, I return the values with:select *
from @ReturnValues
END TRY
The ReturnValues should be now in res but I am not getting all of them.
@TotalWeight and @NumPallets are the main ones that I need.
any ideas will be good.
Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER