Jeff's code is working fine in SQLSERVER & SYBASE (with some small change) . Yes, Instead of '', we have to use Null. As sybase never replace any string with...

Experts,

is there any solution available for "Mass concatenate" in SQL 2008 OR SQL 2012?

Thanks Matt & Jeff.

I have also done some quick simulations to see maximum lengths of strings that can be handled with each value of N. These are the results so...

I have also done some quick simulations to see maximum lengths of strings that can be handled with each value of N. These are the results so far:

N=1 10

N=2 38

N=3...

okay. why don't i use +2 or +3 instead of +1...

i think...Again my requiremtn is wrong..

I just corrected it now...

select ''karthik keyan 44768 ...

bitbucket-25253 (9/24/2012)

---

Your request concerned removing a single space, while Jeff's arcticle's objective was:

This article explains the "puzzle solving" behind a common set based method to replace unknown numbers of adjacent...

LOOP ?

WHILE LOOP ?

Thats what my first thought (using cursor) on this requirement. But...i just wanted to do this without using BAD CURSOR 🙁

There is no way to capture the error message as well as to insert all the rows (except the problematic one) by using TRY CATCH.

Am i correct?

I believe...when we turn this option to ON, we can't capture the duplicate error message in the table. Here i come to conclusion as below.

If the IGNORE_DUP_KEY IS OFF, TRY...

Yes. T table only.

Thats what i need. I would like to to insert...

I don't see any records in the table. 🙁

I have changed my code as below.

ALTER proc [dbo].[p1]

as

begin

DECLARE @ERROR_LOG TABLE

(

ErrorNumber INT,

ErrorSeverity INT,

ErrorState INT,

ErrorProcedure VARCHAR(255),

ErrorLine VARCHAR(255),

ErrorMessage VARCHAR(1000)

)

;

BEGIN TRY

insert into t

select 1

...

i have used the below code

delete from sec_returns

where sec_no in ( select sec_no

from (select sec_no, sum(isnull(ret,0)) from sec_returns group by sec_no having sum(isnull(ret,0)) = 0)z

)

But...i think this may lead to...