Hi,
if am execute this query am getting first select statement values.
ALTER procedure [dbo].[usp_Fixtures_BowlingAverages_Client]
( @Fixture_SeasonKey int,@Fixture_TeamKey int,@Fixture_FixtureType int)
as
begin
Select (cast(Max(D.Bowling_Wickets)as varchar)+'-'+cast(Min(D.Bowling_Runs)as varchar)) as Bestbowling
From InningsBowlingDetails D
JOIN (Select D.Bowling_MemberKey, Max(D.Bowling_Wickets) as Wickets from...