Sending Column Name From SP to C# App

[AmbiguousName]

hello guys... I have this stored proc which gets some values from table but in addition, it calculates some values like %age of result. The question is: how can I send this value WITH a column name like Percantage. Here is the query for stored proc but I dont know what to add

CREATE PROCEDURE [dbo].[GetStudents] AS
SELECT
s.StudentId, s.FirstName,s.SurName,
( ((s.ObtMarks) / (s.TotalMarks)) * 100) --this is the value I want to send with column name

FROM Students s

GROUP BY
s.StudentId, s.FirstName,s.SurName

[hypermellow]

Hi, try giving your calculate column value an alias. Then you can reference it by name in your c# datatable. I've modified (but no tested or ran) your procedure. Hope it helps,

CREATE PROCEDURE [dbo].[GetStudents] AS
SELECT
s.StudentId, s.FirstName,s.SurName,
( ((s.ObtMarks) / (s.TotalMarks)) * 100) AS PercentageValue

FROM Students s

GROUP BY
s.StudentId, s.FirstName,s.SurName

[AmbiguousName]

just put colName = Calculated Value and you are good to go :)

[Karthik Harve]

just change the query like this..

SELECT
s.StudentId, s.FirstName,s.SurName,
( 'Percentage - ' + ((s.ObtMarks) / (s.TotalMarks)) * 100) as 'Percentage'

hope it works..

with regards Karthik Harve

[Luc Pattyn]

can be a useful keyword. :)

Luc Pattyn [My Articles] Nil Volentibus Arduum

[SilimSayo]

Provided you don't misspell it by adding an extra 's' :)