您好,对于sql语句这块儿我们也不是很了解,不过我在网上找了很多资料,经过不断的测试最终实现了这个需求。下面给您提供了sql语句和相关的学习资料,您可以参考参考- create view 待办事项 as
- with cte as (
- Select FGC_AssignTo,FGC_State,'请假表'as tablename,cast(id as varchar)+''+'请假表' as key1,id as 原表ID from 请假
- union all
- select FGC_AssignTo,FGC_State,'报销表' as tablename,cast(id as varchar)+''+'报销表' as key1,id as 原表ID from 报销
- )
- select TOP (100) PERCENT * from(
- select
- (select count(*) from cte b where a.key1 >= b.key1) as ID,
- tablename as 目标表,
- FGC_AssignTo,
- FGC_State as 状态,
- 原表ID
- from cte as a ) t
- order by t.ID
复制代码
如果有多个表的时候替换即可
- select FGC_AssignTo,FGC_State,'表名' as tablename,cast(id as varchar)+''+'表名' as key1,id as 原表ID from 表名
复制代码 sqlserver教程
相关的sql语句教程
|