Why should 10 be selected? Its status is paid, but that status has not changed.

ericpap (6/9/2015)

---

Alvin Ramard (6/9/2015)

---

ericpap (6/9/2015)

---

Alvin Ramard (6/9/2015)

---

I can't help but wonder if someone is trying to "reset the clock" to prevent the RTM version from expiring.

Have you discussed this problem...

ericpap (6/9/2015)

---

Alvin Ramard (6/9/2015)

---

I can't help but wonder if someone is trying to "reset the clock" to prevent the RTM version from expiring.

Have you discussed this problem with the server...

Jack Corbett (6/9/2015)

---

ArnolddG (6/9/2015)

---

Thanks for your help Alvin,

That works okay.

One more thing. My query is about 140 lines long.

Is there a way to do the If Then on...

I can't help but wonder if someone is trying to "reset the clock" to prevent the RTM version from expiring.

Have you discussed this problem with the server administrator?

ArnolddG (6/9/2015)

---

Hi,

I have standard SQL query for clients, but sometimes a client does not have a specific table.

How do I deal with that? (creating the table is not an option)

SELECT

...

+ 1

Have you looked at the event logs for the server?

Steve Jones - SSC Editor (6/8/2015)

---

there isn't a restore that has taken place, so either there's some storage change (possibly a restore of some sort) or a machine level change...

I have an idea. You could use a case statement to set the sales amount to 0.00 if the year and month for the revenue is not the same...

If you want a record for each revenue for each month of each year, then I do not see how you can do that without repeating the sale in each...

If I were doing this, where I already had SSIS packages running, I wouldn't waste my time looking for other possibilities. I'd do it in SSIS.

jpserra3 (6/8/2015)

---

Could the reason why I do not see the 'Review Data Type Mapping' screen because I am using SQL Server 2008 R2 Developer edition as opposed to Enterprise...

There can be more than one correct answer here, including just restoring the last log backup.

Are we correct in assuming that you want the correct sequence that starts with restoring...

spaghettidba (6/8/2015)

---

You don't need all the differentials since the last full, just the latest one.

This is what you need:

1. Last full backup

2. Last differential

3. All the log backups taken after...