If you know the exact path and name of the file you are looking for then try xp_FileExist:

declare @FilePathName varchar(100)

declare @file_exists int

set @FilePathName = 'L:\temp\Test.txt'

EXECUTE master.dbo.xp_FileExist @FilePathName, @file_exists OUTPUT

if...

One possibility is that the plan used by the stored procedure was based on statistics that existed when the procedure was made and that the statistics changed considerably by the...

With the types of queries you mentioned you should be ok on performance since they do not require you to parse the xml. That is just an assumption on my...

Is there at least some commonality between the forms? For example, entry date, name of person filling out the form, key place, incident date.

Do you have any sense on how...

hi

I need to write a stored procedure to insert into Boat and quote tables.

The first 4 tables are good. After that I need to write a insert stored procedure by...

Definitely not select into. Break the update into batches. Don't try to update the whole table at one go.

There was another question just like this in the last couple of...

Yes there is. This site has an article called Fragmentation 101 that is a good place to start.

You're welcome. Thanks for letting us know it worked for you.

Why are you disabling your employee table triggers? Won't that make it possible for records to be added & updated that never get your idm table? Are you trying to...

In what way is EntryDate "2007-01-17 14:47:29.000" the latest one for ASOFDATE? All of your example ASOFDATEs are 2007-01-01.

There is no need to include upper() in the where clause. TSQL is not case sensitive. Since the minumum allowable amount of space may vary between systems it makes more...

You're welcome. Good to hear you fixed it.

When you say it works for 1 row do you mean that it works for any 1 row or one row in particular? It may be that one of the...

Assuming you want to do something like select Aval from the table var where fld = second parm, the answer is no. You cannot use dynamic sql in a function.

If you have to substitute tables, then do the substitution like this:

declare @TableName nvarchar(255), @sql nvarchar(500)

set @TableName = 'AdventureWorks.HumanResources.Employee';

set @sql = N'SELECT * FROM ' +...