<chart>
<title>Total Credit</title>  
<values>
    <x_value>09.06.2012</x_value>
    <y_value>0</y_value>
  </values>
...
</chart>

drop table dbo.Users

CREATE TABLE dbo.Users(
	[id] [int] NOT NULL PRIMARY KEY ,
	[teamid] [int] NOT NULL DEFAULT 0,
	[countryid] [int] NOT NULL DEFAULT 0,
	[create_time] [int] NOT NULL, -- UNIX TIMESTAMP
	[stats_update_time] [datetime] NOT NULL DEFAULT (getutcdate()-getutcdate()),
	[total_credit] [decimal](28, 2) NOT NULL,
	[expavg_credit] [decimal](28, 2) NOT NULL,
	[credit_day] [decimal](28, 2) NOT NULL DEFAULT 0,
	[credit_week] [decimal](28, 2) NOT NULL DEFAULT 0,
	[credit_month] [decimal](28, 2) NOT NULL DEFAULT 0,
	[project_rank] [int] NOT NULL DEFAULT 0,
	[team_rank] [int] NOT NULL DEFAULT 0,
	[country_rank] [int] NOT NULL DEFAULT 0,
	[project_rank_day] [int] NOT NULL DEFAULT 0,
	[project_rank_week] [int] NOT NULL DEFAULT 0,
	[project_rank_month] [int] NOT NULL DEFAULT 0,
	[team_rank_day] [int] NOT NULL DEFAULT 0,
	[team_rank_week] [int] NOT NULL DEFAULT 0,
	[team_rank_month] [int] NOT NULL DEFAULT 0,
	[country_rank_day] [int] NOT NULL DEFAULT 0,
	[country_rank_week] [int] NOT NULL DEFAULT 0,
	[country_rank_month] [int] NOT NULL DEFAULT 0,
	[cpid] [varchar](32) NOT NULL,
	[expavg_time] [decimal](28, 2) NOT NULL,
	 [varchar](254) NULL,
	[name] [nvarchar](80) NOT NULL,

-- графики --
	[total_credit_xml] [varchar](1000) NULL,
	[expavg_credit_xml] [varchar](1000) NULL,
	[credit_day_xml] [varchar](1000) NULL,
	[credit_week_xml] [varchar](1000) NULL,
	[credit_month_xml] [varchar](1000) NULL,
	[project_rank_xml] [varchar](1000) NULL,
	[project_rank_day_xml] [varchar](1000) NULL,
	[project_rank_week_xml] [varchar](1000) NULL,
	[project_rank_month_xml] [varchar](1000) NULL,
	[team_rank_xml] [varchar](1000) NULL,
	[team_rank_day_xml] [varchar](1000) NULL,
	[team_rank_week_xml] [varchar](1000) NULL,
	[team_rank_month_xml] [varchar](1000) NULL,
	[country_rank_xml] [varchar](1000) NULL,
	[country_rank_day_xml] [varchar](1000) NULL,
	[country_rank_week_xml] [varchar](1000) NULL,
	[country_rank_month_xml] [varchar](1000) NULL
	)

-- for aspx page ~/stats/UserStats.aspx

ALTER PROCEDURE [dbo].[GetUsers]
	@page_index int

AS
    SET NOCOUNT ON
    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

declare @pr_name varchar(50)
select @pr_name=pr_name from Project

declare @start_rank int
set @start_rank = @page_index*100

SELECT top(100)
@pr_name as pr_name,
u.project_rank,
u.id,
u.teamid,
u.cpid,
u.project_rank_month, 
u.project_rank_week, 
u.project_rank_day, 
u.[name],
u.total_credit,
u.credit_day,
u.credit_week,
u.credit_month,
FLOOR(ROUND(u.expavg_credit,0)) as expavg_credit,
t.name as team_name,
t.cpid as team_cpid,
c.id as countryid,
c.name as country,
c.flag
FROM Users u
left outer join Countries c on (u.countryid=c.id)
left outer join Teams t on (u.teamid=t.id)

where u.project_rank>@start_rank
order by u.project_rank

Table UserXml
(
-- идентификатор участника
id int, 
-- его графики
total_credit_xml varchar(1000),
expavg_credit_xml varchar(1000),
credit_day_xml varchar(1000),
...
)

CREATE TABLE dbo.Users(
> -- графики --
> [total_credit_xml] [varchar](1000) NULL,

	INSERT Users(
		id,
		teamid,
		countryid,
		name,
		create_time,
		stats_update_time,
		total_credit,
		....
		)
	SELECT
		@id,
		@teamid,
		@countryid,
		@name,
		@create_time,
		@stats_update_time,
		@total_credit,
		....