yes i know, i see that but its a lot of code i have to change, the best for now is that, i didn't use the yyyymmdd format in the...

ok conclusion, i make it work by changing the language of the user used for the asp connection, in this case, user ''alex"

i put it to english, and the system...

AND HOW I PUT THEM IN THE SAME DOMAIN, ITS TO DIFICULT? YOU THINK THAT'S THE PROBLEM??

well publisher is in an local network in an office, suscriber its on my home, i made the suscription via (VPN) the two servers are in the same NETWORK GROUP

ok here are the cofigurations:

Suscriptor:

SQL Server Reporting Services = LocalSystem

SQL Server Integration Services = LocalSystem

SQL Server Browser = NT AUTHORITY\LOCAL SERVICE

SQL Server Analysis Services = LocalSystem

SQL Server Agent = LocalSystem

SQL...

it's runing in the LocalSystem account, i think is the same that NT AUTHORITY\System. but it say its LocalSystem

Domain account? you mean the MACHINE\User account? could be more especific please. and why i cant with sa account?

i look this error in the log:

Date16/02/2010 01:00:28 a.m.

LogSQL Server (Current - 16/02/2010 01:01:00 p.m.)

SourceLogon

Message

Error: 18456, Severity: 14, State: 38.

and this error too:

Date16/02/2010 01:00:28 a.m.

LogSQL Server (Current - 16/02/2010 01:01:00...

OK MAN IT FINALY WORKS LIKE THIS: 😀

USE ordenesSQL

SELECT [IDCLIENTE], [NOMBRECLIENTE], [PESOS] AS PESOS, [DOLARES] AS DOLARES

FROM

(SELECT [IDCLIENTE], [NOMBRECLIENTE], [MONEDA], SUM([CANTIDAD]*[PRECIO1]) AS TOTAL

FROM [ORDENES] WHERE [IDCLIENTE] IN(51,651)...

OK IT WORKS THIS WAY THANKS A LOT MAN:

USE ordenesSQL

SELECT [NOMBRECLIENTE], [PESOS] AS PESOS, [DOLARES] AS DOLARES

FROM

(SELECT [NOMBRECLIENTE], [MONEDA], [PRECIO1]

FROM [ORDENES] WHERE [IDCLIENTE] IN(51,651) AND [FECHANUEVA] BETWEEN '20091231' AND...

well is clear what you mean, now im going to find how to do a loop in the table to get the each row cause im new on this, i...

No one?

i see this example please confirm =( im here waiting for an answer but please with real SQL code, i don't know how to put TABLE.COLUM in sql server y...

ohhh yes! it works now! now i cant set the columns to not null,i just fill the null records as you said! thanks a lot, i will be here looking...

OK I UNDERSTAD YOUR POINT, BUT FOR EXAMPLE I CHECK THE EXISTING COLUMN NAMED "TRABAJO" WITH THIS:

SELECT * FROM ORDENES WHERE TRABAJO = NULL

AND I HAVE NO RESULTS, THAT...