Showing posts with label ddl. Show all posts
Showing posts with label ddl. Show all posts

Monday, March 19, 2012

Combinding two rows into one and then displaying in a ddl

I'm pretty sure this can be done just don't know how. I need to combind two rows from the same table in an sql server database into one row that I can then put into a dropdown list.
ex.
ProductID ProductDescription are the two rows That I need to display in the dropdown list.
12 Backpack
should show up in the ddl as 12 Backpack as a choice.
Thanks in advance for the helpSELECT
CONVERT(varchar,ProductID) + ' ' + ProductDescription
FROM
Products|||

thanks that's exactly what I was looking for