storeprocedure
-
select b.MotorClaimID,b.ServiceSectorRID,c.PartDesc ,d.PartSourceType,c.UnitPrice FROM Motorclaim a LEFT JOIN MotorClaimEventStatus b on a.ID =b.MotorclaimID Left JOIN Motorclaimsparts c on b.ID = c.MotorClaimEventStatusID LEFT JOIN MotorClaimSPartSourceType d on d.ID = c.MotorClaimSPartSourceTypeID where b.motorclaimid=4 and b.ServiceSectorRID=72 and b.Supplementary=0 and b.ID=486 here b.Supplementary=0 in (0) place i have to write select TotalItems from MotorClaimsGeneralSummary where motorClaimid=4 and here b.ID=486 in (486) place i have to write select ID ,ServiceSectorRID ,Supplementary from MotorClaimEventStatus where ServiceSectorRID=67 and ID in (select MAX(ID)from MotorClaimEventStatus group by ServiceSectorRID,Supplementary)order by ServiceSectorRID,Supplementary
-
select b.MotorClaimID,b.ServiceSectorRID,c.PartDesc ,d.PartSourceType,c.UnitPrice FROM Motorclaim a LEFT JOIN MotorClaimEventStatus b on a.ID =b.MotorclaimID Left JOIN Motorclaimsparts c on b.ID = c.MotorClaimEventStatusID LEFT JOIN MotorClaimSPartSourceType d on d.ID = c.MotorClaimSPartSourceTypeID where b.motorclaimid=4 and b.ServiceSectorRID=72 and b.Supplementary=0 and b.ID=486 here b.Supplementary=0 in (0) place i have to write select TotalItems from MotorClaimsGeneralSummary where motorClaimid=4 and here b.ID=486 in (486) place i have to write select ID ,ServiceSectorRID ,Supplementary from MotorClaimEventStatus where ServiceSectorRID=67 and ID in (select MAX(ID)from MotorClaimEventStatus group by ServiceSectorRID,Supplementary)order by ServiceSectorRID,Supplementary
-
select b.MotorClaimID,b.ServiceSectorRID,c.PartDesc ,d.PartSourceType,c.UnitPrice FROM Motorclaim a LEFT JOIN MotorClaimEventStatus b on a.ID =b.MotorclaimID Left JOIN Motorclaimsparts c on b.ID = c.MotorClaimEventStatusID LEFT JOIN MotorClaimSPartSourceType d on d.ID = c.MotorClaimSPartSourceTypeID where b.motorclaimid=4 and b.ServiceSectorRID=72 and b.Supplementary=0 and b.ID=486 here b.Supplementary=0 in (0) place i have to write select TotalItems from MotorClaimsGeneralSummary where motorClaimid=4 and here b.ID=486 in (486) place i have to write select ID ,ServiceSectorRID ,Supplementary from MotorClaimEventStatus where ServiceSectorRID=67 and ID in (select MAX(ID)from MotorClaimEventStatus group by ServiceSectorRID,Supplementary)order by ServiceSectorRID,Supplementary
When you do have a question try asking in the correct forum. All you have here is SQL, nothing about LINQ
I know the language. I've read a book. - _Madmatt