Advertisement
Advertisement
| 05.08.2008 at 08:31AM PDT, ID: 23386448 |
|
[x]
Attachment Details
|
||
|
[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! |
||
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: |
DECLARE @Bank_ID char(4)
SELECT @Bank_ID = 'xxxx'
DECLARE @Account_Number varchar(16)
SELECT @Account_Number = 'xxxxxxxx'
DECLARE @Begin_Date datetime
DECLARE @End_Date datetime
SET @Begin_Date = convert(datetime,convert(varchar(30),getdate() - 1,106) + 13:00:00.000)
SET @End_Date = convert(datetime,convert(varchar(20),getdate(),106) + 12:59:59.000)
SET CONCAT_NULL_YIELDS_NULL OFF
SET QUOTED_IDENTIFIER OFF
SET ANSI_NULLS OFF
DROP TABLE positive_Pay
CREATE TABLE positive_Pay (
data varchar(84))
INSERT INTO positive_Pay (data)
SELECT
@Bank_ID +
'02' + --Application
REPLICATE('0', 16 - LEN(@Account_Number)) + @Account_Number +
'60' + --Item type
REPLICATE('0', 10 - LEN(chk_reconciliation.check_num_numeric)) +
CONVERT(varchar(10), chk_reconciliation.check_num_numeric) +
REPLICATE('0', 11 - LEN(CONVERT(int, chk_reconciliation.check_amt* 100))) +
CONVERT(varchar(11), CONVERT(int, chk_reconciliation.check_amt * 100)) +
REPLICATE(' ', 30) + -- Description
DATENAME(yyyy, chk_reconciliation.check_dte) +
REPLICATE('0', 3- LEN(DATENAME(dayofyear, chk_reconciliation.check_dte))) +
DATENAME(dayofyear, chk_reconciliation.check_dte) +
CASE WHEN check_void_flag='y' THEN '11' ELSE '10' END -- 10 -> Issued; 11 -> Void; 12 -> Cancelled; 14 -> Re-issued
FROM chk_reconciliation
WHERE ( chk_reconciliation.check_dte >= @Begin_Date ) AND
( chk_reconciliation.check_dte =< @End_Date ) AND
( chk_reconciliation.check_num_numeric > 0) AND
( chk_reconciliation.check_num_alpha = 'cc' )
ORDER BY chk_reconciliation.check_num_numeric ASC
|
