Post reply

SELECT * INTO #t1

  • September 12, 2003 at 7:55 am

    #81045

    Anybody knows why this line fails?

    SELECT MAX([User].[User_ID]) INTO #t1

    Error:

    No column was specified for column 1 of '#t1'.

  • September 12, 2003 at 8:02 am

    #473936

    What about SELECT MAX([User].[User_ID]) as UserID INTO #t1 from [User]

  • September 12, 2003 at 8:09 am

    #473939

    Allen_Cui!

    You must be a T-SQL Guru!!!

    Thanks a lot!

    Works beautiful.

    Robert Opeshanksy

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply