Indeed Hardy21 it works, I also tried with:

select * from tempdb..sysobjects where name like '#testvm'

and...

Thanks for the explanation vk-kirov and mtassin.

Regards,

Iulian

The question is challenging and asks for more attention on details when reading, this is not one of my main strengths.

I read the documentation, was lucky to find here:

...

Thanks a lot Hugo

Iulian

One innocent remark that does not minimize the high value of the question. I am thinking to drop tbl1 and tb2 tables at the end of the script:

DROP TABLE tbl1

DROP...

Great point. Amazing, the compiler see two creations of the #tmpID table and stops the procedure from compiling.

Do you have at hand some best practices for using DML statements?...

Great question, thank you.

I answered wrong by assuming there is no place for compressing bit fields more than it already does, in this case to one byte, I should have...

Thank you UMG, undeed great statistics.

Looking at the alternative with nested select I tend to chose the GROUP OVER, it seems to me more elegant.

Regards,

Iulian

Nice one Andrew. I can hardy wait to test it.

Regards,

Iulan

Nice question, thank you.

It works for me.

Iulian

Great question, thanks

Here is a reference to the compound operators: http://msdn.microsoft.com/en-us/library/cc645922.aspx

Regards,

Iulian

Sounds good.

I would like to make some exercises on this regard.

What do I need?

Thanks

Iulian

Hi Raunak, Great idea with this forum

For the beginning:

what is the difference/relationship between Business Intelligence and Business Analytics?

Thanks,

Iulian

I found this query by googleing and it works, I have got the inventory of the reports.

USE ReportServer

SELECT

CatalogParent.Name ParentName,

Catalog.Name ReportName,

ReportCreatedByUsers.UserName ReportCreatedByUserName,

Catalog.CreationDate ReportCreationDate,

ReportModifiedByUsers.UserName ReportModifiedByUserName,

Catalog.ModifiedDate ReportModifiedDate,

CountExecution.CountStart TotalExecutions,

ExecutionLog.InstanceName LastExecutedInstanceName,

ExecutionLog.UserName LastExecutedUserName,

ExecutionLog.Format LastExecutedFormat,

ExecutionLog.TimeStart LastExecutedTimeStart,

ExecutionLog.TimeEnd LastExecutedTimeEnd,

ExecutionLog.TimeDataRetrieval...

Hi, Did you tried to restore the database from the backup?

Regards,

Iulian