kramaswamy (7/19/2011)

---

found this, might be useful for you:

WHERE ((DATEPART(dw, [Your_Date]) + @@DATEFIRST) % 7) NOT IN (0, 1)

that excludes weekends from your query. the @@DATEFIRST part is necessary to adjust...

The tables are very large, so I cut it down to only the data points needed to get to the results.

Here are the create table statements:

/****** Object: Table [dbo].[PS_POSITION_DATA]...