yeah i have tried both char(10), char(13) and char(10)+char(13), they all individually do what is needed when you look at the results in a text output but not in dbmail,...

ok had a brain wave and it works to an extent

changed the body format to html, put in '< br >'...

it just seems to be sp_send_dbmail which is missing the char(13)'s

if you export the output of @Mess to text in SSMS it shows on new lines which is...

Right on a different note this time, getting execute on sp_send_dbmail denied. Now I dont want to grant all the users the ability to send db mail in MSDB...

DOH missed out the ALL from ALL SERVER, my bad, all is now ok.

Jayanth_Kurup (7/4/2011)

---

select * from issues i

left outer join attachments a

on i.id = a .id

this is similar to what you what , if your looking for spoon feeding , you...

post your statement so far and I will see if your on the right track or not.

surely this will diminish the learning aspect

use books online and look at the isnull function and outter joins

this is a very simple statement you are after

you will want to use an outer join (depends which way round you reference the tables as to a left or right) with the isnull functionality

you will need first to run the database upgrade wizard on the 2008 media to ensure that your databases can be upgraded.

if they can then you can do an in...

you wont be able to as the runtime for 2008 is different than 2005

you will need to get hold of BIDS for 2005 and redesign the package and redeploy

packages can...

what are de definitions of the custom data types?

what kind of column is t_editstamp timestamp, datetime, varchar etc.

i found this on redgate a couple of days ago, pretty basic but a good starting point

it all depends how you want to manage security I guess.

we disable it as you may have domain admins who are not dba's, who will get SA access if bultin\administrators...