You're welcome.

Whatever they told you to use. The confusion on that came from the first post, where it has a -5 in one place and -4 in another.

It probably actually needs to be:

where (finalcalledpartynumber = ('386') OR callingPartyNumber = ('386'))

AND dateTimeOrigination >= @StartInt

AND dateTimeOrigination<= @EndInt

Without the parentheses around the party numbers, it won't use...

One reason I worked it the other direction is that it gets rid of the functions in the Where clause. That's usually a good idea for performance. Probably...

Depending on the data present in the tables, the only significant differences between the two are the IsNull operators in the second one. If there aren't any nulls in...

Try this:

declare @StartInt int,

@EndInt int;

select @StartInt = datediff(second, dateadd(hour, -4, '1/1/1970'), @StartDateTime),

@EndInt = datediff(second, dateadd(hour, -4, '1/1/1970'), @EndDateTime);

Where MyField >= @StartInt and MyField <= @EndInt;

Running a binary checksum on large volumes of data is going to be slow. More powerful hardware is the only thing I can think of that would realistically speed...

The execution plan will rebuild for a number of reasons, and one of them can certainly be when the indexes are rebuilt, since that updates table stats.

The plans aren't built...

This looks like something that can be solved with Sum() and Group By. Are you not familiar with those, or am I missing something?

One point that may or may not matter is that the deduping script used here ignores the AccName column. That handles the one with extra spaces, but you'll need...

That looks correct. Have you verified that the file is correctly formatted?

Permissions for the SQL account is usually the problem with these.

I've also had problems when someone else (or me) had the file open already.

s ss (10/14/2009)

---

GilaMonster (10/14/2009)

---

s ss (10/14/2009)

---

I was just wondering (in case I may have some questions in the future) what's so different about this post: Delete Duplicates then this...

In my case, it's probably gotta have that "mood ring" thing where it changes color depending on...

The primary requisites, in my opinion, of a good DBA, are reasonable intelligence, a reasonable level of dedication, a high level of integrity, and an amazing tollerance for boredom. ...