Thanks for all the input. I'm having partial success with my procedure now, but I think I should post the entire code since there were questions about string concatenation...

I am using sp_executesql. This code snippet is based on Erland Sommarskog's article on Dynamic Search and is found inside my @sql parameter.

Anyway, I figured out to...

Hello all,

I found this post searching for a solution to correctly escape quotes surrounding wildcards on either side of a parameter. Here is my code:

IF @companyName IS NOT NULL

SELECT...

I didn't design the database. 😀

Thanks for the answers, though. 🙂

I would like to be able to update the development SQL Server periodically from the Production box so that in development we would have the most current identity values for...

Thank you, I changed the design to make it simpler.

When I started this was supposed to be a PDF database, but then my requirements changed to make it a documents...

ALZDBA (2/17/2009)

---

it is a common design issue to just use nullable columns !

DocDesc nvarchar(50), null

Filename nvarchar(25), null

Filepath nvarchar(100), null

InsertDate datetime, null

UpdateDate datetime, null

FK LangID smallint, null

Avoid...

thank you, greg, that does help.

now i just need to figure out how to make this work with strongly typed datasets in visual studio 2005

My database is designed to store information and filepaths for all the documents in our organization.

Here are my tables:

tblDocument

PK DocID int, not null

FK DocTypeID smallint, not null

FK DivisionID...