Viewing 9 posts - 1 through 10 (of 10 total)
Lynn, I think you win the grand prize (though I found all the advice exceptionally useful). I think moving the tables out of the cursor did the trick. I was...
July 13, 2007 at 9:06 am
Hi Karl,
Thanks for your comments. This is the first time I have had to optimize (to this much of a degree) anything I have written. I've never even had to...
July 13, 2007 at 8:11 am
zipsupdated
==================
10001,2006-05-17 19:48:00
33101,2007-06-25 15:41:00
33109,2006-06-02 22:32:00
July 11, 2007 at 12:18 pm
zipfind
==================
25986,07024,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
32433,10965,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
48008,08560,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
48015,07407,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
48190,07083,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
49944,07430,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
50778,11577,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
54202,07626,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
54869,33327,30.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
56991,12553,40.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
57274,33029,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
57290,33068,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
57301,07024,40.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
57993,33317,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
25354,10017,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
26111,11378,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
26364,08840,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
28533,07093,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
30913,06468,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
48309,33330,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
51422,10538,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
52990,33032,40.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
53353,33015,40.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
55964,33196,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
57378,33010,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
57736,10577,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
58307,10010,10.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
59334,33182,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
24756,33319,0.0,NULL,NULL,53,26,.0000,2007-07-06 02:00:00
26178,11580,0.0,NULL,NULL,53,26,.0000,2007-07-06...
July 11, 2007 at 12:17 pm
zipfindzips2
==================
10001,00501,50
10001,06460,58
10001,06468,56
10001,06470,57
10001,06484,59
10001,06497,55
10001,06601,51
10001,06606,51
10001,06611,53
10001,06612,50
10001,06615,54
10001,06807,29
10001,06810,52
10001,06811,54
10001,06820,35
10001,06824,48
10001,06825,50
10001,06829,47
10001,06830,27
10001,06831,28
10001,06840,38
10001,06850,39
10001,06851,40
10001,06854,38
10001,06855,39
10001,06877,46
10001,06878,29
10001,06880,43
10001,06881,43
10001,06883,46
10001,06897,42
10001,06901,32
10001,06907,34
10001,07002,8
10001,07003,10
10001,07004,18
10001,07006,16
10001,07009,14
10001,07010,5
10001,07011,11
10001,07012,11
10001,07013,12
10001,07015,12
10001,07016,17
10001,07017,11
10001,07020,5
10001,07022,4
10001,07024,7
10001,07026,10
10001,07027,19
10001,07029,9
10001,07030,2
10001,07031,7
10001,07032,8
10001,07039,17
10001,07040,14
10001,07041,16
10001,07042,12
10001,07045,22
10001,07047,3
10001,07050,12
10001,07052,14
10001,07054,23
10001,07055,10
10001,07057,9
10001,07058,20
10001,07059,28
10001,07060,24
10001,07063,25
10001,07066,19
10001,07067,19
10001,07068,17
10001,07070,8
10001,07072,8
10001,07073,8
10001,07074,7
10001,07075,8
10001,07076,21
10001,07078,18
10001,07079,14
10001,07080,25
10001,07081,17
10001,07083,14
10001,07087,2
10001,07093,2
10001,07095,20
10001,07097,4
10001,07101,9
10001,07102,9
10001,07108,10
10001,07109,9
10001,07110,9
10001,07111,13
10001,07112,11
10001,07201,12
10001,07203,15
10001,07204,15
10001,07205,12
10001,07302,3
10001,07305,5
10001,07306,3
10001,07403,25
10001,07405,25
10001,07407,12
10001,07410,14
10001,07417,21
10001,07421,35
10001,07424,15
10001,07430,24
10001,07432,19
10001,07436,23
10001,07442,23
10001,07446,22
10001,07450,17
10001,07456,28
10001,07463,20
10001,07470,18
10001,07474,19
10001,07480,31
10001,07501,15
10001,07506,16
10001,07508,16
10001,07511,16
10001,07601,10
10001,07603,8
10001,07604,8
10001,07621,12
10001,07624,15
10001,07626,13
10001,07631,10
10001,07641,14
10001,07642,18
10001,07650,7
10001,07652,14
10001,07657,6
10001,07661,12
10001,07662,11
10001,07666,9
10001,07675,17
10001,07676,17
10001,07701,27
10001,07712,35
10001,07715,41
10001,07716,24
10001,07719,39
10001,07721,25
10001,07724,31
10001,07726,35
10001,07727,39
10001,07728,38
10001,07730,24
10001,07731,43
10001,07733,27
10001,07734,22
10001,07735,24
10001,07739,28
10001,07746,30
10001,07747,26
10001,07748,24
10001,07751,31
10001,07756,37
10001,07757,30
10001,07758,22
10001,07762,41
10001,07763,39
10001,07801,31
10001,07821,41
10001,07822,46
10001,07823,55
10001,07826,49
10001,07827,55
10001,07828,40
10001,07831,50
10001,07832,57
10001,07834,27
10001,07840,44
10001,07847,34
10001,07852,36
10001,07853,41
10001,07856,36
10001,07860,47
10001,07866,30
10001,07869,31
10001,07871,39
10001,07876,35
10001,07882,52
10001,07901,19
10001,07920,30
10001,07921,35
10001,07930,36
10001,07932,21
10001,07936,19
10001,07940,22
10001,07945,31
10001,07960,25
10001,07980,27
10001,07981,23
10001,08501,50
10001,08502,40
10001,08505,56
10001,08512,41
10001,08520,43
10001,08527,46
10001,08528,42
10001,08530,55
10001,08536,42
10001,08540,43
10001,08544,44
10001,08557,48
10001,08560,54
10001,08601,48
10001,08609,54
10001,08618,54
10001,08620,53
10001,08628,54
10001,08648,50
10001,08690,51
10001,08701,48
10001,08723,49
10001,08724,46
10001,08733,53
10001,08735,53
10001,08742,46
10001,08753,54
10001,08759,56
10001,08802,53
10001,08805,31
10001,08807,34
10001,08809,48
10001,08812,27
10001,08816,30
10001,08817,26
10001,08818,26
10001,08820,22
10001,08822,47
10001,08824,37
10001,08825,57
10001,08826,48
10001,08829,48
10001,08830,20
10001,08831,36
10001,08833,44
10001,08835,34
10001,08837,23
10001,08840,23
10001,08844,38
10001,08846,29
10001,08848,59
10001,08853,42
10001,08854,28
10001,08857,29
10001,08859,25
10001,08861,21
10001,08863,22
10001,08871,27
10001,08872,27
10001,08873,31
10001,08876,36
10001,08885,45
10001,08901,30
10001,08902,32
10001,10001,0
10001,10002,2
10001,10003,1
10001,10004,3
10001,10005,3
10001,10006,3
10001,10007,2
10001,10008,3
10001,10009,1
10001,10010,0
10001,10011,0
10001,10012,1
10001,10013,2
10001,10014,1
10001,10015,2
10001,10016,0
10001,10017,0
10001,10018,0
10001,10019,1
10001,10021,2
10001,10022,1
10001,10023,2
10001,10024,2
10001,10025,3
10001,10026,4
10001,10028,2
10001,10029,4
10001,10031,5
10001,10032,7
10001,10033,7
10001,10034,8
10001,10036,0
10001,10038,3
10001,10039,6
10001,10101,1
10001,10128,3
10001,10278,2
10001,10282,3
10001,10301,10
10001,10302,11
10001,10304,10
10001,10305,11
10001,10306,14
10001,10308,15
10001,10309,18
10001,10312,17
10001,10314,12
10001,10451,6
10001,10452,7
10001,10453,8
10001,10458,10
10001,10459,7
10001,10460,8
10001,10461,10
10001,10462,10
10001,10465,10
10001,10466,12
10001,10467,10
10001,10469,11
10001,10471,11
10001,10472,8
10001,10473,8
10001,10504,30
10001,10506,35
10001,10509,50
10001,10510,29
10001,10512,51
10001,10514,31
10001,10517,38
10001,10520,33
10001,10523,23
10001,10528,21
10001,10530,21
10001,10532,27
10001,10536,39
10001,10538,17
10001,10540,43
10001,10541,44
10001,10546,32
10001,10548,35
10001,10549,34
10001,10550,13
10001,10560,45
10001,10562,30
10001,10566,38
10001,10567,38
10001,10570,28
10001,10573,24
10001,10577,24
10001,10583,19
10001,10589,43
10001,10590,42
10001,10591,23
10001,10595,25
10001,10598,39
10001,10601,22
10001,10603,23
10001,10604,24
10001,10605,22
10001,10701,14
10001,10704,13
10001,10705,12
10001,10707,17
10001,10708,15
10001,10709,17
10001,10710,16
10001,10801,15
10001,10901,27
10001,10918,44
10001,10920,27
10001,10921,44
10001,10924,48
10001,10925,36
10001,10926,39
10001,10932,54
10001,10933,50
10001,10940,53
10001,10949,41
10001,10954,24
10001,10956,27
10001,10960,24
10001,10962,20
10001,10965,21
10001,10976,19
10001,10977,25
10001,10980,33
10001,10981,43
10001,10984,31
10001,10988,49
10001,10990,40
10001,10992,48
10001,10994,24
10001,10996,44
10001,10998,50
10001,11001,15
10001,11003,16
10001,11004,14
10001,11010,17
10001,11020,14
10001,11021,14
10001,11023,14
10001,11030,16
10001,11040,16
10001,11050,16
10001,11101,2
10001,11102,3
10001,11103,4
10001,11105,4
33101,33002,9
33101,33004,19
33101,33008,21
33101,33009,15
33101,33010,6
33101,33012,9
33101,33013,7
33101,33014,11
33101,33015,13
33101,33016,11
33101,33017,15
33101,33018,13
33101,33019,17
33101,33020,17
33101,33021,17
33101,33023,15
33101,33024,17
33101,33025,16
33101,33026,18
33101,33027,17
33101,33028,19
33101,33029,20
33101,33030,27
33101,33032,22
33101,33033,25
33101,33034,30
33101,33037,46
33101,33054,10
33101,33055,12
33101,33060,31
33101,33062,33
33101,33063,33
33101,33064,35
33101,33065,34
33101,33067,36
33101,33068,30
33101,33069,31
33101,33071,32
33101,33073,36
33101,33074,35
33101,33076,36
33101,33077,32
33101,33082,17
33101,33101,0
33101,33109,4
33101,33114,5
33101,33119,4
33101,33122,8
33101,33126,6
33101,33128,1
33101,33129,2
33101,33130,1
33101,33131,1
33101,33132,1
33101,33133,4
33101,33134,5
33101,33135,2
33101,33136,1
33101,33137,3
33101,33138,5
33101,33139,4
33101,33140,5
33101,33142,3
33101,33143,8
33101,33144,7
33101,33145,3
33101,33146,6
33101,33149,6
33101,33152,8
33101,33153,6
33101,33154,9
33101,33155,7
33101,33156,10
33101,33157,15
33101,33160,12
33101,33161,8
33101,33162,10
33101,33163,12
33101,33165,10
33101,33166,8
33101,33167,8
33101,33168,8
33101,33169,11
33101,33170,21
33101,33172,10
33101,33175,13
33101,33176,13
33101,33177,18
33101,33178,11
33101,33179,12
33101,33180,13
33101,33181,9
33101,33182,13
33101,33184,13
33101,33185,16
33101,33186,15
33101,33187,21
33101,33189,17
33101,33190,18
33101,33193,16
33101,33196,18
33101,33197,16
33101,33257,15
33101,33265,12
33101,33266,6
33101,33283,13
33101,33296,13
33101,33301,24
33101,33302,25
33101,33303,24
33101,33304,25
33101,33305,26
33101,33308,29
33101,33309,28
33101,33311,25
33101,33312,22
33101,33313,26
33101,33314,20
33101,33316,23
33101,33317,23
33101,33319,28
33101,33322,26
33101,33323,27
33101,33324,24
33101,33325,24
33101,33326,26
33101,33327,27
33101,33328,20
33101,33330,21
33101,33331,22
33101,33332,23
33101,33334,28
33101,33335,28
33101,33345,27
33101,33351,28
33101,33355,25
33101,33422,57
33101,33424,54
33101,33426,52
33101,33427,39
33101,33428,39
33101,33429,40
33101,33431,42
33101,33432,40
33101,33433,39
33101,33436,52
33101,33437,52
33101,33441,37
33101,33442,37
33101,33443,37
33101,33444,47
33101,33445,47
33101,33454,57
33101,33460,59
33101,33461,59
33101,33462,56
33101,33463,57
33101,33467,57
33101,33474,57
33101,33483,48
33101,33484,47
33101,33486,40
33101,33487,44
33109,33002,12
33109,33004,19
33109,33008,22
33109,33009,15
33109,33010,10
33109,33012,12
33109,33013,10
33109,33014,14
33109,33015,16
33109,33016,14
33109,33017,18
33109,33018,16
33109,33019,17
33109,33020,17
33109,33021,18
33109,33023,16
33109,33024,19
33109,33025,18
33109,33026,20
33109,33027,19
33109,33028,21
33109,33029,23
33109,33030,29
33109,33032,23
33109,33033,26
33109,33034,31
33109,33037,46
33109,33054,12
33109,33055,15
33109,33060,32
33109,33062,33
33109,33063,34
33109,33064,35
33109,33065,36
33109,33067,37
33109,33068,31
33109,33069,32
33109,33071,34
33109,33073,37
33109,33074,35
33109,33076,38
33109,33077,34
33109,33082,20
33109,33101,4
33109,33109,0
33109,33114,8
33109,33119,1
33109,33122,11
33109,33126,9
33109,33128,4
33109,33129,3
33109,33130,3
33109,33131,3
33109,33132,3
33109,33133,6
33109,33134,7
33109,33135,5
33109,33136,4
33109,33137,4
33109,33138,6
33109,33139,1
33109,33140,3
33109,33142,6
33109,33143,10
33109,33144,10
33109,33145,5
33109,33146,9
33109,33149,4
33109,33152,11
33109,33153,7
33109,33154,8
33109,33155,10
33109,33156,12
33109,33157,16
33109,33160,12
33109,33161,9
33109,33162,11
33109,33163,13
33109,33165,13
33109,33166,11
33109,33167,10
33109,33168,10
33109,33169,13
33109,33170,22
33109,33172,13
33109,33175,16
33109,33176,15
33109,33177,19
33109,33178,14
33109,33179,13
33109,33180,14
33109,33181,9
33109,33182,16
33109,33184,16
33109,33185,18
33109,33186,18
33109,33187,23
33109,33189,18
33109,33190,19
33109,33193,19
33109,33196,20
33109,33197,18
33109,33257,17
33109,33265,15
33109,33266,9
33109,33283,16
33109,33296,15
33109,33301,25
33109,33302,26
33109,33303,24
33109,33304,26
33109,33305,27
33109,33308,29
33109,33309,29
33109,33311,26
33109,33312,23
33109,33313,27
33109,33314,21
33109,33316,23
33109,33317,25
33109,33319,29
33109,33322,28
33109,33323,29
33109,33324,25
33109,33325,26
33109,33326,28
33109,33327,30
33109,33328,22
33109,33330,23
33109,33331,24
33109,33332,26
33109,33334,29
33109,33335,29
33109,33345,29
33109,33351,29
33109,33355,26
33109,33422,58
33109,33424,54
33109,33426,53
33109,33427,41
33109,33428,40
33109,33429,40
33109,33431,42
33109,33432,40
33109,33433,40
33109,33436,53
33109,33437,52
33109,33441,38
33109,33442,38
33109,33443,38
33109,33444,48
33109,33445,48
33109,33454,58
33109,33460,59
33109,33461,59
33109,33462,57
33109,33463,58
33109,33467,58
33109,33474,58
33109,33483,48
33109,33484,48
33109,33486,40
33109,33487,44
10001,11201,3
10001,11204,9
10001,11205,4
10001,11206,4
10001,11208,8
10001,11213,6
10001,11215,5
10001,11218,7
10001,11219,7
10001,11223,10
10001,11224,11
10001,11226,7
10001,11228,9
10001,11230,8
10001,11231,4
10001,11232,6
10001,11234,9
10001,11235,11
10001,11236,9
10001,11238,5
10001,11351,9
10001,11355,8
10001,11357,9
10001,11358,10
10001,11359,12
10001,11361,11
10001,11362,13
10001,11364,12
10001,11365,10
10001,11366,10
10001,11367,9
10001,11368,6
10001,11369,6
10001,11372,5
10001,11373,6
10001,11374,7
10001,11375,7
10001,11377,4
10001,11378,4
10001,11379,6
10001,11385,6
10001,11405,11
10001,11411,14
10001,11412,12
10001,11414,9
10001,11415,8
10001,11418,9
10001,11420,10
10001,11421,8
10001,11422,14
10001,11427,12
10001,11428,13
10001,11432,10
10001,11434,12
10001,11435,10
10001,11507,18
10001,11509,18
10001,11510,21
10001,11514,20
10001,11518,19
10001,11520,22
10001,11530,18
10001,11542,21
10001,11549,19
10001,11550,19
10001,11552,18
10001,11553,21
10001,11558,20
10001,11559,16
10001,11561,20
10001,11565,18
10001,11566,23
10001,11568,21
10001,11570,19
10001,11572,20
10001,11576,18
10001,11577,18
10001,11580,16
10001,11590,21
10001,11596,18
10001,11694,14
10001,11702,35
10001,11703,35
10001,11704,33
10001,11706,38
10001,11710,24
10001,11714,27
10001,11715,50
10001,11716,46
10001,11717,39
10001,11720,48
10001,11722,42
10001,11725,37
10001,11727,53
10001,11729,34
10001,11730,42
10001,11731,36
10001,11735,28
10001,11738,50
10001,11741,48
10001,11743,31
10001,11746,32
10001,11749,43
10001,11751,40
10001,11753,24
10001,11754,40
10001,11756,25
10001,11757,33
10001,11758,28
10001,11762,28
10001,11763,53
10001,11764,54
10001,11766,52
10001,11767,44
10001,11768,36
10001,11769,45
10001,11772,52
10001,11773,25
10001,11777,50
10001,11779,46
10001,11782,48
10001,11784,50
10001,11787,42
10001,11788,41
10001,11789,55
10001,11790,46
10001,11791,26
10001,11793,25
10001,11796,46
10001,11797,28
10001,11798,33
10001,11801,25
10001,11803,27
10001,11804,28
10001,11953,55
10001,11967,59
10001,11980,56
10001,12508,52
10001,12512,59
10001,12533,58
10001,12542,59
10001,12543,52
10001,12550,53
10001,12551,54
10001,12553,49
10001,12575,51
10001,12590,58
10001,12771,55
10001,18324,58
10001,18336,56
10001,18343,59
10001,18371,56
10001,18938,59
10001,19054,59
10001,19067,57
July 11, 2007 at 12:16 pm
map_city2zip
==================
miami,FL,33101
miami beach,FL,33109
new york,NY,10001
new york city,NY,10001
ny,NY,10001
nyc,NY,10001
July 11, 2007 at 12:15 pm
Hi Lynn, Sorry for the slow response. I am not sure how to get you the info you requested except to paste it into the body. I cannot figure out...
July 11, 2007 at 12:14 pm
Thanks! For the great posts. I am using SQL2000 and as far as I know there are no plans to update. The cursor currently loops over about 120,000 records, and...
July 11, 2007 at 10:01 am
Viewing 9 posts - 1 through 10 (of 10 total)