Zadj

Hi lebanese007, If you are wanting a script that you can run to clean up the data in the table you can try the solution below. If this is an ongoing issue then it may be worth looking at putting a check during the insert to stop these additional rows. …

Hi, The distance calculation that sahoong used appears to work fine. Here is a test script that shows it selects the correct records. [code] Create table #COMPANY ( company_id int, company_name varchar(100), premise varchar(10), street varchar(30), town varchar(100), postcode char(7), x_loc int, y_loc int, ) insert into #COMPANY values(1,'A','','','','',4,3) insert …

Hi sprdthword, I've had to do this in the past and found that there are several pitfalls due to the day that the week starts can be changed on the server. I eventually found a solution that appears to always work. It has been running production code for a while …

Hi, I'm trying get some summary results from two related tables. I'm looking to find the most efficient way to return this data in one result set. The tables can be summed up as follows: [code] MainTable MainID INT, Description VARCHAR(50) Eg: MainID Description 1 John 2 Adam 3 Fred …

Hi, I've run into a situation where I can not see how to write efficient code to perform a check that I need to do. I am running on MSSQL 2005 The check is to compare a varchar passed in to the stored procedure against the words in a table. …