sql query lo doubt

[htnamus]

CREATE TABLE #mytemptable(CustomerCircuitnum int, RequestedDueDate date,OrderMarkedCompleted date)

Insert into #mytemptable(select cust_circuit_num,
      in_service_request_date,order_compl_date from CIRCUIT_ORDER)



Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'select'.
Msg 102, Level 15, State 1, Line 3
Incorrect syntax near ')'.
CITI#H@ CITI#H@

[Ka NTR i]

remove the brackets


Insert into #mytemptable
select cust_circ uit_num,
      in_servic e_request _date,order_compl_date from CIRCUIT_O RDER


Assuming its an Oracle DB

[htnamus]

[img]http://www.desigifs.com/sites/default/files/brahmam_style16.gif?1290348878[/img]

[htnamus]

[quote author=BlueBerry link=topic=234947.msg2923430#msg2923430 date=1315512839]
remove the brackets


Insert into #mytemptable
select cust_circ uit_num,
      in_servic e_request _date,order_compl_date from CIRCUIT_O RDER


Assuming its an Oracle DB
[/quote] cry@fl cry@fl rale ba ..oracle kadu ..sql

[Bondu_Babu]

CITI#H@ CITI#H@ CITI#H@ CITI#H@ CITI#H@ CITI#H@

[htnamus]

Insert into #mytemptable(CustomerCircuitnum,RequestedDueDate,OrderMarkedCompleted) values (select cust_circuit_num,
      in_service_request_date,order_compl_date from CIRCUIT_ORDER)
  Select * from #mytemptable

aina rale cry@fl cry@fl cry@fl

[htnamus]

[quote author=HS link=topic=234947.msg2923451#msg2923451 date=1315513023]
Insert into #mytemptable(CustomerCircuitnum,RequestedDueDate,OrderMarkedCompleted) values (select cust_circuit_num,
      in_service_request_date,order_compl_date from CIRCUIT_ORDER)
  Select * from #mytemptable

aina rale cry@fl cry@fl cry@fl
[/quote] *7*^ *7*^ idi boothu anukunta  CITI#H@ CITI#H@

[ToughGuy]

CITI#H@ CITI#H@ CITI#H@ CITI#H@ CITI#H@ CITI#H@

[htnamus]

[img]http://www.desigifs.com/sites/default/files/brahmam_style4.gif?1290348957[/img]evaro okallu cheffandi

[taadu.....bongaram]

insert chesina taruvata from table ivvama  sCo_^Y

idi try cheyyi


CREATE TABLE #mytemptable(CustomerC ircuitnum int, Requested DueDate date,OrderMarkedCompleted date)

Insert into #mytemptable  [color=red][b]from[/b][/color] (select cust_circ uit_num,
      in_servic e_request _date,order_compl_date from CIRCUIT_O RDER)

[Picha lite]

CITI#H@

[The QUEEN]

Insert into mytemptable(CustomerCircuitnum int, Requested DueDate date, OrderMarkedCompleted date)
select cust_circ uit_num, in_servic e_request _date, order_compl_date from CIRCUIT_ORDER  sSa_j@il

#mytemptable  sCo_^Y sCo_^Y # symbol table name lo vundaa  sCo_^Y

[krldr871]

Insert to select endi..em cheyalani ne badha aa 2nd query lo  sCo_^Y sCo_^Y sCo_^Y

[Aavakaaya Biryaani]

call bezawada rowdy.. senior most sql side.. kummestaadu....

[mettastar]

or else you can do this

create table TABLENAME as Select A,B,C from EMP

idi oracle lo aithe pani chesthadi not sure about MS SQL Server