Ya... can't do much about that... My boss bought the software in french.

And I didn't take it personal.

Why do you say that?? I Haven't spoken a word of french since I'm here...

That's why most people use a comma as a delimiter. Looks like you're gonna have to modify your system a little bit to avoid this problem.

this works :

Declare @MyDate as datetime

set @MyDate = null

select isnull(@Mydate, '1900-01-01 00:00:00.000')

can you post the code you run from qa and the code form the udf please?

I preffer Noeld's solution.. Still simple and will work forever without maintenant (with 1-2 modifications).

Just my 0.02 cents.

Select count_big(*) as CountAsBigInt from dbo.SysObjects

Then what.. 12 recordsets???

How about 12 inserts in a temp table then a select form that temp table??

Now how about a single select to return the information to the client...

I would check for deadlock issues, maybe you have transactions that are held too long for nothing and that is causing other process to have to wait for the lock...

Hehe; this is what happens when you post on too many threads Frank. You need your beauty sleep now..

You could use sysdepends but it is notoriously unreliable.. so this would be a start...

Select DISTINCT O.name from dbo.SysComments C inner join dbo.SysObjects O on C.id = O.id and O.XType...

I would personally preffer 1 single statement for that... much less work if you have to change the query.

Check the inserted lines... Once on the server they are all kept as '' (no space). Looks like the where condition is treated the same way (rtrimed). ...

How about something like this :

Select CustomerID, Year, Count(*)

from dbo.HistoryTable

group by CustomerID, Year

having count(*) < 12 or (Year = year(getdate()) and COUNT(*) < Month(Getdate()))

This returns only the...

I've once worked on a similar problem. I had to export the billing information to a text file so it could be imported to a 3rd party software.. Easy...