Is the following possible within a Stored Procedure

Question

Is the following possible within a Stored Procedure

Viewing 5 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply

Byron Rode SSC Rookie Points: 37 More actions · Answer 1

Thanks alot, that works, but it fills every row with that statement, which isn't exactly what i want. I'll explain...

I want it only to mark the person who has requested the query as the marker. I have tried moving the cast statement to inside the CTE, but because that where clause is date based, it still fills every row with the requesters name.

Any ideas, otherwise I will just stick to doing that with ASP.

Johan Bijnens SSC Guru Points: 135583 More actions · Answer 2

So you mean that requester is blanc if it is note equal to alias ?

;with cteMPVAliasByRank (Ranking, Alias, Country, Yearmonth, PrizeAmount)

as (select ROW_NUMBER() over (order by PrizeAmount desc) , Alias, Country, Yearmonth, PrizeAmount

from #tblMPVLeaderBoard where Yearmonth = @CurrentMonth )

SELECT M.*, cast(case Alias when @PlayerAlias then Alias else ' ' end as varchar(50) ) as Requester

FROM cteMPVAliasByRank M

INNER JOIN cteMPVAliasByRank PA

ON PA.Alias = @PlayerAlias

AND M.Ranking BETWEEN PA.Ranking - 3 AND PA.Ranking + 3 ;

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data and code to get the best help

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

Byron Rode SSC Rookie Points: 37 More actions · Answer 3

that is exactly what I was trying to do... Thanks for all the help. Just one thing though, you need to prefix the cast columns with M. otherwise it gives a "ambiguous column" error.