Address Searching (sp?)

I have a form that inputs an address (city/state/zip/etc.). Basically I
need to search our database for this address, prior to it being entered.
Problem in that people type St. vs. Street vs. St, Ave. vs. Avenue vs. Ave,
etc. Anyone have an affective algorithm for searching for comparable
addresses? Just curious if someone has run into/solved this problem
effectively.
Thanks,
JamesThe problem has been solved quite effectively by address correction software
vendors. It might be quite a task to write a proprietary set of functions to
do the same thing.
Don't know if this is feasible for you but you could have a separate field
to store the street type and then provide a drop-down list so that the user
doesn't have the option to input a variant (such as Ave. instead of Avenue)
"James" wrote:

> I have a form that inputs an address (city/state/zip/etc.). Basically I
> need to search our database for this address, prior to it being entered.
> Problem in that people type St. vs. Street vs. St, Ave. vs. Avenue vs. Ave
,
> etc. Anyone have an affective algorithm for searching for comparable
> addresses? Just curious if someone has run into/solved this problem
> effectively.
> Thanks,
> James
>
>

Address Searching (sp?)

I have a form that inputs an address (city/state/zip/etc.). Basically I
need to search our database for this address, prior to it being entered.
Problem in that people type St. vs. Street vs. St, Ave. vs. Avenue vs. Ave,
etc. Anyone have an affective algorithm for searching for comparable
addresses? Just curious if someone has run into/solved this problem
effectively.
Thanks,
James
The problem has been solved quite effectively by address correction software
vendors. It might be quite a task to write a proprietary set of functions to
do the same thing.
Don't know if this is feasible for you but you could have a separate field
to store the street type and then provide a drop-down list so that the user
doesn't have the option to input a variant (such as Ave. instead of Avenue)
"James" wrote:

> I have a form that inputs an address (city/state/zip/etc.). Basically I
> need to search our database for this address, prior to it being entered.
> Problem in that people type St. vs. Street vs. St, Ave. vs. Avenue vs. Ave,
> etc. Anyone have an affective algorithm for searching for comparable
> addresses? Just curious if someone has run into/solved this problem
> effectively.
> Thanks,
> James
>
>

Address Searching (sp?)

I have a form that inputs an address (city/state/zip/etc.). Basically I
need to search our database for this address, prior to it being entered.
Problem in that people type St. vs. Street vs. St, Ave. vs. Avenue vs. Ave,
etc. Anyone have an affective algorithm for searching for comparable
addresses? Just curious if someone has run into/solved this problem
effectively.
Thanks,
JamesThe problem has been solved quite effectively by address correction software
vendors. It might be quite a task to write a proprietary set of functions to
do the same thing.
Don't know if this is feasible for you but you could have a separate field
to store the street type and then provide a drop-down list so that the user
doesn't have the option to input a variant (such as Ave. instead of Avenue)
"James" wrote:
> I have a form that inputs an address (city/state/zip/etc.). Basically I
> need to search our database for this address, prior to it being entered.
> Problem in that people type St. vs. Street vs. St, Ave. vs. Avenue vs. Ave,
> etc. Anyone have an affective algorithm for searching for comparable
> addresses? Just curious if someone has run into/solved this problem
> effectively.
> Thanks,
> James
>
>

Adding New Disk

When I add a new disk and put a file on it and make it part of the primary
filegroup, how does disk space get used? Basically my current disk is 90%
full and I'd like to relieve it as much as possible.
Files within a file group get filled in a proportion fill method that is
based of the amount of free space in the file. So if you added another file
some new data would be inserted into the existing one(s) but most would go
into the new one. At least until they leveled off. If your concerned it
would be best to BCP out all the data, truncate the tables, add the new
file(s) and then BCP the data back in. That would fill them more evenly and
place more of the existing data on the new files.
Andrew J. Kelly SQL MVP
"Brad" <me@.privacy.net> wrote in message
news:MPG.1b435bcab46a01ee98bdd7@.news...
> When I add a new disk and put a file on it and make it part of the primary
> filegroup, how does disk space get used? Basically my current disk is 90%
> full and I'd like to relieve it as much as possible.

Adding New Disk

