我现在写一个存储过程，建了一个临时表，存数据库中按要求遍历数据，当天没有该关键字的信息的时候，我需要在临时表也是添加一条数据，但是此时的数据量为零，不知道哪位大侠能够指导一下，下面是我写的存储过程
ALTER PROCEDURE [dbo].[sp_Statistics_KeyWordInfo_GetKeyDailyWordInfoByProjectIdAndBetweenCatchTime]
@ProjectID CHAR(36)
,@StartCatchTime DATETIME
,@EndCatchTime DATETIME
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
DECLARE @KeyWordInfo TABLE
(
KeyWord NVARCHAR(1000)
,JustInfoCount INT
,NegInfoCount INT
,MidInfoCount INT
,UnknownInfoCount INT
,CatchTime DATETIME
)
DECLARE @InfoCount TABLE
(
KeyWord NVARCHAR(1000)
,InfoCount INT
,CatchTime DATETIME
)
DECLARE @KeyWord TABLE
(
KeyWord NVARCHAR(1000)
)
DECLARE @CatchTime TABLE
(
CatchTime DATETIME
)
INSERT INTO @KeyWordInfo
(
KeyWord
,JustInfoCount
,NegInfoCount
,MidInfoCount
,UnknownInfoCount
,CatchTime
)
SELECT KeyWord,JustInfoCount,NegInfoCount,MidInfoCount,UnKnownInfoCount,CatchTime
FROM [dbo].[Statistics_KeyWordInfo]
WHERE ProjectID = @ProjectID AND CONVERT(VARCHAR(10),CatchTime,120) BETWEEN CONVERT(VARCHAR(10),@StartCatchTime,120) AND CONVERT(VARCHAR(10),@EndCatchTime,120)
INSERT INTO @KeyWord
(
KeyWord
)
SELECT KeyWord
FROM @KeyWordInfo
GROUP BY KeyWord
INSERT INTO @CatchTime
(
CatchTime
)
SELECT CatchTime
FROM @KeyWordInfo
GROUP BY CatchTime
SELECT kwi.KeyWord,JustInfoCount+NegInfoCount+MidInfoCount+UnknownInfoCount,kwi.CatchTime
FROM @KeyWordInfo kwi,@KeyWord kw,@CatchTime ct
WHERE kwi.KeyWord = kw.KeyWord AND kwi.CatchTime = ct.CatchTime
SELECT *
FROM @InfoCount
ORDER BY KeyWord,CatchTime DESC
END
现在的情况是我只能获取数据库中存在的数据！！！
------解决方案--------------------
关键字一个表,日期一个表,然后交叉连接,再去判断是否存在.
insert into tb1(关键字字段,日期字段 , 数量字段)
select m.关键字字段 , n.日期字段 , 0 from
关键字表 m, 日期表 n
where not exists(select 1 from tb1 where tb1.关键字字段 = m.关键字字段 and tb1.日期字段 = n.日期字段)