VB... and if I remember correctly C# uses + to concatenate. I don't think you can concatenate using operators in other versions of C.

I personally don't have time to write one... So It's gonna have to be somebody else.

This would come from Access (maybe something else that I never used).

If you need a calculated field, maybe you could try :

=Fields!Weight.value & "lbs"

Or you could...

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.