Thanks a lot 😉

I should have known too ... Wasted so much time on digging wrong direction 🙂

:w00t::-D:-D bingo !!!!!!!!! you r the BEST... where do I hail you as such? there is no corresponding EmotIcon to show my exhilaration ...... :hehe::-D:hehe::smooooth:

Hi stewartc-708166,

Apparently you were right about NULLs.

I hope you'll have time to review my stubbornSP. You'd notice that it is aggregate function that makes all the difference. When the stored...

Hi again,

I finally got to the bottom of this problem. I didn't think it would be SP's problem, since it is executing without an error on the server it resides...

The sp has a lot of proprietary code, so I can’t post it as is.

When I tried to simplify it to fake it’s content based on some temp tables...

thanks a lot "stewartc-708166" and spasibo "Eugene Elutin"...

but still no go.

Stored procedure treating somehow differently a NULL value... What do you mean?

The stored procedure has following declarations:

ALTER procedure stubbornSP

...

Hi Alex,

Could you please post here that function of yours that calcs biz day going into the past 🙂

Hi Andy,

I've got this error while trying to OPENDATASOURCE:

"Msg 7403, Level 16, State 1, Line 1

The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered."

Where do I register it?

Thanks

truly sorry for making you angry ... I just couldn't paste real servers and db names (sensitive), besides it wouldn't help anyway ..

yes, Sir ...

I have same schema, lets say [dbo], in each of the 25 databases that reside on 5 different servers...

The table name is identical too ... as well...

:unsure:

As I mentioned already, I see [brackets] instead of 'single quotes' in WHERE clause ... but I did try already:

DECLARE @SQLstr nvarchar(800),

@myVar int,

@server varchar(20),

@database varchar(20),

@myName varchar(20)

set

thanks for taking a look at it 🙂

my problem is just that....

select @SQLstr

produces almost exact line:

SELECT @myVarOUT =someValue FROM [server].[database].[dbo].

WHERE someName = [@myName]

just @myName is [bracketed] insted of...