Chris Morris-439714 (10/21/2010)

There's a trick for that...put them in then

REPLACE(',' + EmpName...

And i must admit that my code is purely what the DelimitedSplit8K (function from Jeff Moden on splitting delimited strings) does!! So toss ur credits to Jeff Moden and the...

And i presume your EmpName does not have trailin/leading commas.. Else we will have to use another method.

Here is my version, which is 80% based on Chris' logic of using a tally table 🙂

;WITH Tens(N) AS

(

SELECT 1 UNION ALL

...

here is one : http://www.sqlservercentral.com/Forums/Topic943562-338-1.aspx#bm944589

Am hunting down Paul White CLR.. will update soon...

Wayne, in ur solution, you are basing your order over ckid column (Sequence = ROW_NUMBER() OVER (ORDER BY ckid) )

What if ckid is not in a proper order ?...

Wayne is one...

I did not quite get your full requirement, 'cuz of the fact that, you did not

1. Provide sample data to work with

2. Give a clear visual example of your desired...

Malavika, i suggested a solution using REPLACE... that will remove the repeated data leaving only the data you require.. if there are multiple values to be replace, you can use...

If u insist in SUBSTRING funtion, then take a look at this:

SELECT

RTRIM ( LTRIM ( REPLACE (ColA, 'Microsoft SQL Server','') ) ) TrimmedString_ReplaceFn,

...

You can do something like:

SELECT RTRIM ( LTRIM ( REPLACE (ColA, 'Microsoft SQL Server','') ) ) TrimmedString

FROM

(

SELECT 'Microsoft SQL Server 2005' UNION ALL

SELECT...

😀 rofl :w00t:

Try this :

DECLARE @Tab TABLE

(

kunnr INT,

zterm VARCHAR(15),

cnt INT

)

INSERT INTO @Tab ( kunnr , zterm , cnt )

...

Congrats Steve, Brian and Andy!! THis site is an awesome resource... i never took SQL seriously until i had a requirement which i posted in SSC and got help from...

There is something called "ROW_NUMBER" .. Please refer Books Online (free help that comes with SQL Server) to learn about Row_NUMBER...