sql query lo doubt

[htnamus]

[quote author=John Galt link=topic=234947.msg2923483#msg2923483 date=1315513249]
Insert to select endi..em cheyalani ne badha aa 2nd query lo  sCo_^Y sCo_^Y sCo_^Y
[/quote]temp table loki main table nundi data push cheyali  H&T@ H&T@

[The QUEEN]

[quote author=HS link=topic=234947.msg2923469#msg2923469 date=1315513131]
[img]http://www.desigifs.com/sites/default/files/brahmam_style4.gif?1290348957[/img]evaro okallu cheffandi
[/quote]  LoL.1q

[Jack Sparrow]

[img]http://th298.photobucket.com/albums/mm249/MIZUNO18/th_6816_chicken-little-dancing.gif[/img]

[krldr871]

[quote author=HS link=topic=234947.msg2923495#msg2923495 date=1315513359]
temp table loki main table nundi data push cheyali  H&T@ H&T@
[/quote]
ala vachindi vachinattu toseyyochaa sql lo..naku peddaga idea ledu anduke adugutunna..
temp variables lo store chesukuni daanitho insert rayi malli

[galigannarao]

achinda leda sCo_^Y sCo_^Y

[mettastar]

[quote author=HS link=topic=234947.msg2923495#msg2923495 date=1315513359]
temp table loki main table nundi data push cheyali  H&T@ H&T@
[/quote]
idi cheyyi baa
nenu Oracle lo inthe chestha

Create table TEMP_TABLENAME as Select * from MAIN_TABLENAME

[htnamus]

[quote author=mettastar link=topic=234947.msg2923493#msg2923493 date=1315513332]
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
[/quote]
create table #TABLENAME as Select cust_circuit_num,order_compl_date from CIRCUIT_ORDER
select * from #TABLENAME


Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'as'.

[galigannarao]

[quote author=John Galt link=topic=234947.msg2923505#msg2923505 date=1315513440]
ala vachindi vachinattu toseyyochaa sql lo..naku peddaga idea ledu anduke adugutunna..
temp variables lo store chesukuni daanitho insert rayi malli
[/quote]yaa baa we can do that. directga select query nundi insert cheseyochu.but the column names should be equal

[htnamus]

[quote author=galigannarao link=topic=234947.msg2923507#msg2923507 date=1315513450]
achinda leda sCo_^Y sCo_^Y
[/quote][img]http://www.desigifs.com/sites/default/files/Untitled1.gif?1290145100[/img]

[The QUEEN]

[quote author=The QUEEN link=topic=234947.msg2923478#msg2923478 date=1315513198]
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
[/quote] sorry2 c&p chesa, only column names not with datatypes

Insert into mytemptable(CustomerCircuitnum, Requested DueDate, OrderMarkedCompleted)
select cust_circ uit_num, in_servic e_request _date, order_compl_date from CIRCUIT_ORDER

[krldr871]

[quote author=galigannarao link=topic=234947.msg2923514#msg2923514 date=1315513497]
yaa baa we can do that. directga select query nundi insert cheseyochu.but the column names should be equal
[/quote]
#4H# #4H# #4H# ok..nerchukovali databases..stanford class lu follow ayipothaa october nunchi  H&T@ H&T@ H&T@

[galigannarao]

(SELECT [name], title, company, photo, [Last] into #temp
    FROM EuropeBroadcastList
    ORDER BY Last ASC);

if you are using table variables in stord procdure,

declare @europebroadcastsorted table

(

name its datatype

  title its datatype

  compant its datatype

photo its datatype

last its datatype

)

insert into    @europebroadcastsorted

(SELECT [name], title, company, photo, [Last]
    FROM EuropeBroadcastList
    ORDER BY Last ASC);

[nenuinthe]

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

try it

[mettastar]

[quote author=HS link=topic=234947.msg2923511#msg2923511 date=1315513493]
create table #TABLENAME as Select cust_circuit_num,order_compl_date from CIRCUIT_ORDER
select * from #TABLENAME


Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'as'.
[/quote]
idokkate raayi

create table #TABLENAME as Select cust_circ uit_num,order_compl_date from CIRCUIT_O RDER

[galigannarao]

[quote author=John Galt link=topic=234947.msg2923522#msg2923522 date=1315513573]
#4H# #4H# #4H# ok..nerchukovali databases..stanford class lu follow ayipothaa october nunchi  H&T@ H&T@ H&T@
[/quote]nenu Artificial Intelligence  H&T@ H&T@ H&T@