Thanks!

For Project_Item 1.1.A I was thinking to use float.

The data is sample is in bracket (Milestone #1), (1. A Nat System Must Be band at the Community Level)

(A. Develop Protect-Prep Comm), (1.1.A ) and you are saying varchar??

I know I am sorry to provide the insufficient information. All I know is this document has 1000 records and I have to break it down into about 10 tables...

Thanks Ninja for your help as well and sorry to bother you.

Hi hydbadros,

I'm not sure how you would like to calculate the growth from your table, but here is an example of how it can be done, where I have tried...

Thanks for your help and I will let you know if I get the correct result.

I tried all the options and nothing is working.Here is the store procedure that I am using to capture the information. I need a script to generate the monthly growth...

I gave up- I am not getting any friendly reply...

Thank you very much! It worked...

I am sorry for the confusion. I used the following script and I am getting this error with only one database information is displaying instead 6 database including systems db's.

,ISNULL((select...

Ninja,

I am sorry I did not see your query? Which one is your's?

Ok so for the following script how would you change in whole;

,ISNULL((select B.[UsedSpace(MB)]

from [TESTDB].[dbo].DB_USAGE B

where B.[SQLName] = a.[SQLName]

and B.[DBName] = a.[DBName]

and DATEPART(yyyy, B.[ExecuteTime]) = DATEPART(yyyy, DATEADD(mm, -3, a.[ExecuteTime]))

and DATEPART(MM, B.[ExecuteTime])...

Can some one please help me. I need to have this script ready by end of this month.

How about this statement? we were deviding by 3 to get the quarterly data.

and DATEPART(MM, B.[ExecuteTime]) = DATEPART(MM, DATEADD(mm, -3, a.[ExecuteTime]))),0)/3.0 AS Data_Usage_Growth