ahhhh stupid me. It was a long weekend

Thank you, i forgot about Throw (just like in C#) I am a C# developer and so so on SQL

Create procedure [dbo].[TO_POPULATE_ISD_MonthEndDetail] AS
begin Try

insert into [dbo].[U5TO_ISD_MONTHENDDETAIL] ([MOD_DOCID], [MOD_STORENO], [MOD_STOREORG], [MOD_AIMDATE], [MOD_PARTCOUNT], 
[MOD_PRT], [MOD_QTY], [MOD_AVP], [MOD_BATCHID], [MOD_CREATEDATE], [MOD_MONTHYEAR])

SELECT
    [ISD_DOCID], [ISD_STORENO], [ISD_STOREORG], [ISD_AIMDATE], [ISD_PARTCOUNT], [ISD_PRT],...

I am using excel to open or past the sql data.

There are line feeds in one of the columns causing the issue.

I have found a work around by doing a

replace(replace(WorkInst,...

I have done to methods of getting the data from SQL

1. Right clicking on the grid and copy with headers then pasted in to excel.
2. Right Clicking on the grid...

Yep done the conversion (10) fields converted

It resides in a table, I really done want to do isnull() on all fields but if i have to?

yep, learned the hard way forgot #3 of 4 lol

The main reason i am using the strip backup if because i am transferring the bak and the main db was 12g bak and our share point was being a...

Thank you.

one of my sets of tables to compare has over a million records, it is taking about 5-10 seconds so works fine.

Thanks for the help

i am doing a replace for char(13),' '),char(10),' '),char(44),' '),char(34),''),char(45),'') on both sides, working great.

Always get some help or pointed in the right direction here.

This is what i came up with, i think i got all the offending items

replace(replace(replace(replace(replace(Rtrim(loc.desc),char(13),' '),char(10),' '),char(44),' '),char(34),''),char(45),'') =

replace(replace(replace(replace(replace(Rtrim(HO.desc),char(13),' '),char(10),' '),char(44),' '),char(34),''),char(45),'')

The spacing is the same with in the text strings, what i am finding is that when the user entered the date the may have put a tab, at the...

Thanks for the help using OPTION(QUERYTRACEON 9481) , corrected the issue I also tried option (recompile) and it worked also. so the  Cardinality Estimator is a new feature to 2014,...