ERROR SELECT INTO

21/04/2009 - 02:17 por Rene | Informe spam
Please your help!
I have a select
Select distinct IDENTITY(int, 1,1) AS ID_Num, *
into table_tmp
from table_log
order by date_log

But not create table in order expect by date_Log but create table in another
order. Someone helpme for create table with order I want (date_log).
After I make select:
select * from table_tmp order by ID_Num

No ordering by date_log
;(

Help me
 

Leer las respuestas

#1 Carlos Sacristan
21/04/2009 - 11:36 | Informe spam
Please, this is a spanish newsgroup, so you should write in spanish...
anyway, take a look at http://support.microsoft.com/kb/273586.

"Caminar sobre el agua y desarrollar software a partir de unas
especificaciones es fácil. si ambas están congeladas."
Edward V. Berard, ingeniero informático

http://blogs.solidq.com/es/elrincondeldba

"Rene" escribió en el mensaje
news:
Please your help!
I have a select
Select distinct IDENTITY(int, 1,1) AS ID_Num, *
into table_tmp
from table_log
order by date_log

But not create table in order expect by date_Log but create table in
another
order. Someone helpme for create table with order I want (date_log).
After I make select:
select * from table_tmp order by ID_Num

No ordering by date_log
;(

Help me

Preguntas similares