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 |
|
saidev
Posting Yak Master
101 Posts |
 Posted - 2006-06-22 : 17:55:35
|
| Guys,I am using xp_sendmail with in SqlServer Stored Procedure and i am sending the result as Text Format. It is not aligning properly. the data under the columns is not properly arranged. can you guys help me how to format this one.ThanksSELECT ChangeControl.dbo.tblChangeControl.ChangeControlID, ChangeControl.dbo.rfProjects.ProjectName,LEFT(ChangeControl.dbo.tblChangeControl.Title, 30) as Title,ChangeControl.dbo.tblChangeControl.BusinessRequestor, CAST(ChangeControl.dbo.tblApprovals.BusinessRequestorDate as varchar(11)) as DateSubmitted, ChangeControl.dbo.tblApprovals.App_Technician, CAST(ChangeControl.dbo.tblApprovals.ChangeControlDate as varchar(11)) as ChangeControlDate FROM ChangeControl.dbo.tblApprovals |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-06-22 : 19:23:12
|
| It depends on how each client chooses to view their emails. What's right for some people will be wrong for others. |
 |
|
|
|
|
|
Sql Query Format