帮小妹优化一条SQL语句拉，谢谢各位！！！

[miaohong2820]

sqlgroupby="select bdn_proid from bid_detailed_net where charindex(bdn_proid,'"&rs("bt_pid")&"')>0 group by bdn_proid"


"&rs("bt_pid")&"是以,隔开的语句，实际为:select bdn_proid from bid_detailed_net where charindex(bdn_proid,'20070209181810,20070209181827,20070209181839,20070209181849,20070209181902,20070209181914,20070209181925,20070209181937,20070209181947,20070209182003,20070209182016,20070209182030,20070209182039,20070209182101,20070209182112,20070209182126,20070209182135,20070209182144,20070209182203,20070209182228')>0 group by bdn_proid


这样写好象很慢的，怎么写能加快速度啊！！帮帮忙啊！！！

[dawugui]

应该没有办法.你的数据没有规律.

[kafuwei]

如果你的 bid_detailed_net 表 关于 bdn_proid 有索引的话，可以用下面的SQL：


select distinct bdn_proid from bid_detailed_net where bdn_proid='20070209181810' union select distinct bdn_proid from bid_detailed_net where bdn_proid='20070209181827' union select distinct bdn_proid from bid_detailed_net where bdn_proid='20070209181839' union select distinct bdn_proid from bid_detailed_net where bdn_proid='20070209181849' union select distinct bdn_proid from bid_detailed_net where bdn_proid='20070209181902' union select distinct bdn_proid from bid_detailed_net where bdn_proid='20070209181914' union select distinct bdn_proid from bid_detailed_net where bdn_proid='20070209181925' union select distinct bdn_proid from bid_detailed_net where bdn_proid='20070209181937' union select distinct bdn_proid from bid_detailed_net where bdn_proid='20070209181947' union select distinct bdn_proid from bid_detailed_net where bdn_proid='20070209182003' union select distinct bdn_proid from bid_detailed_net where bdn_proid='20070209182016' union select distinct bdn_proid from bid_detailed_net where bdn_proid='20070209182030' union select distinct bdn_proid from bid_detailed_net where bdn_proid='20070209182039' union select distinct bdn_proid from bid_detailed_net where bdn_proid='20070209182101' union select distinct bdn_proid from bid_detailed_net where bdn_proid='20070209182112' union select distinct bdn_proid from bid_detailed_net where bdn_proid='20070209182126' union select distinct bdn_proid from bid_detailed_net where bdn_proid='20070209182135' union select distinct bdn_proid from bid_detailed_net where bdn_proid='20070209182144' union select distinct bdn_proid from bid_detailed_net where bdn_proid='20070209182203' union select distinct bdn_proid from bid_detailed_net where bdn_proid='20070209182228'

[marco08]

用EXISTS作存在判断试试

[一者仁心]

select bdn_proid from bid_detailed_net where bdn_proid in "&rs("bt_pid")&"

[simonhehe]

晕了

[云中客]

20070209182203
应该是类似编号的东西吧,可以利用SQL语句或其他编程中的方法,将它们合成一个字符串,然后使用在SQL语句中就可以了

[弘毅致远]

用编程来实现吧..

[AspxGrasp]

为什么把这么多编号放到一个字段,...这样以后很麻烦.