Jeff Moden (1/11/2015)

---

@chef423,

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

i_transaction_id c_amount dt_when ...

That was my interpretation of the same [i_ticket_id] but in different instances.

Ok sorry...

So, the original code above pulls sales from Tickets in a POC that have a customer name attached to them, call a 'House Account'

So they needed a better way...

hmmm, that's why I put the output of the above code in the thread...

No worries...Ill figure it out on my own then.

If you don't understand the original code then there...

Any other help, please?

Thanks. I am attempting to do this without having to code anything C#.

One last question:

SELECTc.cust_fullname AS Name,

c.cust_membership_id AS Account,

t.c_amount AS Amount,

'CH' + CAST(t.i_ticket_id AS varchar(12)) AS Doc_Num,

t.s_credit_tran_type AS Detail_Account,

...

wow, I didnt even get time to edit my question, you sir, are a beast 🙂

Thanks.

Thank you!

Oh darn, I always code in SQL Sever.

Seems like CONVERT() will work? Where to place in my code? In the same line as the call for the dt_when (time/date)?

Thanks Luis.

CONVERT(varchar(10),t.dt_when)

This...

So the Weeks code is:

DATEADD(WK, DATEDIFF(WK, 0, GETDATE()- 1) - 1, 0),

DATEADD(WK, DATEDIFF(WK, 0, GETDATE()- 1) - 1, 7)

Let me test...thanks.

Thanks for the help....How do you post your code like that? I am using Snipping Tool but it doesnt let me post it to the thread...

Chris

Ok, so my thread has been hijacked?

Grrr

Thanks to all it works perfectly.

Now to learn how to push this data in QB's...

I'm actually shocked there is only Google info on how to push data FROM Quickbook's into SQL but not the other way around.

Doesn't Intuit understand people use Point of Sale...