SQL查询问题，请帮助_未分类的问答_编程通用

大家好，


create table #leave 

( 

        LeaveId INT IDENTITY(1,1) 

        ,EmployeeId INT 

        ,FromDate Datetime 

        ,ToDate Datetime 

        ,[Status] VARCHAR(50) 

) 

 

insert into #leave values(1,'2011-10-25','2011-10-27','Approved') 

insert into #leave values(2,'2011-10-26','2011-10-27','Approved') 

insert into #leave values(3,'2011-10-27','2011-10-27','Rejected') 

insert into #leave values(1,'2011-11-01','2011-10-01','Approved') 

 

 

select * from #leave

任何人都可以提出我的查询返回这样的表
{C}也diplayed FROMDATE和TODATE之间的日期与雇员和状态
预先感谢

回答

评论会员：游客时间：2012/02/07

KARTHIKHarve:尝试用这些查询..codeprelang="sql"spanclass="code-keyword"create/spanspanclass="code-keyword"table/span#leave(LeaveIdspanclass="code-keyword"INT/spanspanclass="code-keyword"IDENTITY/span(spanclass="code-digit"1/span,spanclass="code-digit"1/span),EmployeeIdspanclass="code-keyword"INT/span,FromDatespanclass="code-keyword"Datetime/span,ToDatespanclass="code-keyword"Datetime/span,[Status]spanclass="code-keyword"VARCHAR/span(spanclass="code-digit"50/span)) spanclass="code-keyword"insert/spanspanclass="code-keyword"into/span#leavespanclass="code-keyword"values/span(spanclass="code-digit"1/span,spanclass="code-string"'/spanspanclass="code-string"2011-10-25'/span,spanclass="code-string"'/spanspanclass="code-string"2011-10-27'/span,spanclass="code-string"'/spanspanclass="code-string"Approved'/span)spanclass="code-keyword"insert/spanspanclass="code-keyword"into/span#leavespanclass="code-keyword"values/span(spanclass="code-digit"2/span,spanclass="code-string"'/spanspanclass="code-string"2011-10-26'/span,spanclass="code-string"'/spanspanclass="code-string"2011-10-27'/span,spanclass="code-string"'/spanspanclass="code-string"Approved'/span)spanclass="code-keyword"insert/spanspanclass="code-keyword"into/span#leavespanclass="code-keyword"values/span(spanclass="code-digit"3/span,spanclass="code-string"'/spanspanclass="code-string"2011-10-27'/span,spanclass="code-string"'/spanspanclass="code-string"2011-10-27'/span,spanclass="code-string"'/spanspanclass="code-string"Rejected'/span)spanclass="code-keyword"insert/spanspanclass="code-keyword"into/span#leavespanclass="code-keyword"values/span(spanclass="code-digit"1/span,spanclass="code-string"'/spanspanclass="code-string"2011-11-01'/span,spanclass="code-string"'/spanspanclass="code-string"2011-10-01'/span,spanclass="code-string"'/spanspanclass="code-string"Approved'/span) spanclass="code-keyword"select/span*spanclass="code-keyword"from/span#leave spanclass="code-keyword"IF/spanOBJECT_ID(spanclass="code-string"'/spanspanclass="code-string"#sample'/span)spanclass="code-keyword"IS/spanspanclass="code-keyword"NOT/spanspanclass="code-keyword"NULL/spanspanclass="code-keyword"DROP/spanspanclass="code-keyword"TABLE/span#samplespanclass="code-keyword"SELECT/span*spanclass="code-keyword"INTO/span#samplespanclass="code-keyword"FROM/span#leavespanclass="code-keyword"WHERE/span1=2 spanclass="code-keyword"DECLARE/span@LeaveIDspanclass="code-keyword"int/span,@EmpIDspanclass="code-keyword"int/spanspanclass="code-keyword"DECLARE/span@StDatespanclass="code-keyword"DATETIME/span,@EndDatespanclass="code-keyword"DATETIME/spanspanclass="code-keyword"DECLARE/span@statusspanclass="code-keyword"varchar/span(spanclass="code-digit"50/span)spanclass="code-keyword"DECLARE/spancurspanclass="code-keyword"CURSOR/spanspanclass="code-keyword"FOR/spanspanclass="code-keyword"SELECT/span*spanclass="code-keyword"FROM/span#leavespanclass="code-keyword"OPEN/spancurspanclass="code-keyword"FETCH/spanspanclass="code-keyword"FROM/spancurspanclass="code-keyword"INTO/span@LeaveID,@EmpID,@StDate,@EndDate,@statusspanclass="code-keyword"PRINT/span@EndDatespanclass="code-keyword"WHILE/span(@@FETCH_STATUS=spanclass="code-digit"0/span)spanclass="code-keyword"BEGIN/spanspanclass="code-keyword"WHILE/span(@StDate<=@EndDate)spanclass="code-keyword"BEGIN/spanspanclass="code-keyword"INSERT/spanspanclass="code-keyword"INTO/span#sample(EmployeeId,FromDate,[Status])spanclass="code-keyword"VALUES/span(@EmpID,@StDate,@status)spanclass="code-keyword"SET/span@StDate=DATEADD(DD,spanclass="code-digit"1/span,@StDate)spanclass="code-keyword"END/spanspanclass="code-keyword"FETCH/spanspanclass="code-keyword"FROM/spancurspanclass="code-keyword"INTO/span@LeaveID,@EmpID,@StDate,@EndDate,@statusspanclass="code-keyword"END/spanspanclass="code-keyword"CLOSE/spancur spanclass="code-keyword"SELECT/spanEmployeeId,FromDatespanclass="code-keyword"as/spanspanclass="code-string"'/spanspanclass="code-string"Date'/span,[Status]spanclass="code-keyword"FROM/span#sample/pre/code希望它的作品....:阿米尔Mahfoozi
这里是:

{体C3}
CTE的{S0的}魔法感谢

也原谅我不便命名的风格。

祝你好运。Selvapk

评论会员：游客时间：2012/02/07

{的C4}这将显示您需要的结果
dinidusoft123:您好

{C5的} 如果这有助于...不要犹豫，以纪念它......