CREATE PROCEDURE [dbo].[GetHistory] 
    @CardID Int,
AS
BEGIN
	SET NOCOUNT ON;

        With DirectReports (EarlyID, LaterID, [Card_ID],level)
        as
        (
            Select HistoryGroupCode, GroupCode, Card_ID, 0 level from proj_CardForm
            where Card_ID = @CardID
            union all
            Select HistoryGroupCode, GroupCode, proj_CardForm.Card_ID, level + 1 from proj_CardForm
            Inner Join DirectReports on proj_CardForm.GroupCode = DirectReports.EarlyID
        )
        Select distinct Card_ID from DirectReports
    end

Select * from GetHistory(1400)