sql query lo doubt

[htnamus]

[quote author=Dookudu link=topic=234947.msg2923560#msg2923560 date=1315513847]
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
[/quote]Msg 2715, Level 16, State 7, Line 1
Column, parameter, or variable #2: Cannot find data type date.

[The QUEEN]

[quote author=HS link=topic=234947.msg2923559#msg2923559 date=1315513839]

create table #temptable(CustomerCircuitnum int,RequestedueDate date,OrderMarkedCompleted date) 
Insert into #mytemptable(CustomerCircuitnum ,RequestedueDate,OrderMarkedCompleted)
select cust_circuit_num, in_service_request_date, order_compl_date from CIRCUIT_ORDER



Msg 2715, Level 16, State 7, Line 1
Column, parameter, or variable #2: Cannot find data type date.

[img]http://www.desigifs.com/sites/default/files/bemmi1.gif?1290061581[/img]
[/quote] #mytemptable and #temptable datatypes check cheyi  ^G#W

[nenuinthe]

[quote author=HS link=topic=234947.msg2923559#msg2923559 date=1315513839]

create table #temptable(CustomerCircuitnum int,RequestedueDate date,OrderMarkedCompleted date) 
Insert into #mytemptable(CustomerCircuitnum ,RequestedueDate,OrderMarkedCompleted)
select cust_circuit_num, in_service_request_date, order_compl_date from CIRCUIT_ORDER



Msg 2715, Level 16, State 7, Line 1
Column, parameter, or variable #2: Cannot find data type date.

[img]http://www.desigifs.com/sites/default/files/bemmi1.gif?1290061581[/img]
[/quote]select statement lo unna columns lo date datatypes ena in_service_request_date, order_compl_date e rendu columns....

[galigannarao]

[quote author=John Galt link=topic=234947.msg2923557#msg2923557 date=1315513832]
@gr33d @gr33d @gr33d  AI lite kani..machine learning and databases important baa..pedda companies ki machine learning chala important..and databases okataina ravali..so nerchukunta  :0012391: :0012391: :0012391:
[/quote]good baa.nenu already DB ni oka rakamga pindetta  @3$% @3$%

[mettastar]

[quote author=HS link=topic=234947.msg2923559#msg2923559 date=1315513839]

create table #temptable(CustomerCircuitnum int,RequestedueDate date,OrderMarkedCompleted date) 
Insert into #mytemptable(CustomerCircuitnum ,RequestedueDate,OrderMarkedCompleted)
select cust_circuit_num, in_service_request_date, order_compl_date from CIRCUIT_ORDER



Msg 2715, Level 16, State 7, Line 1
Column, parameter, or variable #2: Cannot find data type date.

[img]http://www.desigifs.com/sites/default/files/bemmi1.gif?1290061581[/img]
[/quote]
+_( +_(
[quote author=mettastar link=topic=234947.msg2923543#msg2923543 date=1315513732]
In MS SQL Server

SELECT *
INTO new_table_name
FROM old_table_name
[/quote]

[htnamus]

[quote author=The QUEEN link=topic=234947.msg2923577#msg2923577 date=1315513963]
#mytemptable and #temptable datatypes check cheyi  ^G#W
[/quote]
erro baga pattau ..kaani create table #temptable(CustomerCircuitnum int,RequestedueDate date,OrderMarkedCompleted date) 
[quote author=Jeedeelu link=topic=234947.msg2923569#msg2923569 date=1315513907]
braces kuda teeseyi...


Insert  #mytemptable
select
cust_circ uit_num,
in_servic e_request _date,
order_compl_date
from CIRCUIT_ORDER
[/quote]

[C Nation]

[quote author=HS link=topic=234947.msg2923559#msg2923559 date=1315513839]

create table #temptable(CustomerCircuitnum int,RequestedueDate date,OrderMarkedCompleted date) 
Insert into #mytemptable(CustomerCircuitnum ,RequestedueDate,OrderMarkedCompleted)
select cust_circuit_num, in_service_request_date, order_compl_date from CIRCUIT_ORDER



Msg 2715, Level 16, State 7, Line 1
Column, parameter, or variable #2: Cannot find data type date.

[img]http://www.desigifs.com/sites/default/files/bemmi1.gif?1290061581[/img]
[/quote]
sql lo date type undadhu. use datetime

[ramzzz]

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

[mettastar]

[quote author=HS link=topic=234947.msg2923586#msg2923586 date=1315514029]
erro baga pattau ..kaani create table #temptable(CustomerCircuitnum int,RequestedueDate date,OrderMarkedCompleted date)
[/quote]
Create the temporary table using the DDL of primary table dude
and then  use this

Select * into TEMP_TBL FROM ORG_TBL

[htnamus]

[quote author=BEZAWADA ROWDY link=topic=234947.msg2923579#msg2923579 date=1315513985]
select statement lo unna columns lo date datatypes ena in_service_request_date, order_compl_date e rendu columns....
[/quote][quote author=Dookudu link=topic=234947.msg2923594#msg2923594 date=1315514077]
sql lo date type undadhu. use datetime
[/quote] you rock you rock you rock

CREATE TABLE #mytemptable3(CustomerCircuitnum varchar, RequestedDueDate datetime,OrderMarkedCompleted datetime)

Insert into #mytemptable3
select cust_circuit_num,in_service_request_date,order_compl_date from CIRCUIT_ORDER

Msg 8152, Level 16, State 14, Line 4
String or binary data would be truncated.
The statement has been terminated.


sSa_j@il sSa_j@il sSa_j@il tittukokandi

[galigannarao]

[quote author=mettastar link=topic=234947.msg2923604#msg2923604 date=1315514175]
Create the temporary table using the DDL of primary table dude
and then  use this

Select * into TEMP_TBL FROM ORG_TBL
[/quote]1932lo cheppa baa. adi suste kada aadu @3$% @3$%

[htnamus]

[quote author=mettastar link=topic=234947.msg2923604#msg2923604 date=1315514175]
Create the temporary table using the [b]DDL [/b]of primary table dude
and then  use this

Select * into TEMP_TBL FROM ORG_TBL
[/quote][img]http://www.desigifs.com/sites/default/files/brahmam_style18_0.gif?1290369075[/img]

[galigannarao]

[quote author=HS link=topic=234947.msg2923607#msg2923607 date=1315514209]
you rock you rock you rock

CREATE TABLE #mytemptable3(CustomerCircuitnum varchar, RequestedDueDate datetime,OrderMarkedCompleted datetime)

Insert into #mytemptable3
select cust_circuit_num,in_service_request_date,order_compl_date from CIRCUIT_ORDER

Msg 8152, Level 16, State 14, Line 4
String or binary data would be truncated.
The statement has been terminated.


sSa_j@il sSa_j@il sSa_j@il tittukokandi
[/quote]
+_( +_( +_( +_( +_( +_( +_( +_( +_( +_( +_(
[quote author=galigannarao link=topic=234947.msg2923524#msg2923524 date=1315513585]
(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);
[/quote]

[Ranga_The_Donga]

[quote author=HS link=topic=234947.msg2923586#msg2923586 date=1315514029]
erro baga pattau ..kaani create table #temptable(CustomerCircuitnum int,RequestedueDate date,OrderMarkedCompleted date)
[/quote]

create table #temptable(
CustomerCircuitnum  int,
RequestedueDate datetime,
OrderMarkedCompleted datetime)

Insert  #mytemptable
select
cust_circ uit_num,
in_servic e_request _date,
order_com pl_date
from CIRCUIT_O RDER

[htnamus]

[img]http://www.desigifs.com/sites/default/files/98da8m.gif?1290232586[/img]meeru seffindi tyfe seyatam taffa naku 0 knowledge