Well first of all, why don't you use (n)varchar in this case (design and procedure)?

And your answer with only the password case sensitive :

/* no need to return the username...

Lol, there's nothing wrong with your solution... it just looks funny to me being less than 100 yo .

would this be the "correct" join to use??

from customers a

     cross  join items b

Ok, can't help you much there... works fine on sql server.

What error does it throw?

What's wrong with the solution I provided?

What else do you need to do besides checking if it's a real id?

Do you need to extract it to another field, update the...

I don't see how adding a line of code to do a copy is longer than recreating a process, but anyhow...

Checking for the existense of a file every few minutes...

This works for me... maybe you can expand from that :

select

isnumeric(rtrim(ltrim('hug1...

Just confused here about a small detail... I read in another article that the express version could do more than 10 operations at the same time and now in this...

First of all.  This sounds like you need to create a relation between those 2 tables to guarantee data integrity.  The first thing you can do is to set this...

That's a nice idea, but it doesn't solve the problem that first have to script all the procs to a file before search... that's why I preffer a on server processing. ...

You can always create a linked server to a flat text file, but since I think it's not possible to index a text file, I don't see much of a...

R u sure???

LEFT

(name, LEN(rtrim(name