#cross apply

TSQL – Splitting a list of integers

[bs url=http://sqlblog.com/blogs/aaron_bertrand/archive/2010/07/07/splitting-a-list-of-integers-another-roundup.aspx]

CREATE FUNCTION dbo.SplitInts_RBAR_1 ( @List VARCHAR(MAX), @Delimiter CHAR(1) ) RETURNS @Items TABLE ( Item INT ) AS BEGIN DECLARE @Item VARCHAR(12), @Pos INT; WHILE LEN(@List)>0 BEGIN SET @Pos = CHARINDEX(@Delimiter, @List); IF @Pos = 0 SET @Pos = LEN(@List)+1; SET @Item =…

SQL Server – Disk Usage Monitoring

[bs url=http://social.technet.microsoft.com/wiki/contents/articles/3214.monitoring-disk-usage.aspx] (more…)