TomThomson (5/14/2015)

---

Luis Cazares (5/14/2015)

---

You receive a late call during the night to inform you that the server is down and must be working correctly before everyone arrives in the morning....

I was wondering, why would you have a value before an event happened? Shouldn't you have zeros until the first real occurrence?

You receive a late call during the night to inform you that the server is down and must be working correctly before everyone arrives in the morning. How many cups...

Maybe this got overcomplicated and Dwain's solution is better. But I just thought it was good to give this a shot.

DECLARE @DaysBefore int = 3; --Parameter?

DECLARE @StartDate Date = dateadd(dd,...

Now I get the point. It just didn't hit me because I thought that a filter would be the easy part. Of course is easier to get the logic if...

It's possible, but you need to be sure that you're applying the correct precedence.

From BOL:

If EXCEPT or INTERSECT is used together with other operators in an expression, it is evaluated...

Lynn Pettis (5/13/2015)

---

May or may not answer the question. How do you want to handle the null date values? What would the results look like if you only...

Maybe a real life scenario can help. Someone posted a problem that happens when using SELECT *.

http://www.sqlservercentral.com/Forums/Topic1685042-392-1.aspx

I'm sure that it's faster to code using * instead of the column names....

This seems to do the trick. Please be sure to understand what it is doing and ask any questions that you have.

Running totals became a lot easier on SQL Server...

Oh yeah, I saw the error that came from using a table value constructor for testing purposes.

The queries will give different results, but that's a difference on requirement understanding. I'm...

tooba111 (5/13/2015)

---

Luis I really apreciate your help. I am sure I am missing something. After I running Sample Query I am getting Error "Invalid Object Name dbo.Tally"

Can You Please guide...

As long as this is only for reporting purposes, because as previously stated, it makes no sense to store so many repeated values.

You just need to query your table joining...

This is very similar to what Lynn already posted, with a little improvement to make the JOIN clause SARGable. I agree that recursion is not needed, neither the UNION ALL...

You have a few syntax mistakes, but the logic seems correct.

SELECT ProductSkuTypeId = pst.[ProductSkuTypeID],

ProductSkuTypeName = pst.[Name],

ProductTaxCodeID...

Steve Jones - SSC Editor (5/12/2015)

---

If the ~ is always at the end, you can start a second PATINDEX/CHARINDEX search after the place where you find the first one and...