I have a table like below
| RecordID(P) | Question_Value | COuntry | Year |
| 1 | 23 | PAK | 2011 |
| 2 | 12 | AUS | 2010 |
| 3 | 67 | Srilanka | 2010 |
| 4 | 24 | Newzland | 2012 |
I want to make a select Query which return two things and Taking one parameters I want to give year as parameters and then show
Question_Value , and Country and Year
and i want so show that graph
it must take parameter as year
Upendra Pratap ShahiPosted Sep 8, 2015, 3:12 AM
CREATE PROCEDURE usp_GetQuestionValueNCountry
@year int,
@QuestionValue int Output
@Country varchar(50) Output
AS
BEGIN
SELECT @QuestionValue = Question_Value, @Country = COuntry
FROM Table_Name
WHERE Year = @year
END
Shashank PatilPosted Sep 8, 2015, 3:00 AM
@year int,
@QuestionValue int Output
@Country varchar(25) Output
AS
BEGIN
SELECT @QuestionValue = Question_Value, @Country = COuntry
FROM Table_Name
WHERE Year = @year
END