Part of Slepp's Projects — Pastebin — TURL — Imagebin — Filebin
Feedback -- English French German Japanese
Create Upload Newest Tools Donate
Sign In | Create Account

Paste Actions

Download Raw
Embed
pBox URL
Post to Twitter
View Tree
Remove Paste

Paste Details

SQL Statement format, 5 years 6 months old, and 111 hits.

Paste Description for Stuff

SELECT a.ACCT_ID
FROM INVOICES_TOT a
JOIN INVOICES_TOT b
ON a.INV_31_60 < b.INV_31_60
WHERE a.COLLECTOR_ID = 1
AND b.ACCT_ID = 'MM000002'
AND a.INV_31_60 > 25
AND a.INV_61_90 = 0
AND a.INV_91 = 0
ORDER BY a.ACCT_COMMENT_DATE, a.INV_31_60 DESC
LIMIT 0, 1

Stuff
Tuesday, August 1st, 2006 at 2:26:17pm MDT 

  1. -- --------------------------------------------------------
  2.  
  3. --
  4. -- Table structure for table `ACCOUNTS`
  5. --
  6.  
  7. CREATE TABLE `ACCOUNTS` (
  8.   `COLLECTOR_ID` int(3) NOT NULL,
  9.   `ACCT_ID` varchar(8) NOT NULL,
  10.   `ACCT_NAME` varchar(23) NOT NULL,
  11.   `ACCT_PHONE` text NOT NULL,
  12.   `ACCT_FAX` text NOT NULL,
  13.   `ACCT_EMAIL` text NOT NULL,
  14.   `ACCT_BADPHONE` int(1) NOT NULL,
  15.   `ACCT_LVM` int(1) NOT NULL,
  16.   `ACCT_ACTIONSTEP` int(1) NOT NULL,
  17.   `ACCT_PAYPROM` int(1) NOT NULL,
  18.   `ACCT_DISPUTED` int(1) NOT NULL,
  19.   `ACCT_COMMENT` text NOT NULL,
  20.   `ACCT_COLL_COMMENT` text NOT NULL,
  21.   `ACCT_SENDVIA` int(1) NOT NULL,
  22.   `ACCT_ATTN` varchar(12) NOT NULL,
  23.   `ACCT_COMMENT_DATE` int(8) NOT NULL,
  24.   `ACCT_AUTO_DATE` int(8) NOT NULL,
  25.   `ACCT_LAST_WORKED` int(6) NOT NULL,
  26.   `ACCT_DUPLICATE` int(1) NOT NULL,
  27.   PRIMARY KEY  (`COLLECTOR_ID`,`ACCT_ID`),
  28.   KEY `COLLECTOR_ID` (`COLLECTOR_ID`),
  29.   KEY `ACCT_DUPLICATE` (`ACCT_DUPLICATE`)
  30. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  31.  
  32. -- --------------------------------------------------------
  33.  
  34. --
  35. -- Table structure for table `INVOICES`
  36. --
  37.  
  38. CREATE TABLE `INVOICES` (
  39.   `COLLECTOR_ID` int(3) NOT NULL,
  40.   `ACCT_ID` varchar(8) NOT NULL,
  41.   `INV_ID` varchar(10) NOT NULL,
  42.   `INV_PO_NO` varchar(10) NOT NULL,
  43.   `INV_DUE_DATE` int(10) NOT NULL,
  44.   `INV_TRANS_DATE` int(10) NOT NULL,
  45.   `INV_TRANS_TYPE` varchar(7) NOT NULL,
  46.   `INV_AMT_OUT` double(9,2) NOT NULL,
  47.   `INV_CURR_FUT_DUE` double(9,2) NOT NULL,
  48.   `INV_1_30` double(9,2) NOT NULL,
  49.   `INV_31_60` double(9,2) NOT NULL,
  50.   `INV_61_90` double(9,2) NOT NULL,
  51.   `INV_91` double(9,2) NOT NULL,
  52.   `INV_TOT_PAST` double(9,2) NOT NULL,
  53.   `INV_TOT_BAL` double(9,2) NOT NULL,
  54.   `INV_SEND` int(1) NOT NULL,
  55.   PRIMARY KEY  (`COLLECTOR_ID`,`ACCT_ID`,`INV_ID`),
  56.   KEY `COLLECTOR_ID` (`COLLECTOR_ID`,`ACCT_ID`),
  57.   KEY `INV_31_60` (`INV_31_60`),
  58.   KEY `INV_61_90` (`INV_61_90`),
  59.   KEY `INV_91` (`INV_91`)
  60. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  61.  
  62. INSERT INTO `ACCOUNTS` VALUES (1, 'MM000001', 'BOB THE BUILDER        ', '999 999-9999', '', '', 0, 0, 0, 0, 0, '', '', 0, '', 0, 20060726, 0, 0);
  63. INSERT INTO `ACCOUNTS` VALUES (1, 'MM000002', 'JOHN DEER              ', '999 999-9999', '', '', 0, 0, 0, 0, 0, '', '', 0, '', 0, 20060726, 0, 0);
  64.  
  65. INSERT INTO `INVOICES` VALUES (1, 'MM000001', '32280F45  ', 'MEGASALE  ', 20060703, 20060403, '', 1028.06, 0.00, 1028.06, 0.00, 0.00, 0.00, 1028.06, 1028.06, 0);
  66. INSERT INTO `INVOICES` VALUES (1, 'MM000001', '32280F46  ', 'MEGASALE  ', 20060703, 20060403, '', 1028.06, 0.00, 1028.06, 0.00, 0.00, 0.00, 1028.06, 1028.06, 0);
  67. INSERT INTO `INVOICES` VALUES (1, 'MM000001', '32280F47  ', 'MEGASALE  ', 20060703, 20060403, '', 1028.06, 0.00, 1028.06, 0.00, 0.00, 0.00, 1028.06, 1028.06, 0);
  68. INSERT INTO `INVOICES` VALUES (1, 'MM000001', '32280F48  ', 'MEGASALE  ', 20060703, 20060403, '', 1028.06, 0.00, 1028.06, 0.00, 0.00, 0.00, 1028.06, 1028.06, 0);
  69. INSERT INTO `INVOICES` VALUES (1, 'MM000001', '32280F49  ', 'MEGASALE  ', 20060703, 20060403, '', 1028.06, 0.00, 1028.06, 0.00, 0.00, 0.00, 1028.06, 1028.06, 0);
  70.  
  71. INSERT INTO `INVOICES` VALUES (1, 'MM000002', '32280F55  ', 'MEGASALE  ', 20060703, 20060403, '', 1028.06, 0.00, 1028.06, 0.00, 0.00, 0.00, 1028.06, 1028.06, 0);
  72. INSERT INTO `INVOICES` VALUES (1, 'MM000002', '32280F56  ', 'MEGASALE  ', 20060703, 20060403, '', 1028.06, 0.00, 1028.06, 0.00, 0.00, 0.00, 1028.06, 1028.06, 0);
  73. INSERT INTO `INVOICES` VALUES (1, 'MM000002', '32280F57  ', 'MEGASALE  ', 20060703, 20060403, '', 1028.06, 0.00, 1028.06, 0.00, 0.00, 0.00, 1028.06, 1028.06, 0);
  74. INSERT INTO `INVOICES` VALUES (1, 'MM000002', '32280F58  ', 'MEGASALE  ', 20060703, 20060403, '', 1028.06, 0.00, 1028.06, 0.00, 0.00, 0.00, 1028.06, 1028.06, 0);
  75. INSERT INTO `INVOICES` VALUES (1, 'MM000002', '32280F59  ', 'MEGASALE  ', 20060703, 20060403, '', 1028.06, 0.00, 1028.06, 0.00, 0.00, 0.00, 1028.06, 1028.06, 0);

advertising

Update the Post

Either update this post and resubmit it with changes, or make a new post.

You may also comment on this post.

update paste below
details of the post (optional)

Note: Only the paste content is required, though the following information can be useful to others.

Save name / title?

(space separated, optional)



Please note that information posted here will expire by default in one month. If you do not want it to expire, please set the expiry time above. If it is set to expire, web search engines will not be allowed to index it prior to it expiring. Items that are not marked to expire will be indexable by search engines. Be careful with your passwords. All illegal activities will be reported and any information will be handed over to the authorities, so be good.

worth-right
fantasy-obligation