billy_111 — 2011-03-02T06:30:04-05:00 — #1
I have an issue, i am selecting something in SQL Server which gives me a value of this:
web_Day_3_Windsor (Boxing Day)
This is an example of the type of query i am using:
SELECT Name as name
FOR XML PATH('item')
Now what i wanted to know is that if there is a way to display the result as:
r937 — 2011-03-02T06:45:10-05:00 — #2
billy_111 — 2011-03-02T06:51:13-05:00 — #3
Thats perfect, thanks.
Has been a long time since i've posted on this forum as i got a new job. But will be posting on here more often.