نوشته شده توسط
رامین مرادی
سلام اینو تست کنید ببینید جواب میده
خیلی ضایع نوشتم فقط
;with cte1 as( select Date , Vadeh,BakhshId from TblRejimDayes where BakhshId=12)
,cte2 as(select *,ROW_NUMBER() OVER (PARTITION BY BakhshId ORDER BY Date Desc ) AS rn from cte1)
,cte3 as (select * from cte2 where cte2.rn=1)
,cte4 as (select *,ROW_NUMBER() OVER (PARTITION BY BakhshId ORDER BY Vadeh Desc ) AS rn from cte3)
select * from cte4 where cte4.rn=1
ممنون از توجهتون.
به اینصورت اصلاح کردم ولی بازهم خطا میده. راستش اینجور کد تاحالا ندیدم . اصلا متوجه مفهومش نمیشم!!
cmd.CommandText = " cte1 as(select Date, Vadeh, BakhshId from TblRejimDayes where BakhshId= @BakhshId) with , " +
"cte2 as(select *,ROW_NUMBER() OVER(PARTITION BY BakhshId ORDER BY Date Desc) AS rn from cte1), cte3 as (select * from cte2 where cte2.rn = 1),"+
"cte4 as (select *,ROW_NUMBER() OVER(PARTITION BY BakhshId ORDER BY Vadeh Desc) AS rn from cte3), select* from cte4 where cte4.rn = 1";