Skip to content

Instantly share code, notes, and snippets.

@yodiz

yodiz/gist:5254273

Created March 27, 2013 13:47
Show Gist options
  • Save yodiz/5254273 to your computer and use it in GitHub Desktop.
Save yodiz/5254273 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
SELECT COUNT(*) FROM Cdr
JOIN Contract ON Cdr.BillingClientNr = Contract.ClientNr And Cdr.BillingContractNr = Contract.ContractNr
WHERE BillingClientNr = 44404 And StartTime > '2013-02-01' And StartTime < '2013-03-01' And Cdr.CallType=1
And NumberGroupCode = 'FIXED'
And Contract.ProductNr = 0
And Cdr.BillingPriceListCode like 'T%'
25908
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment