I ran the SP_Helps, and they both are set to datetime fields.

Here is a sample of the query:

truncate table [LM_Date1]

insert into [LM_Date1]

select

C.[Cust_ID],

C.Phone,

H.[Sold_Date],

H.[Amt_Sold],

H.[Amt_Paid],

H.[Paid_Date]

from [Lead_Management_Preparation Table] L INNER JOIN (History H inner join Customers C on

C.[Cust_ID]=H.[Cust_ID]) ON H.Cust_ID=L.Cust_ID Where...

Also, your code does everything except also give me the breakdown of the counts.  I can always work to replace the nulls with 0's.

I'm trying out your code, but what I want ultimately is:

This is what I use for my queries when finding and/or deleting duplicates:

Note: I use a counter to determine how many times to cycle through the database in order to...

Are you inserting or updating?  I had an issue with updating that gave much the same error message, and it was because the table Iw as updating didn't have a...

The funny part is this is actually the exact type of things I've thought of doing many times at my work.

The owner of my company refuses to allow me to...

My first time through on the 70-431 was a 620.  I missed passing it by 1 or 2 questions tops. 

But on the 431, you're right, it's like 2 bars...

I used the self paced training kit (I think it was from MS Press, but it was ~100 on Amazon).

Using that and ALOT of working through the practices, plus reading...

Passed this one today.

I have to agree in that I didn't mind this particular testing method at all.  I wasn't crunched for time in the slightest (I think the shortest...

Well Fizzle, I'll be thinking of you while I'm in there Friday morning as well.  9:00 AM EST and I get the joy of attempting this.

At least, I was...

I try to look at both sides of situations in order to try to find a win-win attitude where both myself and whoever I'm talking to can walk away at...

That's exactly what I had thought about doing since it could persist throughout systems.

The issue I have though is how atypically people handle integrating the various types of records.

I'm sure...

It's been a couple of weeks, but I thought that Standard could only use up to 4 CPU's (irregardless of cores) so would you then need to update to Enterprise...

Exam insurance is (at least for the one I took) $45 per exam on top of the normal cost of the exam.  IE instead of the 70-431 costing me $125,...