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...

your psuedo code for your table wasn't readable to me, and oyu didn't provide any real, concrete CREATE TABLE or data for us to use.

here's a quick example i fleshed...

here's my version:

it returns a dataset of what matched, so you can drill down to it:

--ok, really you only need to search columns that are of type

--varchar,char,nvarchar and ntext....

--you...

so if you had a report, and say you wanted to barcode some invoice number, right, you would just add an IMG tag and build the SRC dynamically;

Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
 

it doesn't get much easier than what Gianluca showed you:

i took that code, threw it on a web server, but had to hunt down the bar code font:

in my case,...

create an role or an application role,and add the windows users to the role? then they never need to touch the server password, they just have to have access to...

Thanks Jamie; that's about how i would have tackled it too, but i thought there was some new sys views or the DMV Data Management Views that might identify...

temp tables are dropped when you are done with them.

a foreign key prevents something from being dropped before it's child references. If you disconnect your spid, then if foreign keys...

numeric (38,0) would be 38 significant digits, NONE to the right of the decimal place.

you want numeric(38,6) for example...38 digits, so that would be 32 to the left of the...

ok, it's making a little more sense; do all the staging tables have a common layout, or, as in your example, they might be missing some columns? is there ONE...