Skip to main content

All Questions

Filter by
Sorted by
Tagged with
0 votes
3 answers
1k views

Filling Empty Values when Calculating Standard Deviation

I am currently trying to calculate the standard deviation of the amount of products we have sold at our company over the past 12 months. I have a table that contains every date over the past year and ...
Jack's user avatar
  • 123
1 vote
1 answer
723 views

Use stored procedure to get minimum value from column and decrement it and other values

I'm trying to understand how the following algorithm could be completed in SQL 2008 R2. I have a table that contains production data. The table uses a "rolling" scheduling method, meaning that orders ...
Jack's user avatar
  • 123