Of course Sergiy is right, The idea of building a name parser that is 100% accurate when there are no rules about the names to parse is absolute lunacy. ...

If you have a large number of names to process I think reading the SQL Server Central Article

The "Numbers" or "Tally" Table: What it is and how it replaces a...

I just read your response. You are definitely right about encapsulating the logic into a function. It does make things much cleaner, and it never occurred to me...

If you really need all all inserts, updates, and deletes on all tables, perhaps you should look into using a third party transaction log reader. Of course this...

I use the power function to accomplish this task.

SELECT RIGHT(power(10,@TotalLength) + @myInt,@TotalLength)

I did use

SELECT RIGHT(Convert(varchar,(power(10,@TotalLength) + @myInt)),@TotalLength)

but found that I could eliminate the convert function from the statement.

Thanks

Todd P...

Thanks, I think I get it now. I thought the Top filter of the subquery would be applied first and therefore the search for a match would be limited...

Although It is not to your scale.  We have a large raster (40gb) but it doesn't change very often.  At ArcSDE 9.0, ESRI Licenses changed so that you can run...

There is an excellent article about hierarchies in Joe Clecko's book SQL For Smarties.  But it involves some upfront work on the resource table.  If you can alter the database...

I think the summary at the end of the article has got it right.

"It's a good idea in theory, but I'm not so sure that I want it implemented in...

For What its worth have you tried.

INSERT INTO

INSERT INTO

OpenRowSet('Microsoft.Jet.OLEDB.4.0'

,'Text; Database=D:\External'

select

Convert(Char(10),au_id),

Convert(Char(20),au_lname),

Convert(Char(20),au_fname),

Convert(Char(15),phone),

Convert(char(20),address),

Convert(Char(10),city),

Convert(Char(10),state),

Convert(Char(5),zip),

Convert(Char(10),contract)

from dbo.authors

When I tried the example I experianced truncation issues because field defs between pubs.authors and authors2.txt did...

We have many access applications with a SQL back end.  We Utilize a local access table to store the connection information and visual basic for applications code to link the...