![](https://img-blog.csdnimg.cn/20201014180756916.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
T-SQL
文章平均质量分 73
tiandehui1985
Netezza, Teradata, Oracle
展开
-
sum里边不能用子查询(解决方法)
SUM(CASE WHEN B.SalesPerson = C.SalesPersonCode and B.CustomerNumber in select C.CustomerNumber from #D_SaleTeam THEN ISNULL(B.ExtendPrice,0)+ISNULL(D.AMD,0) + ISNULL(D.BUNDLE,0)+ISNULL(D.COMBO,原创 2007-04-11 18:04:00 · 1008 阅读 · 0 评论 -
share meeting
ØSUM(CASE WHEN B.SalesPerson C.SalesPersonCode THEN Quantity ELSE 0 END dbo.F_Invoice_Main_CURRENT B WITH (NOLOCK)) ON A.Item_key = B.ITEMNUMBER_KEY LEFT JOIN #D_SalesTeam C WI原创 2007-04-20 14:56:00 · 536 阅读 · 0 评论 -
物化视图
物化视图—两台服务器之间建立一个数据库的联接:create public database link dblinkname connect to userName using 服务名 identified by PASSWORD; --物化视图更详细的写法CREATE MATERIALIZED VIEW table2ON PREBUILT TABLE --将物化视图转载 2007-09-19 09:43:00 · 301 阅读 · 0 评论 -
T-SQL,表变量、动态T-SQL
USE [AndersenDataWarehouse]GO/****** 对象: StoredProcedure [dbo].[Pro_DispGISInfo] 脚本日期: 03/27/2009 11:06:02 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- ==================================原创 2009-03-27 11:09:00 · 2285 阅读 · 0 评论 -
pivot
USE [jhDW]GO/****** 对象: StoredProcedure [dbo].[Pro_ExecP] 脚本日期: 04/09/2009 09:50:41 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER PROCEDURE [dbo].[Pro_ExecP]AS-- ======================原创 2009-04-09 09:46:00 · 259 阅读 · 0 评论