Hi Laurie...can you let me know how I...

I moved the code from here...up to original post.

ChrisM@Work (3/9/2015)

---

This ON clause will generate an error as it breaks at least two syntax rules:

JOIN dbo.PeriodDefinition AS pd

ON CAST(t.dt_close_time AS time) BETWEEN CAST(pd.dt_start AS time) CASE when i_period_definition_id...

chef423 (3/8/2015)

---

Background on this project: I am writing a custom report for a client, we are in the Point of Sale business. I am the technical director of the company,...

Here is how I resolved this. Basic. Thanks for all the responses, I love this forum, always friendly folks willing to share knowledge.

SELECT

...

Please take the time to read the first article I have referenced below in my signature block. What you have posted isn't what I requested. Posting a...

Ok, here is the Transaction table DDL:

So I pull Customer 'House Accounts' from this table via the 's_credit_tran_type' field. There are 2 fields in the Customer table that are used,...

If I proved the database (.bak) file can someone assist here?

I still cannot get this to work. And I am past my deadline...

The problem is the language not my knowledge...

SELECT c.cust_fullname AS Name, c.cust_membership_id AS Account, t.c_amount AS Amount, 'EN' + CAST(t.i_ticket_id AS varchar(12)) AS Doc_Num,

...

Understood...thanks!

steve.tarry (1/15/2015)

---

So does this not give you what you need?

--DROP TABLE #WorkTable;

SELECT RowNum = ROW_NUMBER() OVER (PARTITION BY i_ticket_id ORDER BY dt_when)

...

Well, with this code:

SELECT c.cust_fullname AS Name, c.cust_membership_id AS Account, t.c_amount AS Amount, 'EN' + CAST(t.i_ticket_id AS varchar(12)) AS Doc_Num,

...

I just need to look at it a bit more, thanks for all the help...

I need to figure out how to query my output table....

There is no Transaction ID in...

Jeff Moden (1/11/2015)

---

In that case and pretending this is your actual data...

SELECT RowNum = ROW_NUMBER() OVER (PARTITION BY i_ticket_id ORDER BY dt_when)

...

Jeff Moden (1/11/2015)

---

chef423 (1/11/2015)

---

Jeff Moden (1/11/2015)

---

@chef423,

How do you want to handle 58475 when the following happens?

i_transaction_id c_amount dt_when ...