Putting commas between select statement values

Hello,

This may be a strange request, but I am going to ask about it anyways.

Say for example if I have a table named TEST and in the table there is a column named NUMBERS, such that it is like this:

NUMBERS
1
2
3
4

How could I use a select statement in a way that a comma would seperate every return value, such that if I go 'Select NUMBERS from TEST' I would get:

1,2,3,4

Instead of:

1
2
3
4

Any ideas?

ThanksThe numbers will still be as o column... but try:

SELECT CAST(numbers as varchar)+',' from TEST

Publishers disappeared from under replication monitor

Strange thing has happened on one of our servers. The publications have
disappeared from under the replication monitor/publishers in Enterprise
Manager. We can still see them under replication/publications though.
Any ideas what may cause this?
Thanks
Ray
can you issue a sp_MSload_replication_status and see if this helps?
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Ray Price" <ray.price@.gartner.com> wrote in message
news:uF%23AOF8UEHA.760@.TK2MSFTNGP12.phx.gbl...
> Strange thing has happened on one of our servers. The publications have
> disappeared from under the replication monitor/publishers in Enterprise
> Manager. We can still see them under replication/publications though.
> Any ideas what may cause this?
> Thanks
> Ray
>
|||It says...
Invalid object name 'tempdb.dbo.msreplication_agent_status'
Ray
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:OoTpVGBVEHA.2508@.TK2MSFTNGP12.phx.gbl...
> can you issue a sp_MSload_replication_status and see if this helps?
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "Ray Price" <ray.price@.gartner.com> wrote in message
> news:uF%23AOF8UEHA.760@.TK2MSFTNGP12.phx.gbl...
>
|||You hit the nail on the head. Restarting the SQL agent cured the problem.
Many thanks!
Ray
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:O96$4HLVEHA.2992@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> that's your problem. Bounce sql server agent. If this does not solve it,
> bounce sql server.
> "Ray Price" <ray.price@.gartner.com> wrote in message
> news:%23dff%237HVEHA.3944@.tk2msftngp13.phx.gbl...
> have
> Enterprise
though.
>