declare @a as table (id int,name varchar(10), age int, city varchar(10), country varchar(10))

insert into @a(id,name,age,city,country)

select 100,'cat',21,'london','england'

union

select 101,'dog',22,'london','england'

union

select 102,'mouse',23,'london','england'

union

select 103,'rat',24,'london','england'

declare

Yes, both have same roles.

yes satatus is int.

the value should be status 1 and what ever the out will be it should be of status 1.

sorry , there is a little correction: the below table will have cropid instead of date.

create table amountdifference( cropid int, productid int,amtdiff float)

...

Thanks Mays, SS

Cheers 🙂

I want to make a view from the query . will this CTE works for view.?

For those of you who have not understood my question. In one line , I have to do a data migration and have to find the child who have multiple...

create table #abc(insertid int,cityid int,parentcityid int,cityname varchar(50),parentname varchar(50))

insert into #abc

select 1,10,11,'A','B'

union

select 1,11,12,'B','C'

union

select 1,12,13,'C','D'

union

select 2,10,11,'A','B'

union

select 2,11,13,'B','D'

union

select 2,12,11,'C','A'

Output:

Insertid Cityid Parentid ...

I m testing in excel as well as changing user account in browsing cube. I am using my account in office and i am checking all this on a remote...

no they have same roles.

yup sure,

there is a rid , nid and name and total.

i want to get total for previous rid but for same nid.

ie. if

rid nid ...

yup it worked.. tks puffy

Actually I am doing this in a script and i am doing this for 50 procedures and each procedure is more then 50 lines. So, dynamic query will not be...

But i have one more..

the data shows to final column

101

102

103

but i tried to change some part but i m not getting same data but with one extra row which...

Thank a lot .