guys was able to do it with this piece of code. But still love to have smaller one is possible.

SUBSTRING(substring(@name,CHARINDEX(' ', @name)+ 1 , len(@name)), 1, CHARINDEX(' ', LTRIM(substring(@name,CHARINDEX(' ',...

I think "sp_Send_dbmail" might hep you. Attach all the files in the sp_send_Dbmail. Here is the syntax just incasesp_send_dbmail [ [ @profile_name = ] 'profile_name' ]

...

I think "sp_Send_dbmail" might hep you. Attach all the files in the sp_send_Dbmail. Here is the syntax just incasesp_send_dbmail [ [ @profile_name = ] 'profile_name' ]

...

I think "sp_Send_dbmail" might hep you. Attach all the files in the sp_send_Dbmail. Here is the syntax just incasesp_send_dbmail [ [ @profile_name = ] 'profile_name' ]

...

Guys, really Appreciate ur efforts and time. Lmu92 I feel ur concerns. To be honest with I was not expecting a real good answer or solutions, as I have never...

Guys, I think we are not on the same page here. You got the total right on the isde. But I want the total as one more row below too....

I am just writing T-sql inside the proc.

The only way i think is, insert into #temp tbl and do in while loop............

Well I am not a grt expert @ T-SQL. I can try to do with the of temp table.

I don't know what will be in the height and weight field...

Jonathan is right. Lookup works differently for empty space. I had these issue. Use TRIM function to trim both left n right when you do lookup. Use in both source...

U shouldn't have prbl. RUn this is SQL

DECLARE @UNIT Nvarchar(10)

SET @UNIT = '100.00'

SELECT CONVERT(decimal(20,4), @UNIT)

DECLARE @DATE Nvarchar(10)

SET @DATE = '20090614'

SELECT CONVERT(datetime, @DATE)

I think u are doing something wrong in...

This is what exactly I had a year ago. I don't remeber , But I was able to fix it. I think in my case, there is an option something...

Do you think changing a code page options in the flat file conncetion would help?

Just stick the Data Conversion inbwtween souce and destination appropriately.

Can u post real values one of each for each column here? I don't think there is a concept of...

Jeff Thanks, You have been alwus a gret help.

Out of all 4 columns used on On conditions, 3 are nchar of length 2, 2, and 12. StatusID is small int....