One other alternative would be to store a datetime field that represents the datetime when the order is entered into the system. Determining the order sequence number can...

Another thought just occurred to me. Perhaps an additional value needs to be stored: the number of values that contributes to the given exponential weighted average, and you...

Looks like Peso nailed the concept for using the "quirky update" to get at the data, however, there's another issue that hasn't been mentioned, and that is accuracy. ...

How about the following:

CREATE PROCEDURE dbo.COUNT_EVENTS (

@StartDate DateTime,

@EndDate DateTime

)

AS

/* -- Stored Procedure to return the count of the three dates of events that meet criteria.

--

-- The Start Date and End...

I'm not sure if it's necessary, but you may need to create a "DNS Name" for the server. That way, it's only created in one place, instead...

I'm wondering if there isn't something more at play here. The SQL necessary to do an insert into two tables doesn't change just because it has to...

Just an update on progress to date:

Having actually listened to MS at the time of reporting the initial problem to them, I had ordered another SATA DVD drive (ROM instead...

This doesn't look particularly easy... Take a look at the following links:

http://en.wikipedia.org/wiki/Partition_of_an_integer#Partition_function

http://www.research.att.com/~njas/sequences/A000041

I'm pretty good with numbers, but the math in Rademacher's series is more than a bit too...

And your objective is? Generating the list? Or just determining the number of partitions, given N ? Also, have you made any attempt at...

The only reliable way to control page breaks with Reporting Services is to find a way to create a field that you can use to group by. There's...

Only to get past the immediate crisis... It appears that this is yet another scenario where it's likely that more hardware is essential to the future of the...

If you're seeking file details, such as filename, file size, etc., why not use xp_cmdshell and run a VBScript that can get that information? It might have less...

EDIT: OOPS!! double post - pls ignore.

============================================================

I finally found what I was looking for, now that I've had a few minutes with BOL... I was in the...

I finally found what I was looking for, now that I've had a few minutes with BOL... I was in the initial install process at home when I...

You may need a copy of the original that can be made while the original is "unlocked". Alternatively, if you can get into the mdb, you might...