You cannot put a SUM inside a SUM.

If you would post the table DDL, some sample data and the desired output, it would be easier for people to help you.

I try to use date functions more instead of relying on string manipulation and implicit conversions, but that's a personal choice.

Koen Verbeeck (6/19/2014)

---

GBeezy (6/18/2014)

---

Thanks Jo for the reply. The rnd function certainly does what I need. My only problem now is that I want to only display the...

GBeezy (6/18/2014)

---

Thanks Jo for the reply. The rnd function certainly does what I need. My only problem now is that I want to only display the numbers after...

That is still not a question, but anyway...

DECLARE @startDate DATETIME, @endDate DATETIME, @getdate-2 DATETIME;

SET @getdate-2 = GETDATE();

SET...

Is there a question?

melanie.townsend (6/19/2014)

---

About the Spam messages which have been flooding the forums -we're aware of the problem and are working to clear the posts as quickly as possible. I know they're...

In that case (pun intended), stick...

Or if you dislike CASE statements (some people do):

SELECT Variance = SYS + SIGN(SYS) * (-1) * BANK

FROM myTable;

The only problem is when SYS is 0. What does your formula...

SELECT Variance = CASE WHEN SYS >= 0.0 THEN SYS - BANK ELSE SYS + BANK END

FROM myTable;

Either make sure the query returns only one value, or use IN instead...

Because you are comparing a single value, ct.id, against the result set of a query.

If they query returns multiple rows, how can it compare it against the single value?

For example:

5...

I like the way you think, but this doesn't necessarily lead to failures.

If a package configuration fails, the...

TomThomson (6/18/2014)

---

So you claim that is someone uses...

rhythmk (6/19/2014)

---

Another confusing question 🙁

Permission to...