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...

hi,

its returning first select statement values.

means if u changed the positions of select statements then also its displays

select stmt values means which one first the values r getting...

Hi,

thanks for reply.

still it displays first select statement values. here is my code....

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...

i want to display this format

0-0

2-2

2-2

0-3

2-45

5-49