No, you can't with table variables. You can do it with temp tables.

Take the time to read this[/url] article on the topic. I found it excellent.

Regards

Gianluca

Don't know if it's the same issue, but this happened to me and maybe could help you:

I had a SQLServer 2005 EE x64 with OLEDB driver (x64) for AS400:...

Looks very strange...

Can you post a sample of the overlapped job history records?

There's no built-in system stored procedure or any kind of object that displays sys.messages.

I think you will have to access it directly.

Regards

Gianluca

I've never seen two instances of a job running overlapped, but this doesn't mean it's impossibile.

What does msdb.dbo.sp_help_jobhistory return? Same results as SSMS?

Another way to get it in a single result set:

select top 0 *

into #files

from sysfiles

EXEC sp_msforeachdb 'insert into #files select * from ?.dbo.sysfiles'

select * from #files

drop table #files

sp_msForEachdb 'USE ?

EXEC sp_helpfile'

It's not exactly what you were asking, but it goes very close, I think.

I think almost everywhere in the world is quite reasonable compared to Venice. London excluded, obviously!

We were on our honeymoon...

Oh, I see... This is the main problem! 😀

The place is smashing!!! Anyway it looks a bit too expensive for my budget... 🙁

Well, I know where I'm...

... it works from my office too!!!

Do you thinks it's a problem...

mazzz (6/10/2009)

---

Gianluca,

Whereabouts are you based? I'm recently back after spending a lovely 3 weeks in Northern Italy - Rome, Siena, Pisa, Florence, Montespertoli FI and Venice. I've left some of...

GilaMonster (6/10/2009)

---

Some think it's a massive waste of money that could be better spent on health, education and job creation (which are all massive problems).

Some think that there's going to...

Looks like I did not understand what you need.

If...

This changes things a bit. Try this way:

SELECT ...