Tag Info

New answers tagged


This might help you to create simple dynamic query for partitioned tables using COALESCE function of SQL Server Step1: Create function to split tokens CREATE FUNCTION [dbo].[fnSplit] ( @List VARCHAR(8000), @Delimiter CHAR(1) = ',' ) RETURNS @Temp1 TABLE ( ItemId INT IDENTITY(1, 1) NOT NULL PRIMARY KEY, Item VARCHAR(8000) NULL ) AS BEGIN DECLARE @item ...

Top 50 recent answers are included