How to create "Select Into" statement in MS SQL server 2008

Question

Hi Guys,

Thank for the answer. I manage to found an alternative:

Declare @V_CLOSEDT int
SET @V_CLOSEDT = (SELECT MAX(CLOSE_DATE) FROM CLOSEDATE)

This works too.

Regards,
Ultraseven

Answer 1

Decalre @V_CLOSEDT  Datetime

SELECT @V_CLOSEDT =MAX(CLOSE_DATE) INTO FROM CLOSEDATE;

Answer 2

this is simple in sql server

try this


declare @V_CLOSEDT int --variable declaration

SELECT @V_CLOSEDT  = MAX(CLOSE_DATE)  FROM CLOSEDATE;

select @V_CLOSEDT 

Answer 3

Hi Guys,

Thank for the answer. I manage to found an alternative:

Declare @V_CLOSEDT int
SET @V_CLOSEDT = (SELECT MAX(CLOSE_DATE) FROM CLOSEDATE)

This works too.

Regards,
Ultraseven