Accessing Column in @TableVariables??????

[rmahawaii]

Hello All, I am having problem accessing a column from the table variable. Can anyone please show me how? Thanks in advance.

declare @TableVar1 table ([chrChangeType] [char] (1),
[chrBeforeIDType] [char] (2))

Insert Into @TableVar1 (chrChangeType, chrBeforeIDType)
Select chrChangeType, chrBeforeIDType
FROM tblcustidchanged

'This is where the error raise'
SELECT @TableVar.chrChangeType
FROM @TableVar1

 

[JamesLean]

On first glance, you are missing a '1':

[tt]SELECT @TableVar1.chrChangeType
FROM @TableVar1[/tt] --James

 

[rmahawaii]

OH..it's a typo here but it still won't work when I typed

SELECT @TableVar1.chrChangeType
FROM @TableVar1

Thanks

 

[JamesLean]

I take it you are creating the variable and selecting from it within the same connection (ie running that script you posted "as is&quot?

If so, what is the error you are getting? --James

 

[rmahawaii]

Server: Msg 170, Level 15, State 1, Line 27
Line 27: Incorrect syntax near '.'.

Thanks

 

[rmahawaii]

Oh I got the answer...cannot use

Table.columnName

only Select columnName From table