日报表和月报表,在同一界面上显示怎么做
建表语句
CREATE TABLE [Report_Day] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[ReportDay] [datetime] NULL ,
[city] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[todayAdd] [int] NULL ,
[todayDel] [int] NULL ,
[todayAddDel] [int] NULL ,
[insertdate] [datetime] NULL CONSTRAINT [DF_Report_Day_insertdate] DEFAULT (getdate()),
CONSTRAINT [PK_Report_Day] PRIMARY KEY CLUSTERED
(
[ID]
) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [Report_Month] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[ReportDay] [datetime] NULL ,
[city] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[FeeUser] [int] NULL ,//总数
[MonthAdd] [int] NULL ,
[MonthDell] [int] NULL ,
[insertDate] [datetime] NULL CONSTRAINT [DF_Report_Month_insertDate] DEFAULT (getdate()),
CONSTRAINT [PK_Report_Month] PRIMARY KEY CLUSTERED
(
[ID]
) ON [PRIMARY]
) ON [PRIMARY]
GO
请大家帮忙,