We'll need more than that information to have any idea why the counts are off.   We need to know what a single record in the IM_V_Defects table represents, plus...

So, why exactly do you need help?   Are you getting incorrect results?  an error?   We don't have any sample data for you, so we've got almost nothing to go on...

Perhaps the better question to ask is where, exactly, these # characters are actually appearing.   Many products will do that to a field when the value has either a numeric...

In either case, unless "do some work here" is for all practical purposes trivial and not in any way time consumptive, I'd keep the updates as separate transactions, and I'd...

In the Windows world, text files are not generally the same as in the Unix world, as they are generally terminated with CR/LF, which is 0D0A hex, as opposed to...

Give me a reason to use the new data type when I can't use date functions with it natively, or can't get DATEDIFF in particular to work with it at...

Try this:

DECLARE @Table1 AS TABLE (
    ID int,
    [Type] varchar(20),
    Date1 date
);
INSERT INTO @Table1 (ID, [Type], Date1)
SELECT 1, 'Initial', '01/05/2015' UNION ALL
SELECT 1, 'Periodic',...

Views and Full Text Search, are not exactly a good mix.   The only way I can see that working is if the search criteria are fixed and known in advance,...

Just an fyi...   the number of rows you'll have is just over 350 million.   Large, yes.   Gigantor, not really.  This is typically the kind of thing that is best served...

And while I'm thinking about it, you'll need to realize that you won't have a terribly good looking report if someone chooses 1,000 km increments, or worse yet, 500 km...