Text Formatting In SQL

Jan 31, 2008

I am trying to output data from SQL Server to an email body message with a little formatting (just to make it legible)

Using this SQL statement:

select top 1 'Name', app_first_name+' '+app_last_name [name] ,'Submission Date', submission_date ,'Address', app_address+', '+app_city+', '+app_state+'  '+app_zip from vw_bpa_export where app_email = dave@email.com order by submission_date desc

the resulting output displays this in the email body


"Name","Brian Vogler","Submission Date","2008-01-30 07:45:00","Address","6285 Harrow Trace, Norcross, GA  30092     "


but what I want is the text to look more like this:


Name                        Brian Vogler
Submission Date        2008-01-30 07:45:00
Address                     6285 Harrow Trace, Norcross, GA  30092

 Is there a way to do this in the SQL  statement  (without HTML tags)?

 

View 3 Replies


ADVERTISEMENT

SQLMail And Formatting Text

Jun 1, 1999

Does anyone know if there is a way SQLMail can always send a message using a fixed font like Courrier? I use SQLMail to send out an invoice and even though I format the spacing, the email looks unformatted on some systems.

I am using Exchange 5.5, SQL server 6.5 sp4 and the recipients of the emails could have any email client.

thanks,

-Darin.

View 1 Replies View Related

Formatting Text In Textbox

May 31, 2007

Is it possible to format one word in a text box to the color blue and another word in the SAME textbox to the color red?

View 1 Replies View Related

SSRS Text Formatting

Jun 22, 2007

I am designing a report using SQL server Reporting Services. I need to format my report and it requires for the text in my textbox to appear inclined ( as we have it in Excel). Is anyone aware of such an option in SSRS where we can set the direction of the text to be inclined ? Any help is appreciated !!



Thanks,

Deepti

View 2 Replies View Related

Formatting Part Of The Text

Dec 7, 2007

The value expression for one of the column in my report is

="Notes: " + Fields!Notes.Value. I want to make this Notes caption to bold. I can't move "Notes: ", Fields!Notes.Value to the 2 different columns. So I want to know, Is there a way to do it?

View 4 Replies View Related

Formatting Part Of A Text Box

Mar 10, 2006

hey all,

does anyone know of a way to format part of a text box in sql reporting services 2005? i am creating a form letter and need to concatenate static text with a column and need just the column value to be bold. like this:

"This letter is confirmation that Acme Agency has been chosen..."

my expression to build this is:

="This letter is confirmation that " + Fields!agency_name.Value + " has been chosen..."

Is there a way to apply formatting just to Fields!agency_name.Value ?

thanks!

jen

View 5 Replies View Related

Text Formatting In SQL Database Fields

Nov 14, 2006

Hi,
I am saving a couple of paragraphs of text into a varchar(max) field in a SQL database table. But when I try to use display the information again, then all the linefeed and return characters seem to be removed. How do I keep this text formating in the database field?
I am sure that I am missing something simple here, but I can not figure out what. Can someone please help with some advise?
Thanks
RegardsJan

View 6 Replies View Related

How To Retain Text Formatting In A Table

Aug 17, 2007

What is the best way to parse large amounts of formatted text data
into a table so that it can be retrieved with as much formatting
retained as possible - particularly paragraphs?  Will each
paragraph need to be inserted into its own row to be retrieved as a
paragraph?

View 11 Replies View Related

How Do Your Keep Text Formatting When You Insert It Into Database

Jul 23, 2005

Hi All,This may seem like a stupid question but is there a way to keep textformatting when you add it to a database? Such as Paragraphs and linebreaks?Any help greatly appreciated.Blaine

View 2 Replies View Related

How To Retain Text And Paragraph Formatting

Aug 17, 2007

Is it possible to retain text or paragraph formatting in a SqlServer 2005 Express edition table? If so, how?

I am particularly interested in keeping a linebreak between paragraphs and the only way I can think to do that is to put each paragraph in its own row. But I want some input before I undertake that substantial task.

Thanks for any help provided.

View 7 Replies View Related

Removing Rich Text Formatting From A Field

Feb 6, 2007

I have a field where the data is stored with RTF. I know SQL Reporting Services cannot display it properly. Is there way to remove the RTF formatting codes through a function to just pull out the text and displya it in the text box?

