My pleasure. Did it all work?

You would need to create a VARCHAR (19) column if you want to store it with the style option that you are using. Otherwise store it as DATETIME and retrieve...

You want the date stored this way in the table? If yes, what data type did you define the column as? DATETIME or VARCHAR (19)?

You could do something like this:

INSERT INTO dbo.sssr_database_summary_archive

SELECT

*

,GETDATE () AS report_date

FROM

dbo.#temp_sssr_database_summary

Sure. You would just need to define a table (or tables) for the elements of the report you wish to trend and then add something like the following code right...

Thank you all very much! And I have to agree, anything by Gail Shaw is always superb. Also, BOL is a great resource, and personally I just create different scenarios...

Actually, here's what I've done so far (needs to be uploaded to SSC.com):

Bug Fixes

Enhanced HTML Output

"Index" Ouputs Now Include Indexed Views

Added "instance_name", "product_name", And "server_memory_mb" To "Instance Information" Section

Added "authentication",...

Thanks for sharing! I've actually added some of these so the next version which I will be posting soon. 🙂

Very nice. Thanks for sharing.

The new version's online. 🙂

Neat concept. 🙂

Interesting.

You could also do something like this:

WITH CTE AS

(

SELECT

1 AS number

UNION ALL

SELECT

X.number + 1 AS number

FROM

CTE X

WHERE

X.number + 1 <= 100

)

SELECT

REPLICATE ('|', X.number) + REPLICATE ('.', 100 - X.number)...

For anyone interested, I just submitted a new version of the proc (still awaiting approval from SQL Server Central though...).

Additional output columns added:

Batch_Pct: Percentage of the batch which has been...

Glad you like it. 🙂

Never mind, figured it out. It is checking each portion of text that is being concatenated. Since no one portion needs to be NVARCHAR (MAX) on its own, the highest...