isnt that like having standards for the sake of having standards, if it doesnt matter what the standards are aslong as one abides by them, why have them - they...

I would expect the DBA to make the decision on naming conventions, I have made the mistake of letting Data Administrator and Analysts set names for various objects and the...

neat. you have one of those t-shirts too ..

I assume, she has a valid server login on the SERVER aswell as a valid database user, in the database?

 -- Alex

i've used to use the BCP program to import data and never had a problem, aslong as I didnt get the row and column terminators confused - which i do...

Hi Stacey,

Are you guys using Active Directory Groups, one problem I have encountered quite often, if when one server is in a different domain, to the logged in user.

There...

Mitch,

(two things?)

(1)

Do you need to perform the operation using dynamic SQL?

Can you not do something similar to:

SET @quarter = 'Q1' + '2004'

insert into TableMitch (key, field1, field2)

values (@quarter, 'dummy', 'dummy')

SELECT...

Absolutely, David.

That would probably be the most efficient way of doing it, although it will add 1 more column to your insert.

if you have many other tools accessing this...

yes, i should have mentioned that.

i do believe there is already quite a few SQL udf source available on the web, but whether they violates any implied licenses from Lawrence...

Yes, I agree - there are better versions on the same principle available, for example double-metaphone works pretty well (atleast its better) and it handles ethnic names alot more gracefully.

I wasnt sure exactly what you mean, David Poole has one suggestion, I read your request from a different point of view, and took it as meaning a sounds like match such...