View 4 Replies View Related

Conditional Formatting On Text Color In Group Footer

Oct 19, 2007



Hello,

I am having a problem trying to do some conditional formatting on the text color.

This textbox is in the Group Footer so i essentially want change the color to red if the SUM of one field in the group is less than the SUM of another field in the same group.

I am doing this:
=Iif(Sum(Fields!YTDChargeHours)< Sum(Fields!YTDForecast), "Red", "Black")

but i am getting this error:

[rsRuntimeErrorInExpression] The Color expression for the textbox €˜YTDChargeHours€™ contains an error: Operation is not valid due to the current state of the object.



Thanks in advance!

View 4 Replies View Related

Formatting Text Within A Text Box

Aug 7, 2006

Trying to use this tool to create a form letter. I have a text box that has a paragraph of data within that paragraph I'd like to bold a word or underline a word. Is this just a gross misuse of this tool or is there a way to format text within the text box?

View 3 Replies View Related

Formatting

Aug 18, 2005

Hello all,I have a strange problem that i need some advice on. I have the following field called FILENO. It is a SQL 2000 field with the Data Type set to Char (7). The following sql statement works perfectly:SELECT TOP 1 RTRIM(FILENO) AS TEST, RIGHT(DATEPART(Yy, FILENOYEAR), 2) AS YEAR FROM tblRecordsWHERE RIGHT(DATEPART(Yy, FILENOYEAR), 2) = '05'ORDER BY FILENO DESCIt returns the correct data, 0050. Now, what i'm trying to do is add 1 to the value so i can get the next available number which is 0051. But, when i run the following sql statement, i get 51 instead of 0051.SELECT TOP 1 RTRIM(FILENO+1) AS TEST, RIGHT(DATEPART(Yy, FILENOYEAR), 2) AS YEAR FROM tblRecordsWHERE RIGHT(DATEPART(Yy, FILENOYEAR), 2) = '05'ORDER BY FILENO DESCDoes anyone have an idea how to solve this? Thanks.Richard M.

View 1 Replies View Related

SQL Formatting.

Feb 28, 2001

I'm working as a consultant for a project and I have been having constant issues with the in house "database guru" about stored procedure formating.

He insists I use a format similar to this:

create procedure getUser @UserId int = NULL
as
select
UserName
, UserPassword
, UserRole
from
Users
join
UserRole
on
User.ID = UserRole.ID
where
User.ID = @UserID
and
User.Active = 1

where as I prefer this format:

create procedure getUser
(
@UserId int = NULL
)
as
select UserName,
UserPassword,
UserRole
from Users
join UserRole on User.ID = UserRole.ID
where User.ID = @UserID
and User.Active = 1

Now normally I don't argue about style issues but I find his format confusing and it bothers me that it senselesly wastes lines make the stored procedure longer than necessary.

I'd love to get some comments on this issue or reference to any discussions on issues such as this.

Thanks

View 2 Replies View Related

SQL Formatting

Apr 9, 2008

Hello -
Does anyone know why SQL Server Reporting Services formatts SQL weird? -- If I type a SQL statement in notepad or notepad++ and then paste it in Reporting Services it will change the whole structure and "expand" it out to three or four times its size.
Thanks
Adam

View 3 Replies View Related

Formatting In Sql Query

Dec 12, 2006

Hello All,
Is it possible to format an integer to a float value with 2 decimals in an sql query.
If yes, Please help?

View 2 Replies View Related

SQL Formatting A SUM As Currency

Jan 24, 2007

I need to show my SUM of the 2 columns added in the query below formatted as currency. Is this possible?
SELECT SUM(QVSTDN + QVNONC) AS Total FROM INVOICE_TBL WHERE QVORDN = @QVORDN AND QVINV = @QVINV
 I tried:
SELECT CONVERT(varchar(12), SUM(QVSTDN + QVNONC) , 1) AS Total FROM INVOICE_TBL WHERE QVORDN = @QVORDN AND QVINV = @QVINV
But this does not format it as currency. Any input would be helpful.

View 6 Replies View Related

Formatting Dates

Apr 25, 2007

I imported data from a text file, where dates are currently in the format:   050729 to represent July 29, 2005.
 How could I write a sql statment to put make this show up as 07/29/05?
 
