If there is a time component unequal midnight in your data, you might want to use something like this

dateadd(d, -

Piggy-backing on Chris, see if this also helps explaining

http://vyaskn.tripod.com/differences_between_set_and_select.htm

To expand a bit on cursors (in answer of a PM to me, Remi ):

I think cursors are viewed by most folks as...

Okay, good point. But I think the situations where you truely need a cursor a *very* rare.

I still think this is some kind of unreal. I can't say how many times I've looked at the MS site to convince myself that...

Glad it helped. You're welcome!

Hm, this doesn't indicate some error. You haven't posted the error message you get and can you also provide the information reqeusted here: http://www.aspfaq.com/etiquette.asp?id=5006

Another thing is, be explicite in...

And what do you do about tables with no indexes?

Create one to move the data and drop it afterwards. Still faster than using EM.

It is no FLOAT. It's a BINARY(8) and SQL Server does store two integers in there. The first 4-bytes represent the days since SQL Server's base date, the second 4-bytes...

If this http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=172848 is the same question, please refrain from multiposting. Let's use then the other thread.

So, you want to import those rows that doesn't already exist in your production table? If so, have a look at EXISTS() in BOL. and maybe this helps, too:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=172771

...not only the code, but also the error message you've indicated in the subject.

Re expected output.  A new table with a list of exceptions - ie dosnames in one table but not the other.  So a join probably wouldn't help anyway, as I...

Forgive my ignorance, but why do you store such redundant data like a running balance in your db at all?

The usual approach is either use something like this:

IF OBJECT_ID('lfdsum_t') IS...

You don't need to loop through your rows. Just JOIN both tables on a common column and then you can compare almost whatever you want and insert this result into a...