Hi
A big funny I think
first I declared ...
DECLARE @Lots TABLE
(
LotID varchar(20)
)
Problem 1
when I typed Insert Into I didn't get a suggestion of @Lots as I would expect in fact no Candidate List at all
Problem 2
Then I typed the Select * from dbo.Lot and "wow" it reacted as if I had selected Insert Into Lot and piled in all the columns and the appropriate values as you expect from the automated Insert Into and I got this .....
INSERT INTO @Lots
(LotID)
SELECT * FROM dbo.Lot
( LotID ,
MaterialName ,
MaterialVersion ,
HoldStatus ,
QuarantineStatus ,
CreateDate ,
ExpirationDate ,
ZeroDate ,
PrimaryQty ,
PrimaryUOM ,
SecondaryQty ,
SecondaryUOM ,
CustSpecName ,
CustSpecVersion ,
Priority ,
DueDate ,
LotSuffix ,
NextSublotIndex ,
LastSublotIndex ,
LockCount ,
ProcessOrder ,
Alias ,
Status ,
Locked ,
Exception ,
RealLot ,
ConcessionRaised ,
ConcessionAuthorised ,
AuthoriseLevel ,
FTIC ,
ReleaseStatus ,
SlipStream ,
FinishedOn ,
FinishedBy ,
LotZeroException ,
FinishedOnTargetDate
)
VALUES ( '' , -- LotID - varchar(40)
'' , -- MaterialName - varchar(30)
'' , -- MaterialVersion - varchar(8)
'' , -- HoldStatus - char(15)
'' , -- QuarantineStatus - char(15)
'2009-06-03 07:21:51' , -- CreateDate - datetime
'2009-06-03 07:21:51' , -- ExpirationDate - datetime
'2009-06-03 07:21:51' , -- ZeroDate - datetime
0.0 , -- PrimaryQty - float
'' , -- PrimaryUOM - varchar(16)
0.0 , -- SecondaryQty - float
'' , -- SecondaryUOM - varchar(16)
'' , -- CustSpecName - varchar(30)
'' , -- CustSpecVersion - varchar(8)
0 , -- Priority - smallint
'2009-06-03 07:21:51' , -- DueDate - datetime
0 , -- LotSuffix - smallint
0 , -- NextSublotIndex - int
0 , -- LastSublotIndex - int
0 , -- LockCount - smallint
'' , -- ProcessOrder - varchar(80)
'' , -- Alias - varchar(80)
'' , -- Status - varchar(80)
'' , -- Locked - varchar(80)
'' , -- Exception - varchar(80)
'' , -- RealLot - varchar(80)
'' , -- ConcessionRaised - varchar(80)
'' , -- ConcessionAuthorised - varchar(80)
'' , -- AuthoriseLevel - varchar(80)
'' , -- FTIC - varchar(80)
'' , -- ReleaseStatus - varchar(80)
'' , -- SlipStream - varchar(5)
'2009-06-03 07:21:51' , -- FinishedOn - datetime
'' , -- FinishedBy - varchar(30)
0 , -- LotZeroException - tinyint
'2009-06-03 07:21:51' -- FinishedOnTargetDate - datetime
)
A big funny I think
first I declared ...
Problem 1
when I typed Insert Into I didn't get a suggestion of @Lots as I would expect in fact no Candidate List at all
Problem 2
Then I typed the Select * from dbo.Lot and "wow" it reacted as if I had selected Insert Into Lot and piled in all the columns and the appropriate values as you expect from the automated Insert Into and I got this .....