摘要： SELECT callinamount,AVG(n*1.0)OVER(PARTITION BY r)FROM(SELECT callinamount , (RANK() OVER ( ORDER BY callinamount )) r , (ROW_NUMBER() OVER ( ORDER BY callinamount )) nFROM #t) aORDER BY callinamount 阅读全文

摘要： /****** Description: select * from dbo.Split('100,200 300;400',', ;') return value is 4 rows table with values 100,200,300,400. ******/CREATE FUNCTION [dbo].[Split] ( @str AS NVARCHAR(1000) , @delimiters AS NVARCHAR(100) )RETURNS @t TABLE ( pos INT NOT NULL , value NVARCHAR(100) NOT NULL ) 阅读全文

摘要： var ajax = function(){}; var IsUndefined = function(v) { return typeof v == 'undefined' ? true : false; } ajax.CreateXMLHttp = function() { if(window.XMLHttpRequest) ... 阅读全文