No, the priority is not stored in a table.

OMG:-):-):-) It works like a charm. Thaaaaaaaaaaaaaaaaaank Yoooooooooooooouuuuuu!!!!!!!! :-):-):-)

I tried implementing by replacing with br, but br gets appended to the string.

I am using the function to send a report using Database Mail as shown below.

Is there any other go wherin I can I can show multiple itinerary's on different...

I am trying to implement this into the following function :

CREATE FUNCTION [dbo].[fnItinerary](@Itinerary_id int)

RETURNS VARCHAR(max)

AS

BEGIN

-- Declare the return variable here

declare @tblFirstName table(ItineraryInOne varchar(max))

declare @ItineraryArr varchar(max)=''

insert into @tblFirstName

SELECT AirLine+' '+Origin+' '+Destination

from...

Hi

When I use this in a select statement as shown i get Sql Server

declare @Str1 varchar(32)

declare @Str2 varchar(32)

select @str1='Sql', @Str2='Server'

select @str1 + char(13) + @str2

Am I doing something wrong???

Thanks for the timely help. Will try implementing as advised. :-):-):-)

Thanks a lot for the valuable suggestions. I am in the process to fine tuning the database by eliminating all the junk data & standardization of the data types across...

Woowwwwwwww!!!!!!!!! Thanks a looooooooooooooooooooooooooot!!!!!!!!!!!!!!! once again for being my saviour !!!!!!!!!!!!!!:-):-):-):-):-):-):-):-):-):-):-):-):-):-):-):-):-):-)

One more query ..

My boss wants me now to stop sending blank reports rather than sending a message.

Is this possible?????

Regards,

Nithin

Thanks a lot!!!!!!! for the timely help. This is of great use to me !!!!!!! Thanks once again !!!!:-):-):-):-)

Can I generate such reports in SSRS??????????

It works like a charm !!!!!!!!!!!!!!!!!:-):-):-):-):-)

Thaaaaaaaaaaaaaaaaaaank You!!!!!!!!!!!!!!!!!:-):-):-):-)

This is the script for the database mail i use. Where should i put the conditions in the script which will prevent the mail from being sent. All I need...

Thanks a loooooooooooooooooooooooooot:-):-):-):-):-) people for the help provided.