主頁 > 知識庫 > 在sql查詢中使用表變量

在sql查詢中使用表變量

熱門標簽:電銷外呼有錄音系統(tǒng)有哪些 鎮(zhèn)江網(wǎng)路外呼系統(tǒng)供應商 申請400電話在哪辦理流程 貴州房產(chǎn)智能外呼系統(tǒng)供應商 小e電話機器人 一個導航軟件能用幾個地圖標注點 外呼運營商線路收費 臨沂智能電銷機器人加盟哪家好 百度地圖標注改顏色
復制代碼 代碼如下:

USE [DAF_DB]
GO
/****** Object: StoredProcedure [dbo].[PROG_WORKTASK_List] Script Date: 06/14/2010 21:14:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

--[PROG_WORKTASK_List] 62,0,'','',0,0,'',''

-- =============================================
-- Author: guo.lin
-- Create date: 2010-03-10
-- Description: 獲取工作任務單列表,根據(jù)相關條件
-- =============================================
ALTER PROCEDURE [dbo].[PROG_WORKTASK_List]
@userID varchar(10), ---當前用戶
@status int, ---狀態(tài)
@Leader varchar(30),
@Facilitators varchar(30),
@Level int ,
@Priority int,
@CloseDT varchar(30),
@CreatedBy varchar(30)

AS
BEGIN
declare @result table(
taskid int,
TaskName nvarchar(100),
TaskTopic nvarchar(100),
Level varchar(10),
Priority varchar(10),
Status varchar(10),
Leader varchar(100),
strLeader nvarchar(500),
Facilitators varchar(100),
cycletime varchar(10),
CloseDT datetime,
Createddt datetime,
CreatedBy varchar(30)
)

insert into @result select taskid,TaskName,TaskTopic,Level,Priority,Status,Leader,strLeader,Facilitators,cycletime,CloseDT,Createddt,CreatedBy
from Work_TaskProcess where createdby=@CreatedBy or leader like '%|'+@userid+'|%' or Facilitators like '%|'+@userid+'|%'

if (@status >0)
delete @result where status>@status
if (@Leader>'')
delete @result where leader not like '%|'+@Leader+'|%'
-- if (@CreatedBy>'')
-- delete @result where CreatedBy>@CreatedBy
if (@Level > 0)
delete @result where level>@level
if (@Priority > 0)
delete @result where Priority>@Priority
if (@CloseDT>'')
delete @result where CloseDT>@CloseDT

update @result set status=b.itemtext from @result a,DAF_Item b where a.Status=b.itemvalue and b.itemtype='worktaskStatus'
update @result set Level=b.itemtext from @result a,DAF_Item b where a.Level=b.itemvalue and b.itemtype='worktaskLevel'
update @result set Priority=b.itemtext from @result a,DAF_Item b where a.Priority=b.itemvalue and b.itemtype='worktaskPriority'
update @result set createdby=b.username from @result a, DAF_useraccount b where a.createdBy=b.userid
update @result set cycletime=cycletime+'天'


select taskid,TaskName,TaskTopic,Level,Priority,Status,strLeader,Facilitators,cycletime,CloseDT,Createddt,CreatedBy from @result order by Createddt desc

END

標簽:合肥 澳門 日照 三明 嘉興 保定 延邊 晉城

巨人網(wǎng)絡通訊聲明:本文標題《在sql查詢中使用表變量》,本文關鍵詞  在,sql,查詢,中,使用,表,;如發(fā)現(xiàn)本文內(nèi)容存在版權(quán)問題,煩請?zhí)峁┫嚓P信息告之我們,我們將及時溝通與處理。本站內(nèi)容系統(tǒng)采集于網(wǎng)絡,涉及言論、版權(quán)與本站無關。
  • 相關文章
  • 下面列出與本文章《在sql查詢中使用表變量》相關的同類信息!
  • 本頁收集關于在sql查詢中使用表變量的相關信息資訊供網(wǎng)民參考!
  • 推薦文章