asked
Sql query question
I have a table for database growth . The columns are servername, dbname, dbsize, loaddate A job runs weekly that inserts a new row for each servername,dbname with the size for that week. My question is what would be the sql to produce one row for each servername and dbname that includes the sizes for each weeks ? Output should look like servername dbname week1_size week2_size week3_size week4_size Thanks
I'm assuming that Week 4 is this week etc. Select ServerName, dbName, max(Case when datediff(week,LoadDate,GetDate())=3 then dbsize else 0 end) as [Week 1], max(Case when datediff(week,LoadDate,GetDate())=2 then dbsize else 0 end) as [Week 2], max(Case when datediff(week,LoadDate,GetDate())=1 then dbsize else 0 end) as [Week 3], max(Case when datediff(week,LoadDate,GetDate())=0 then dbsize else 0 end) as [Week 4] from YourData Group by ServerName, DBName
12 People are following this question.
