Select AdminAdvertiserList.Company, AdminAdvertiserList.City,
AdminAdvertiserInvoices.[Contract Date], AdminAdvertiserInvoices.[Start
Date], AdminAdvertiserInvoices.[End Date],
AdminAdvertiserInvoices.[Bonus Messages], AdminAdvertiserInvoices.Type,
AdminAdvertiserRepsDDL.Name [Sales Rep]
>From AdminAdvertiserInvoicesJOIN AdminAdvertiserList ON AdminAdvertiserList.Id =
JOIN AdminAdvertiserRepsDDL ON AdminAdvertiserRepsDDL.Id =
I would like to include the column MessagesSent. However, I want to
calculate MessagesSent that were sent between Start Date and End Date.
Does anyone have any ideas how this would even look?
Thank you very much for your help!
Other interesting topics
How to concatenate strings from a column into a single row (with NULL value)?
SQL problem to solve...
passing a table from one sp to another sp
Temp Table Indexing??
Best way to document databases ?
How to utilize the rowId in sql server
How to select a single varchar combined by many rows?
need help on sql