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 |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2008-02-05 : 05:37:06
|
| here's what i need to do - i'm not sure the best way1. return a recordset based on my select and criteria (this is what my sp currently does)2. - i also want it to for each record -- loop through all the records for that date and site and find matches - i need to write code as to what matches what - i have this written in asp but think it will be much faster in sql - can this be done - looping through and comparing the string in the first recordset with that in the secondn for similarities.? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-05 : 05:58:19
|
| 1st one is ok.Didnt quite understand 2nd point. Can you elaborate? |
 |
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2008-02-05 : 06:07:19
|
| ok.. trying to get advice.. not sure if anywhere in this forum to get paid help...basically waht i'm trying to do is while looping through my recordset - i want to check for similar fuzzy records based on a criteria i put in - so for example i'll look at all the records and if all the characters are the same except for the last - i'll count that as a possible match and give it an accuracy level based on the rule i set...so in the end i get my returned my list and with my list any possible matches for anything on that list - is this possible to do in a stored procedure? in asp it works well but very slow as for each record i have to go back to the database to look for matches so i though in sql this would go much quicker. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-05 : 06:17:49
|
| I think it sounds as if you need a table valued User Defined Function to perform this function and return you with a table. |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2008-02-05 : 06:52:13
|
| can you elaborate a little more --any examples or articles you can refer me to.my knowledge of sql is not that good.. |
|
|
|
|
|
|
stored procedure - can i return recordset and sub