Avatar of BeginningWebDesign
BeginningWebDesign

asked on 

Change data layout

Hi
Can anyone modify the code below, so that it returns the following:

PollQuestionText returned once

PollYesText  PollYesValue
PollNoText PollNoValue

Current Output
Are you a good programmer | Yes | 0 | No | 1

Output would be:
Are you a good programmer
Yes 0
No   1

I need it to display in a radiobuttonlist that has 2 option
George
SELECT PollQuestionText AS PollQuestionText,
		   PollYesText AS PollYesText,
		   PollYesValue AS PollYesValue,
		   PollNoText AS PollNoText,
		   PollNoValue AS PollNoValue
	FROM dbo.Website_Polls

Open in new window

Microsoft SQL Server 2005Microsoft SQL Server 2008

Avatar of undefined
Last Comment
BeginningWebDesign

8/22/2022 - Mon