Hi Guys,

This is how I achieved the result.

select a,b, stuff(

(select ', '+level1 from

(select a,b,c+'('+

stuff((select ', '+d from example with (nolock)

where a = x.a and b = x.b and c=x.c...

Thanks everyone.

But Can we achieve the result without cte.

I want to use stuff inside stuff.

And I achieved it guys.

Thanks for supporting me guys..

I have come across this and I felt a little difficulty in doing this. please go through this once.

create table example

( a int null,

b varchar(100) null,

c varchar(100) null,

d varchar(1000) null)

insert...

Can u please help me with this?

Thanks

Gautham

I m using windows 7 and SQL Server 2008 R2.

CREATE TRIGGER transactiontrigger ON ORDERINVOICE

AFTER INSERT

AS

BEGIN

UPDATE A_ACCOUNT

SET A_ACCOUNT.AC_RUNNING_BLC=

(A_ACCOUNT.AC_RUNNING_BLC - INSERTED.NETAMMOUNT + INSERTED.COMMISION - INSERTED.TDS)

FROM A_ACCOUNT INNER JOIN INSERTED ON A_ACCOUNT.A_ID = INSERTED.A_ID

END

GO

John,

Thanks for ur query but I am not getting the exact answer with that.

Let me explain what my query does.

Superset: All _dup table names and column names from information_schema.columns.

Subset :1)All...

_dup tables should have all the columns in main table plus idn column.

But while creating _dup tables, there is a chance I may have forgotten some columns in main tables....