Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dineshrajan_it
Posting Yak Master
217 Posts |
 Posted - 2008-03-17 : 02:06:45
|
| Hi.i have a sp and a function.declare @vemail varchar(1000)set @vemail = 'dineshrajanmt@gmail.com,123@yahoo.com'1)select * from #TMPS INNER JOINDBO.fn_DelimitSr(@emailcontact)ON vemail = number2)select * from #TMPS where vemail in(DBO.fn_DelimitSr(@emailcontact))whihc of above two will be better and perform faster.Thanks |
|
|
dineshrajan_it
Posting Yak Master
217 Posts |
Posted - 2008-03-17 : 02:27:31
|
| Hi.iam sorry pls change @email to @emailcontact. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-03-17 : 05:04:05
|
| http://weblogs.sqlteam.com/mladenp/archive/2007/05/18/60210.aspxMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Which is better