I would load those filenames into a table and then strip out the timestamp part of the filename and then select the file based upon the earliest occuring timestamp

I don't have a sample, but from interviewing people what I expect would be for you to list your skills, qualifications and experience related to SQL - remember...

Reporting services is just a .net application that will run on any server with IIS and is installed as any other application.

Do they have a reason for not supporting...

When you check the variable value before execute does this contain valid SQL? and does this SQL run correctly when you run it in SSMS?

Is the variable...

What part do you want more information on?

There is a nice example of the For-Each loop here

http://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx

your solution would be close to this, except you need to...

This is possible though it would require a custom script , you could use the Outlook object to connect to MS outlook, or if you are using Web...

I would use a For Each loop container to loop through the files and extract the file name.

Inside the container

-insert these filenames into a staging table.

-select filename based on minimum...

you can use MONTH

SELECT MONTH(GETDATE())

or for the Month name

SELECT DATENAME(MM,GETDATE())

The best way I know of to strip out the time from date is;

SELECT CAST(FLOOR(CAST(GETDATE() AS FLOAT)) AS DATETIME)

to show data from 10 days ago you can use the...

If this is the same SQL safe that I am thinking of (backup tool) then I would be more concerned with the fact that you are the trusting the safety...

Larry Brister-297916 (11/16/2009)

---

My code is below...

The new tables getting inserted ito will have some data already and the custID is the pKey...so I HAVE to pick that up each time...

.dbf files are from dBase

http://en.wikipedia.org/wiki/DBase

you should be able to create an ODBC connection to this file to import the data either using SSIS or any other...

That is correct Google will block you in an instant if you hit their servers with too many requests per minute.

This assuming that the reason for writing a...

This is the code i use [lifted directly from MS]

select object_name(i.object_id) as objectName, i.name as indexName,

...

from BOL ;

SCOPE_IDENTITY

Returns the last identity value inserted into an identity column in the same scope

so you will always get the max id when used in that way.

I would not...