SQL to Data Feed

I have a MSSQL 2008 database, and i need to create either an XML or JSON feed from a query. Nothing complex just 8 x pairs of data (value, label) What is the easiest way to do this? Can i do it directly from SQL or do i need a script in-between?
MoogControlsAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
jonnidipConnect With a Mentor Commented:
MSSQL 2008 has a "for xml" clause that can be used to return xml from query statements.
You may look for info at: http://msdn.microsoft.com/en-us/library/ms178107.aspx

Regards.
0
 
MoogControlsAuthor Commented:
Note: the feed will be used to populate a geckoboard dashboard.
0
 
mcnuteConnect With a Mentor Commented:
with php, you can do just a simple
json_encode($yourresultarray)

Open in new window

to send json to the requesting page. Assumed to be the geckoboard.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.