I do something similiar (format YYYYnnnnn) but it is done in a VB6 App.

Basicly I have a table with one record that has the last number used.  I read in...

Try this:

UPDATE table

SET col1 = (SELECT ...), col2 = (SELECT ...)

WHERE predicate

Hope this helps.

Steve

I am the GIS DBA for a County Government for mapping.  I understand the database more that the GIS Tools.

Currently our maps are maintained with Micro Station from Intergraph and...

If you are looking at migrating data, dts works good.  I migrated from Informix to SQL-Server a few years ago.  Like jcfilth said, you need an ODBC driver set up...

I just saw in a mailing from Microsoft that if you attend the MSDN Event "Winter Program 2005" that you will receive a free copy of SQL Server 2005 Beta...

Thank You.

I'm sure I can figure out a way based on your suggestions.  Now I have to figure out just how automated I want to make it.

Steve

I had an application where I wanted to be able to query on address that had an odd or even house number (were on the same side of the street).

bldg_num...

Just a wild guess, did these problems occur the weekend of the time change?  Maybe the jobs ran twice.

Steve

I know you said "Never mind", but here is a subroutine that I put together to will run dts for whichever package you desire.  There are references to other subroutines...

Did you try recreating the link after the migration?  I had to recreate mine after our migration but we not only migrated to SQL 2000 but to a new server...

I think maintenance plans are a very useful tool.  I'm sure that they have their limitations and many prefer to write their own t-sql.  One thing I really like is...

Why do you want to give them the db_owner role?  If it is mainly to allow them to create tables look at the db_ddladmin role.  According to BOL it allows...

Just an update.

The query that involved a self join took too long (5-8 sec).

I opted instead to create a permanent table of legal_full and reload it every night from a...

You haven't given enough information to know if the pay is reasonable or not.  What location are you?  Are you talking US Dollars?

Much depends upon your location.  What is the...