Table Variables

Hi

A big funny I think

first I declared ...

DECLARE @Lots TABLE
&#40;
LotID varchar&#40;20&#41;
&#41;

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
&#40;LotID&#41;
SELECT * FROM dbo.Lot
        &#40; 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
        &#41;
VALUES  &#40; '' , -- LotID - varchar&#40;40&#41;
          '' , -- MaterialName - varchar&#40;30&#41;
          '' , -- MaterialVersion - varchar&#40;8&#41;
          '' , -- HoldStatus - char&#40;15&#41;
          '' , -- QuarantineStatus - char&#40;15&#41;
          '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&#40;16&#41;
          0.0 , -- SecondaryQty - float
          '' , -- SecondaryUOM - varchar&#40;16&#41;
          '' , -- CustSpecName - varchar&#40;30&#41;
          '' , -- CustSpecVersion - varchar&#40;8&#41;
          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&#40;80&#41;
          '' , -- Alias - varchar&#40;80&#41;
          '' , -- Status - varchar&#40;80&#41;
          '' , -- Locked - varchar&#40;80&#41;
          '' , -- Exception - varchar&#40;80&#41;
          '' , -- RealLot - varchar&#40;80&#41;
          '' , -- ConcessionRaised - varchar&#40;80&#41;
          '' , -- ConcessionAuthorised - varchar&#40;80&#41;
          '' , -- AuthoriseLevel - varchar&#40;80&#41;
          '' , -- FTIC - varchar&#40;80&#41;
          '' , -- ReleaseStatus - varchar&#40;80&#41;
          '' , -- SlipStream - varchar&#40;5&#41;
          '2009-06-03 07:21:51' , -- FinishedOn - datetime
          '' , -- FinishedBy - varchar&#40;30&#41;
          0 , -- LotZeroException - tinyint
          '2009-06-03 07:21:51'  -- FinishedOnTargetDate - datetime
        &#41;

MikeONeill June 03, 2009 03:32

Comments

1 comment

Hi,

Oops...sorry about the bug (Problem 2)
But it is a good catch! We will have this sorted for the RC.

Problem 1 - Temporary tables are not yet implemented and that is the reason you don't see support for it. However, this will be done for the release.

Thank you for taking the time to report the issue.

Regards,
Tanya
Project Manager
Red Gate Software Ltd

tanya June 03, 2009 04:00

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Table Variables

Comments

Add comment