you have to join against the master table of all the departments;

otherwise if it doesn't exist in the employees table you cannot display it

something like this:

select

alldepartments.department ,

...

both bcp and the more robust sqlcmd have the ability to be fed a query and output the results to a file;

that is your best choices, unless you write/find a...

I'm guessing you are just coming on board with a shop that does this? I would say they must have that software in their shop already; I would lean more...

its that integer division raising it's ugly head again;

both counts are INT values, and SQL figures if you do any math(add,subtract, muultiply or divide) to two integers, the answer must...

doh! i was looking for that kind of logic hole, too small-o-variable, glad you found it!

not that I'm particularly evil or anything, but if I joined a month before, say Jeff Moden did, does that mean if I change my username now to "Jeff Moden",...

i thought i read here on the forum that xp_delete would only delete certain extensions of for file names....

when i ggogled "SQL SERVER xp_delete file extensions", i found some different...

sp_getDDL returns the complete CREATE TABLE command in TSQL; I've been using it in a DDL audit trigger, and also using it more often then sp_help.

Could some of you folks...

-=oops i did not see you were using an output parameters...thought you wanted the RETURN; i'm testing the other way now, and will report back, sorry...jumped to conclusions=-

oops old...

user defined functions are a limited, more specialized form of stored procedure. as a result, you don't have a full set of features. as specialized functions, they can return some...

could it be the compatibility level of the database you are using?

you'd get that syntax error if you were in a non-compatibility 100 database...

that's the first thing I'd check;

for example,...

are they real duplicates, as in the image is in the database twice, or two different images of the the same print?

if they are the same image twice, then you...

Why aren't you using Bulk Insert? there's lots of performance examples on the web about people loading gigs of data; I've inserted a 13 gig raw text file into a...

Seth thank you for the compliment! it means a lot coming from someone like yourself, who spends a lot of time trying to help folks here.

i guess the issue was...

as far as i know, it needs no modifications.

if you needed to search for "bill@somewebsite.com" for example, it would just be

EXEC UGLYSEARCH 'bill@somewebsite.com'

maybe i missed that you had an...