Hi..!!!
I have two sql 2003 servers, one for production data and one for testing purposes.
The following sentence works perfectly on the production server, but generates and error on the testing server, I think there is a problem in the testing server configuration's, can any one help me...?
Sentence:
INSERT INTO Vacaciones_Hist VALUES ( 'EMPRESA', 3, 2007, 'AV', convert(varchar(10),'2007/01/01',120), '2007-2008', convert(varchar(10),'2007/12/31',120), 16, current_timestamp , current_timestamp ,'TEST')
Table design:
Cia_Id nvarchar 10
Empleado_Id int 4
Ano_Vac int 4
Tipo_Mov nvarchar 50
Fecha_Inicial smalldatetime 4
Periodo_Ano nvarchar 10
Fecha_Final smalldatetime 4
Vac_Valor real 4
Date_Cre smalldatetime 4
Date_Mod smalldatetime 4
User_Id nvarchar 10
thanks for your help...!!