Declare @SubtaskId Int
Declare @DesLength IntSelect
A.Id,
A.SubtaskId,
A.OriginalOrder,
(Case When @DesLength>Len([Description]) Then A.[Description]+Left(B.[Description],@DesLength-Len([Description])) Else Left(A.[Description],@DesLength) End) As [Description],
A.EffectivityRate,
B.OriginalOrder
From CAction A
Inner Join SubCAction B
On A.Id=B.CActionId
Order By EffectivityRate DESC, OriginalOrder ASC
Declare @DesLength Int
Set @SubtaskId=1
Set @DesLength=10
Select
A.Id,
A.SubtaskId,
A.OriginalOrder,
(Case When @DesLength>Len([Description]) Then A.[Description]+Left(B.[Description],@DesLength-Len([Description])) Else Left(A.[Description],@DesLength) End) As [Description],
A.EffectivityRate,
B.OriginalOrder
From CAction A
Inner Join SubCAction B
On A.Id=B.CActionId
Where SubtaskId=@SubtaskId
Order By EffectivityRate DESC, OriginalOrder ASC