Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
manicman
Starting Member
12 Posts |
 Posted - 2001-08-01 : 22:33:15
|
| I posted earlier about this, and a response helped a lot to get this far:Select dbo.business.Auto_Number, dbo.business.CouponPic, dbo.business.ADPIC, dbo.business.XTRAPIC, dbo.business.NAME, dbo.business.Address, dbo.business.city, dbo.business.PhoneFROM dbo.businessUNION ALLSelect dbo.business.Auto_Number, dbo.business.Short_Desc,null, null, null, null, null, nullFROM dbo.businessorder by dbo.business.Auto_Number, CouponPicWhat I am having a difficulty with is the desc has to expand all the way across the row:Auto_Number|CouponPic|ADPIC|etc....This is a description of what you asked aboutBut what the above gives me isAuto_Number|CouponPic|ADPIC| etc....----(empty)|This is a|(empty)| etc.where ----(empty) is just there because the preview here on the form posting page didn't keep the whitespaces, so ----(empty) and (empty) are empty, as are the subsequent null, null, etc.! (DUH)I am dev'ing in ASP (Drumbeat 2K), so any type of Hey Dummy advice would be kewlYes, SQL 7.0 NT4thanx,MaNiCmAn ;-)Webmasters rest when they are dead! |
|
|
|
|
|
|
|
Another custom result formatting Help Cry!