Advertisement
|
[x]
Attachment Details
|
||
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 43: 44: 45: 46: 47: 48: 49: 50: |
ALTER PROCEDURE [dbo].[svg_monthlyvolumebyisobydatePro]
@isonum int,
@sdate varchar(25),
@edate varchar(25),
@view varchar(10)
AS
declare @sqlstm as varchar(8000)
declare @filter as varchar(10)
if @view='View All'
begin
set @view=''
end
set @sqlstm='SELECT '+
@view+
' dbo.Locate.mid,
dbo.address.corpname,
dbo.Locate.dba,
sum(BatchHeader.VisaMasterVolume) as netvolume,
sum(BatchHeader.VisaMasterTransCount) as itemscount,
CASE WHEN '+ @isonum + ' = ' + '9927' +
' THEN dbo.Referral.ReferralName
ELSE ' + ''N/A''
END AS refName
FROM dbo.BatchHeader with(index(IX_BatchHeader),nolock)
INNER JOIN dbo.Locate with(index(PK_Locate),nolock)
ON dbo.BatchHeader.MerchIntID = dbo.Locate.intmid
INNER JOIN dbo.MerSum (NOLOCK)
ON dbo.Locate.intmid = dbo.MerSum.Intmid
INNER JOIN dbo.address with(index(PK_Address),nolock)
ON dbo.BatchHeader.MerchIntID = dbo.address.intmid
LEFT OUTER JOIN Referral (nolock) on
mersum.refid=Referral.refid
WHERE (mersum.isonum='+convert(varchar(10),@isonum)+
' or mersum.Subisonum='+convert(varchar(10),@isonum)+
' or mersum.Subisonum in (select isonum from iso where
referralpartner='+convert(varchar(10),@isonum)+'))
and dbo.batchheader.datecreated >=
convert(smalldatetime,'''+@sdate+''')
and dbo.batchheader.datecreated <=
convert(smalldatetime,'''+@edate+''')
and mersum.alternativeisonum is null
group by dbo.Locate.mid, dbo.Locate.dba, dbo.address.corpname, refName
order by netvolume desc'
exec (@sqlstm)
|
|
[x]
The Solution Rating System
|
||
|
With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.
Your Input Matters If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support. Thank you! |
||
|
Loading Advertisement... |