I use Scriptio to generate .sql files for the db schema. Its a free download. http://www.sqlteam.com/publish/scriptio/

On the 2nd tab, I specify One File per Object. Then I use a RE...

What is an image folder?

Do you want to populate a table with the names of files from a specified folder?

Take a look at Forums Home » Programming » General » Binary data pros/cons.

I started using Scriptio a few weeks ago. It is a .net app that you can get for free from http://www.sqlteam.com/publish/scriptio. The main reason why I use it is...

These links and hints were very helpful to me. Thanks you!

I'm not sure if it’s true but I read or heard that MS implemented http://terraserver.microsoft.com/ using SQL 2000 to prove that SQL is up to the task of processing lots...

The requirements are simple. But human resources are limited too. 1 guy, about 1 hr per day for the whole project: UI forms, DB schema & SPs, reporting, doc &...

Very well said. I get it, Thanks! Closed.

I think we are not talking apples & apples, but it doesn't appear to be a DDL issue. Yes, the posted solutions will return the correct results. And many...

I agree. I don't think the problem has been solved in this thread (w/o using Dynamic SQL), how about you?

Being a newbie to SQL, I don't know how to code...

That link has some excellent tips on dyn sql. Thanks.

Your IF/ELSE blocks make sense to me but I don't think they solve the problem. The problem is that the...

Thanks for the ideas.

I looked at that link and see he is refering to something different. My db has one-to-many relationships (3 of them) to address, vs. a lookup...

Some good ideas.

I failed to mention that CustomerID is a Customer.ID identity, that MediaID is a Media.ID identity, and that GroupID is a Group.ID identity. Thus the proposed logic...