I am certanly not a SSIS expert so I can't give you more details. Others on this forum might provide better help on that. But as far as I know...

Here is the corrected statement:

SET @StartDate = convert(VARCHAR(10), getdate(), 101)

+ ' ' + (CAST(DATEPART(hh, (SELECT [Value] FROM tbltime WHERE NAME='TIME')) AS VARCHAR)

+ ':' + CAST(DATEPART(mi, (SELECT [Value] FROM tbltime WHERE...

You didn't seperate the date and time part with a space. And in the last part of your query you are using the "DATEPART(ss,...)" twice and you are also not...

That's new to me. Thanks, I learned something 😉

If you want logging of the startup and shutdown time of an instance, consider the following:

You can setup another server/instance and poll the connectivity to the required instance(s) every minute...

To write data when the instance is started you can create a job with a schedule to be executed "Start automatically when SQL Agent starts". Maybe you should include some...

They say 'there are no dumb questions'. At least you learned from it 😀

Glad you found the answer yourself.

Yes, that...

What is the error message you get when...

In my opinion the easiest solution will be to create the report with two seperated tablixes, each holding a different resultset.

If you have good control over the insert statements you could issue a RESEED command after the first insert.

DBCC CHECKIDENT ("{tablename}", RESEED, 0);

Or create a table with IDENTITY(1,1) and use...

A truncate will reset the IDENTITY values to the initial settings. Reinserting the data after a truncate will again use the...

You are absolutely right, but without...

Yes, you need to know all columns and define your query accordingly.

But WHY do you want to display two completely different resultsets into one single resultset?

You are not to be improving a table, but you need to improve the queries accessing that table. A table can be optimized by the options Koen has mentioned. But...