*laughs* It seems Ramesh and I were working on the same solution at the same time. 😀

You can get around this by changing the way you test for NULL. By using "IS NULL" you'll get the desired results.

I can't speak to the "WHY" the other didn't...

It works with 2005

This works GREAT !!!

http://sqldigger.bdsweb.be/

Sure, there are a ton of them.

Do search on amazon.com

I'm sure there's a better way, but this will get you what you're looking for ....

SELECT *

FROM LINK_T1 T1 LEFT OUTER JOIN T2 ON

CAST(T1.id AS varchar) = SUBSTRING(T2.id, 2, 9)...

Yes it is, but there's far more to it than a quick post to the forums.

But something like this should get you started.

Private Sub yourSubroutine()

...

Post your SPs code and we may be able to help more.

Sorry everybody, but dewa's already said it's in Simple mode. :crying:

SORRY dewa_himatif_sf but I've got to sign out for the night. I hope you find the help you need.

I'll check back into this post tomorrow.

You NEED to restore the last backup of the DB to a server. This will at MINIMUM, allow...

It would help if you could post the procedures code. It's hard to understand what is causing the timeout without it.

But you didn't answer my question...

when was the last backup made of the database?

and a few others ...

what's the recovery model of the DB?

is the DB in use...

Well, at least I can go to sleep knowing I wasn't losing my mind, and honestly I think I need to do that now 🙂 ... Sleep, not lose my...

OK, I'll help as much as possible.

It sounds like you need/want immediate help. If so, do you have MSN Messenger or something of that sort?

If not, you'll need to watch/refresh...