Finally i found the solution, here u go,

Select 1 [Id],1000[value] into TempA

Select 2[Id], 10 value, 1 parent into TempB

Insert into TempB

Select 3,9,1

union all

select 4,5,1

Select * From TempA;

Select * From TempB;

Select...

WITH CTE_BSI(ID, VAL)

AS

(

SELECT ID, VALUE FROM TempA AS A

UNION ALL

SELECT t.ID,(c.val - value) FROM TempB T join CTE_BSI C on T.parent = c.Id

)

SELECT ID, VAL FROM CTE_BSI

Hey thanx for your suggestion, i already tried that and got the output 🙂 🙂

Hi Frnd,

Ya ok fine 🙂

Dear Frnd,

You can achieve ur requirement through the following way,

Declare @S varchar(100)

Set @S = 'Subbu,Subbiah'

select * from employee WHERE namess in ( ...

Hi Kingston Dhasian,

Ya ofcourse i agree with you, But i was just telling and it was not in a rude manner. If he read my...

Hi WayneS ,

Please read my complete post and reply back.I am asking how Chris Morris got 1319 in that datediff function, other than that u hav explained...

Hi ,

Can u explain the logic behind that. I acheieved the same the same tink using another query to. But i am eager to know ur logic.

First u...

Hi ,

I too faced tat problem and tis s hw , i solved out.

Open Row_Fetch

Fetch Next From Row_Fetch into @Type, @DispName, @TName, @oc

WHILE @@Fetch_Status=0

BEGIN

SELECT...

Select * From #temp t1 Where

(2-1) = (Select Count(Distinct(t2.empWage)) From #temp t2 Where

t2.empWage > t1.empWage)

The innery query will return a refernce to the current row.

Genreal...

Hi Dear frnds,

Sry for wastin ur precious time, its working perfectly. As i updated the same value in A coloumn, so i tot, trigger is nt getting called. Sry...

Hi Frnds,

Thansx For All Ur Support

SELECT * INTO #insertedval FROM INSERTED

create table #temp (value varchar(100))

declare @heat varchar(100)

select @sql = 'insert into #temp select ' +@OC+ ' from #insertedval'

exec...

Kingston Dhasian (9/6/2010)

---

subbusa2050 (9/6/2010)

---

Ya ofcourse, as i said i need to fire the trigger wthen the opportunitybase table is inserted. So wats ur point ? ?

I need to get...

Bhuvnesh (9/6/2010)

---

'select' + @oc...

Ya ofcourse, as i said i need to fire the trigger wthen the opportunitybase table is inserted. So wats ur point ? ?

I need to get the INSERTED VALUES...