When I add a new disk and put a file on it and make it part of the primary
filegroup, how does disk space get used? Basically my current disk is 90%
full and I'd like to relieve it as much as possible.Files within a file group get filled in a proportion fill method that is
based of the amount of free space in the file. So if you added another file
some new data would be inserted into the existing one(s) but most would go
into the new one. At least until they leveled off. If your concerned it
would be best to BCP out all the data, truncate the tables, add the new
file(s) and then BCP the data back in. That would fill them more evenly and
place more of the existing data on the new files.
Andrew J. Kelly SQL MVP
"Brad" <me@.privacy.net> wrote in message
news:MPG.1b435bcab46a01ee98bdd7@.news...
> When I add a new disk and put a file on it and make it part of the primary
> filegroup, how does disk space get used? Basically my current disk is 90%
> full and I'd like to relieve it as much as possible.

Adding New Disk

When I add a new disk and put a file on it and make it part of the primary
filegroup, how does disk space get used? Basically my current disk is 90%
full and I'd like to relieve it as much as possible.Files within a file group get filled in a proportion fill method that is
based of the amount of free space in the file. So if you added another file
some new data would be inserted into the existing one(s) but most would go
into the new one. At least until they leveled off. If your concerned it
would be best to BCP out all the data, truncate the tables, add the new
file(s) and then BCP the data back in. That would fill them more evenly and
place more of the existing data on the new files.
--
Andrew J. Kelly SQL MVP
"Brad" <me@.privacy.net> wrote in message
news:MPG.1b435bcab46a01ee98bdd7@.news...
> When I add a new disk and put a file on it and make it part of the primary
> filegroup, how does disk space get used? Basically my current disk is 90%
> full and I'd like to relieve it as much as possible.

Adding Borders in a matrix report RS 2005?

Hello,

I am wondering if anyone has come across a problem when you try to get formatting like this one below in a matrix report, RS 2005. Basically, I would like to have a border for every question and its related columns. Any help is greatly appreciated.

Thanks!

1. Question

1.SubQuestion

Data

2.SubQuestion

Data

3.SubQuestion

Data

4.SubQuestion

Data

5.SubQuestion

Data

2. Question

1.SubQuestion

Data

2.SubQuestion

Data

3.SubQuestion

Data

4.SubQuestion

Data

3. Question

1.SubQuestion

Data

2.SubQuestion

Data

3.SubQuestion

Data

Hello,

I played a little bit more today with the challenge above and was able to come up with some conditional formatting for a SubQuestion column which may be helpful in creating a border line for. So in RS 2005, I select a SubQuestion cell and go to View/Properties/BorderStyle/Top and paste the following expression statement: =IIF(LEFT(Fields!SubQuestText.Value,1) = "1", "Solid", "None") which copies automatically to BorderStyle property that looks like this:None, , , =IIF(LEFT(Fields!SubQuestText.Value,1) = "1", "Solid", "None") BorderColor property is set to Black. By using the following statements above, I would like to create a border line above every Subquestion cell value that starts with 1. Right now, this code generates a top border for the last question. Maybe someone has some ideas how I could generate a top border above Subquestion cells including values starting with "1"?

Thanks for your help!

|||

Hi!

I have a similar problem, did you get any solution?

Thank you!

Adding Borders in a matrix report RS 2005?

Hello,

I am wondering if anyone has come across a problem when you try to get formatting like this one below in a matrix report, RS 2005. Basically, I would like to have a border for every question and its related columns. Any help is greatly appreciated.

Thanks!

1. Question 1.SubQuestion Data 2.SubQuestion Data 3.SubQuestion Data 4.SubQuestion Data 5.SubQuestion Data 2. Question 1.SubQuestion Data 2.SubQuestion Data 3.SubQuestion Data 4.SubQuestion Data 3. Question 1.SubQuestion Data 2.SubQuestion Data 3.SubQuestion Data

Hello,

I played a little bit more today with the challenge above and was able to come up with some conditional formatting for a SubQuestion column which may be helpful in creating a border line for. So in RS 2005, I select a SubQuestion cell and go to View/Properties/BorderStyle/Top and paste the following expression statement: =IIF(LEFT(Fields!SubQuestText.Value,1) = "1", "Solid", "None") which copies automatically to BorderStyle property that looks like this:None, , , =IIF(LEFT(Fields!SubQuestText.Value,1) = "1", "Solid", "None") BorderColor property is set to Black. By using the following statements above, I would like to create a border line above every Subquestion cell value that starts with 1. Right now, this code generates a top border for the last question. Maybe someone has some ideas how I could generate a top border above Subquestion cells including values starting with "1"?

Thanks for your help!

|||

Hi!

I have a similar problem, did you get any solution?

Thank you!