Thanks

View 5 Replies View Related

Formatting A Filter

Jun 9, 2008

In a SQLDataSource, the following line throws an error as an undefined function. FilterExpression='left$(lname,1) = "D"'
 Isn't this a standard VB function and why does it produce an error. How do I fix?
Thanks

View 2 Replies View Related

Formatting Dates

Dec 13, 2000

Hi,

In MS Access I can do the following:
Format([SW_Dttm],"Short Date")

What is the equivalent in SQL Server?

Thanks,

Bill

View 1 Replies View Related

Formatting Values

Jun 19, 2000

I have values in my database that I'd like to display as $xxx,xxx.xx. Some of these values use the money datatype and others use float.

I'm building a string in a stored procedure that is eventually passed to Visual Basic. I want to format these values in the above format in the string that is passed. I've searched all through MSN and I couldn't find anything related to VB's FORMAT function in SQL Server.

Does Transact-SQL have any functions that could format these values for me?

View 1 Replies View Related

Data Formatting

Mar 13, 2001

Does anyone familiar with a tool or a quick way to put apostrophes and commas around some values, so they could be used in a query ? Example, if I have a bunch of zip codes such as:
10001
10003
10009
54321
89043
etc
Let's say I have a couple of hundreds of them. I need to be able to see them as -

'10001','10003','10009','54321','89043' etc

Appreciate very much your time.

Ivan

View 3 Replies View Related

SQL 6.5 Query Formatting Help

Feb 1, 1999

I am trying to run a query for the company that I work for and I am getting the right data but more than needed. the query is like this

select distinct(companyname),max(calldate) from tablename

what I want to see is the latest call made to a customer for each company
but what I get back is the company listed several times with the dates of each call. I only want the latest. Any help?

View 1 Replies View Related

Formatting Data Help!!

Apr 12, 1999

Hello Everyone,

