I have a couple imports that I do from a remote database, after which I update my own database with the calculations and manipulations on this new data.

I...

Thanks. I was able to schedule a job... though I'm surprised there's no way to run this sort of thing without opening the SQL Server Management Studio. ...

From your suggestion, I read through some of the Intro to Service Broker at: http://msdn.microsoft.com/en-us/library/ms345108.aspx

Maybe I didn't describe what I was looking for well enough, because it seems...

Perfect - Thanks!

I looked into the ROUND() function as you guys suggested. Maybe my implementation is off because while it rounds the value, it leaves on all the trailing zeros after...

Oh yeah, I am just running this query in the MS SQL Server Mgmt Studio if that makes a difference.

Here is a simplified version of the query. The actual query contains about a dozen items in the select statement similar to this calculation.

SELECT

...

Yeah, I figured it out. The final implementation is below. I've done the updates for all my past data, and now as new data comes in, I'll be...

This seems to work for the most part, but the version you posted had a slight quirk in that the calculations were a day off. This is a trailing...

Steve,

You've definitely got a good point that I had thought about as well. (Though for the moment, I'm most concerned with getting everything implemented correctly.)

But to...

Jeff,

I'm attaching the file with the formatted test data. It should generate about 150 rows of data for you. And because it makes things more interesting (:)),...

Thanks so much for the help. I've been able to implement your suggestions, but had to add quite a few work-around statements to skip over missing/NULL values (otherwise due...

You were right - Jeff's article was very helpful for handling weekends in the function I'm writing, but I still don't have a very efficient way to account for all...

Is there a way to enter command line arguments for the bat file at run time as well?

Or is it possible to pass the result of one to...

I checked for double counting - and b/c of the way the MarketDate variable is stored, (as a datetime where the time is 4pm EST) there is no double counting....