I agree.

Timeout is an optional syntax of WAITFOR TSQL command

I think so.

Timeout option is not directly related with WAITFOR TSQL is an optional part.

The best way could be send the date in ANSI format: yyyy-mm-dd

The use of UDF is great but... (always there is a BUT), when you use UDF in large tables the performance of queries would be "slow down". Remember: Computed columns via...

Thanks mdaniel,

Let me try.  I'm almost sure that's the solution.

Bye

Yes!... you right

Ok... add a new attribute with the day of the date and index it.

I think the WHERE is more complex than that (is only a part of the...

No errors are displayed.

About what are you talking when you write "proxy account", i think is the same permissions if you call the webservice from browser or from cmd shell...

Hi,

You can check using this qry:

USE yourDatabase

select * from sysobjects where name = 'yourTable'

Hello from Guatemala,

Ricardo

Easy...

declare @YY as varchar(4), @mm as varchar(2)

set @YY = '2000'

set @mm = '12'

select col1, col2, datecol, ...

from tablename

where DAY(datecol) between 1 and DAY(DATEADD(Month, 1, CONVERT(DATETIME, @YY...

Very funny, is almost a true history.

All of us sometimes happend one of this issues.

Hello from Guatemala,

Ricardo