Istill don't have a SQL Server 2005, I am using SQL 2000.

What I need to do is apply the next queries to the recordset, so seding one record will not help

Query1:

select noEmple,count(noEmple) N

from tboclineas

where nocliente=150 and noOrden=4

group by nocliente,noOrden, noemple

having count(noEmple)>1

Query2:

select...

This is the SP

CREATE PROCEDURE spRepxRangoFecha

 @fechaIni varchar (10),

 @fechaFin varchar (10),

 @where varchar(150)

AS

set nocount on

Set quoted_identifier On

declare @SQL varchar(2000)

declare @err int

declare @Result varchar (50)

--set @fechaIni = '05/31/2006'     --2006-05-31

--set @fechafin...

I read in http://support.microsoft.com/kb/830466/en-us that was a bug and will be correct if I use the SP4, but that solution did not works, so I will do what you said...

Thanks!

Today we are lauching a new proyect and yesterday we erase one table that is the one that have the nomEmple information, but we were so nervous that we didn't...

Yes I am using 2000, thank you for you help.

I do the next change, and I get and error:

Server: Msg 170, Level 15, State 1, Line 5

Line 5: Incorrect syntax near '('.

What I am doing wrong?

declare @n as int

set...

Thanks!

It works!!

Thanks !

I have long time with out uses the substring so I was thinking that the sintaxis was like mid$() function in VB.

Thanks!

Gracias!

Thank you so much!

Hi!

I have a meeting today and they change the requirements, the server will support 3 applications instead of 1 and will storage 1 year of transactions.

How many users total will...

Thank you so much!

We are going to save the last 6 months like 5,040,000 transaccions.

The person that do the Pos ask me the next information:

Server Model, Number of disk and capaticy , Memory, Ram

Is there...

How many users total will have access? 40 users

-What is the peak load you anticipate?  28,000 transaccion per day

-What are the historical data storage and reporting requirements?

We...