Click here to Skip to main content
14,384,332 members
Rate this:
Please Sign up or sign in to vote.
See more:
How to this query convert to linq queries?


select top 100 percent a,b,c,d,ROW_NUMBER() over(PARTITION BY a,b order by a,b) as NUMBER FROM TABLEA AS TA group by a,b,c,d
INSERT INTO TABLEB (a,b,f,q,u,p)
select klm.a,klm.b,klm.t,1,1,1
from klm ,(select a,b,ceiling((count(*) + x + )
group by (a,b) GRP
where klm.a=GRP.a and
klm.b=GRP.b

What I have tried:

var x= from tablesa in TABLEA
select a,b,c,d //but dont write percent and after query.
Posted
Updated 10-Nov-19 5:54am
v4

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100