Phail & Gil 😀

k.allen.emt (1/25/2015)

---

Phil,

=) sorry, thanks I will give it a shot.

Beyond new here in this, my buddy tossed me his MySQL book "The Language of SQL" and said read.

Thank you again......

There are other ways, this is possibly the simplest. You will need to plug in missing table aliases to disambiguate columns:

SELECT --Distinct

CAST(fo.OrderDate AS DATE),

SUM(s1.PUDriverCommission) AS [Commission1],

SUM(s2.DELDriverCommission) AS [Commission2],

SUM(s3.Driver3Commission) AS...

shasivashok (1/26/2015)

---

Hi,

I don't get the distinct date in the below query. Anything wrong in this query. Also may i short this query? If yes, Please advise me.

SELECT Distinct (CAST(FinalizedOrders.OrderDate...

If the user enters a date range, how many rows should the report display per patient stay - one, same as the source table, or more than one, depending on...

Count the rows added to the table. How many seed rows (rows you start with)?

Use REPLACE()

Relational division. Joe Celko and Dwain Camps...

How do you define a member as opposed to a player? What's familyID in both tables?

Don't do this. Use a new column for the iteration of name, it will be much easier. How many loads do you perform into the target table?

Sure. Have a good look at the actual execution...

BOR15K (10/14/2014)

---

Thank you!

I have looked into the actual execution plan (I am not sure I can publish it here due to company's security policy).

What I have seen that with CASE...

Example, input will start from a member table

Member , Start date, End date, Status

M1 1/1/2014 12/31/2014 ...

Have you tried posting to a DB2 forum?

shahi.alokchandra (9/17/2014)

---

I am having 4 Columns Qty decimal(12,3),CF1 Decimal(12,3),CF2 Decimal(12,3),Flag TinyInt.

I want to perform following without using case please tell me how it is possible.

When value of Flag is 0...