Helpfulbox Now Offers Free POS Software for restaurants, kiosk, and any other retails business completely free used windows cashier system or as full blown POS. You will able to print to kitchen, display orders on the kitchen screen, manage inventory, employee, report, customer loyalty offers, employee management, delivery address track and much more, al for free.

re SQL Question DECLARE @strValues varchar(8000) SELECT @strValues = COALESCE(@strValues+',', '') + column FROM ( SELECT DISTINCT column FROM table ) X ORDER BY column SELECT [Result] = @strValues --------------------------------------------------------- I'm so bad with SQL, I want to select varcharfield from table (returns many rows) Then I want to somehow convert this select(serverside) to a single row with one field(scalar?) in the single field should be concatenation of all fields from the select statement Any ideas?

By: Guest
Date: Unknown--
Response
0
my previous answer to your question

http://sfbay.craigslist.org/forums/?ID=78085725

SUCKS TO BE YOU TROLL!

[d] By: Guest
Date: unknown---
Response
0
ehhh... you're already doing that.

Assuming you can play nice this time around...

That's going to return you a result set consisting of a single row, with a single column, containing a single scalar value of comma delimited [column] values from [table].

Is there something about that behavior that's causing a problem for you?

[d] By: Guest
Date: unknown---
Response
What is 1 + 100



Helpfulbox Now Offers Free POS Software

for restaurants, kiosk, and any other retails business completely free. It can be used as windows cashier system or as full blown POS. You will able to print to kitchen, display orders on the kitchen screen, manage inventory, employee, report, customer loyalty offers, employee management, delivery address track and much more, all for free.

Just Updated::