I have been requested to take a number of columns and concatenate them into one column with a specifc format/layout. For example I need to take this, (noting all columns are of different datatypes:

col_1 col_2 col_3 col_4 col_5 col_6 col_7
PK #1 John Doe 123 Elm Street Anywhere NM 55660
#2
#3
etc..

...and create this on a different table (noting col_2 is of datatype "text":
col_1 col_2
PK #1 John Doe
123 Elm Street
Anywhere NM 55660
#2
#3
etc..

Can this type of formatting be done?
I know how to concatenate data and use the convert function, but how do you add in CR-LF to get the proper formatting??

Any help would be greatly appreciated.
Troy

View 1 Replies View Related

Xp_sendmail - Formatting

Jun 12, 2001

Requirement:
On Insert, Trigger xp_sendmail to complete pre-formatted email with specific content and send to given email address.

Question:
What tools/methods are available to develop a template that SQL Mail's (SQL Server) xp_sendmail function can utilise without resorting to attachments.

e.g. - how do Amazon.com format and send their automated shipping confirmaion emails ??

View 1 Replies View Related

Date Formatting

Oct 10, 2001

I'm currently getting a date in this format 2001-10-08 10:35:45
(yyyy-mm-dd hh:mm:ss) how would I convert the date to this format
2001-10-08/10:35:45 (yyyy-mm-dd/hh:mm:ss)? The only thing added was the / between the date and time.

Thanks in advance,

Ed

View 2 Replies View Related

Date Formatting

Aug 6, 2004

Hi,

I need to know how i can format the date so that the query results will come out as the format mm/dd/yy hh:mm:ss?

Thanks alot.

View 1 Replies View Related

Getting Formatting Into Data

Sep 8, 2006

I am new to php/MySQL and am working on an online manual. The data is divided into Title and Content. The title is easy as it is one line but the content is meant to be in a number of paragraphs.

The Content field is currently set as "blob" and the text comes out as just one paragraph. Wha can I do to get paragraphs etc into the text?

Thanks.

View 1 Replies View Related

Formatting Output

Oct 7, 2004

Hi, I am running a script which inserts certain rows into a table and at the end of the execution, I do a select statement to show the inserted data as output in the results pane and it is showing as truncated...How can I show the full results..
Here is my script to show the results.
----------
SET NOCOUNT ON
DECLARE @errorCount INT
SELECT @errorCount = COUNT(*) FROM error_report WHERE id != - 2 ANDid != - 5
IF @errorCount = 0
BEGIN
INSERT INTO error_report VALUES( '' , - 1 , 'No error found.' )
END
INSERT INTO error_report VALUES( '' , - 2 , 'The Report was generated on ' + CAST(CONVERT(VARCHAR(23), GETDATE(), 1) AS VARCHAR) )
GO
SELECT table_name + ' table has bad data at id = ' + CAST(CONVERT(VARCHAR(23), id) AS VARCHAR) + ' (' + CAST(reason AS VARCHAR) + ')'FROM error_report WHERE id > 0
SELECT table_name + ' table has bad data (' + CAST(reason AS VARCHAR) + ')' FROM error_report WHERE id = 0
SELECT reason FROM error_report WHERE id = - 1
SELECT ''
SELECT reason FROM error_report WHERE id = - 2
SET NOCOUNT OFF
GO
-------------------------
The Results in the bottom pane looks like this below
------------------
NODETABLE table has bad data (There are 2 duplicate subclass)
Propertytable table has bad data (at Parentid = 2000000859 and p)
Propertytable table has bad data (at Parentid = 10122 and proper)
-------------------
But, when I do a select, they are like this below
----

NODETABLE0There are 2 duplicate subclass name: Specification
Propertytable0at Parentid = 2000000859 and propertyid = 721
Propertytable0at Parentid = 10122 and propertyid = 9

View 5 Replies View Related

Formatting Numbers

Jan 18, 2005

I am using a MS Access ADP connected to SQL Server Data

In a view I have the following formula:

dbo.tblQuoteItem.Cost + dbo.tblQuoteItem.Markup * dbo.tblQuoteItem.Cost * .01

this calculates cost + markup

I cannot get it to format in Currency

Ex:

Cost is $1.75
Markup is 2.00 (2%)
Total shows - 1.785000

I want $1.78

Also - I am using this formula to calculate the Quoted price for the Qty Entered

dbo.tblQuoteItem.Qty * dbo.tblQuoteItem.Cost + dbo.tblQuoteItem.Markup * dbo.tblQuoteItem.Cost * .01

Using a Qty of 2 for above, I get 3.535000

I want $3.53


Any help is appreciated - AB

View 2 Replies View Related

BCP -- Formatting Output

Jun 13, 2007

Hi,

I wrote the below code and procedure that exports two tables contents into 2 separate Excel files. Is there a way to export contents of two tables via BCP utility into 1 Excel file but 2 different Worksheets of this file?

DECLARE @FileName varchar(50),
@FileName1 varchar(50),
@bcpCommand varchar(2000)
SET @FileName = 'E:GPPD_db_stats.XLS'
SET @FileName1 = 'E:GPPD_file_stats.XLS'
print @FileName
SET @bcpCommand = 'bcp "master.dbo.spdbdesc" OUT ' + @FileName + ' -Samex-srv-gppdb -T -c'
print @bcpCommand
EXEC master..xp_cmdshell @bcpCommand

SET @bcpCommand = 'bcp "master.dbo.spfiledesc" OUT ' + @FileName1 + ' -Samex-srv-gppdb -T -c'
print @bcpCommand
EXEC master..xp_cmdshell @bcpCommand
exec master.dbo.xp_stopmail
set @bcpCommand = ' ' + @FileName + '; ' + @FileName1 + ''
DECLARE @body VARCHAR(1024)
SET @body = 'Please find enclosed files with the database status reports as of '+
CONVERT(VARCHAR, GETDATE()) + '. Please DO NOT respond to this email or the ones coming in the future ' +
'with data files as this email address is not monitored for incoming emails. However, if you have any ' +
'questions/concerns please contact ....'


EXEC master..xp_sendmail
@recipients='alla.levit@amex.com',
@message = @body,
@subject = 'Database Weekly Statistics Report',
@attachments = @bcpCommand

Thanks in advance!
-Alla

View 1 Replies View Related

Formatting Dates

Jan 20, 2004

Hi, I was wondering if there is a way to output a special format for dates in SELECT statements. Currently, my date field is returning my date in this format:
2004-01-19 00:00:00.000
but I want it to be like this:
1/19/04 or 1/19/2004
Is there a way to do this?
Thanks.

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved