Yeaahhhh

I found the solution 😀

I just added those options in my script

SET CONCAT_NULL_YIELDS_NULL ON

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

I still without know why it work in windows 2003 but not work...

I made other test. I ran a simple query with intersting result.

.

* SQL Server 2000

* Server 1:

windows 2003

ODBCD Driver: sql server

2000.86.3959.00

sqlsrv32.dll

17/02/2077

* Server 2:

windows 2008

ODBCD Driver: sql server

6.01.7601.17514

sqlsrv32.dll

20/11/2010

* Connection string used...

Thanks SQLRNNR for respond.

I did in this way because I expect a NULL value the first time. It´s for debug.

The second query to run (first I mentioned ) get all...

declare @sIni varchar(10)

set @sIni = '1/01/2010'

Thanks LutzM, but that code don't work. Maybe is because I'm using SQL 2000. However I resolved it with this query

select h.holo , h2.holo as...

Thanks LutzM, Michael and Jeff.

After check both solutions I thought that must use TallyTable because the numbers that I need are from 80,000,000 to 89,999,999.

But I really not need...