Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Table Design question

Author  Topic 

Netjunkie
Starting Member

17 Posts

Posted - 2014-01-20 : 07:00:05
Hello Folks,

Please help me design the table structure to store a report which comes to me in the below format.



Notice that the Goal and Monthly values for each title have a different data types.
There are several other rows (with same/different types) in the report but I have posted just a few.

Do let me know if you need any further clarification on the issue.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2014-01-20 : 07:02:14
Cant these quantities be derived from some base quantities? ie using hours etc information

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

Netjunkie
Starting Member

17 Posts

Posted - 2014-01-20 : 07:03:50
Unfortunately No.
These values once stored in the database will be the base for deriving other metrics.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2014-01-20 : 07:26:29
Then store all the values in decimal format with scale value of 2 (2 decimal places). then in report apply required formatting to show the values in your desired format.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

Netjunkie
Starting Member

17 Posts

Posted - 2014-01-20 : 23:59:56
The report will still have to look similar to this. How can i apply column level formatting on different types?
Go to Top of Page
   

- Advertisement -