Hi Tommy,

thank you very much, it works perfectly.

now i remember why i use a cursor:

I execute the select CONVERT(datetime, FechaRecepcion, 103)

from Ejemplares

where ISDATE(FechaRecepcion) = 1

but then apear and error:

Mens. 241, Nivel 16, Estado 1, Línea...

Hi, thank for your help ^^

alter PROCEDURE spTotalCompraIdiomaLibroDina @Idioma varchar(20), @año varchar(10)

AS

BEGIN

DECLARE @Some_Sql VARCHAR(8000)

SET @Some_Sql =

...

select L.Titulo, count(*) as NumeroPrestamos

from Servicios S, Ejemplares E, Libros L, Colecciones C

where E.CodigoAcceso = S.CodigoAcceso

and E.IDLibro = L.IDLibro

and E.IDColeccion = C.IDColeccion

and C.Coleccion = 'General'

and S.FechaPrestamo between '2005-01-01' and...

thank you rbarryyoung, it works for me too

i need to do that over and over again.

thanks for all the help..

i have solute my problem now

bcp {[[database_name.][owner].]{table_name | view_name} | "query"}

{in | out | queryout | format} data_file

[-mmax_errors]...