I'll have to remember that as well. Didn't have time to do any testing, had an unscheduled meeting.

😎

Jeff,

Have you tried an accent sensitive collation?

😎

Is there any additional data in the file you get, such as PO or Order numbers that can be used to tie sales and returns together?

😎

The problem is not with the conversion from @the_date_string to @the_date. SQL is try to convert the 'SELECT ' and the ' AS theDate' strings to a datetime value...

True, In SQL 2008 you can get the date portion just by assigning a datetime value to a variable of the DATE type.

😎

Another way to do this that I learned on SSC, and just as easy is this:

declare @DateOnly datetime

set @DateOnly = dateadd(dd,datediff(dd, 0, getdate()), 0)

😎

We are currently running ERStudio version 7.1.2 Build 4769, and it supports converting ERWin ERX files from version 2.6 through 3.52. There is a newer version of ERStudio out,...

Just checking, as I have seen people just running full backups with the database using the Full recovery model.

Unfortunately, I can't see the screen print.

Can you provide a screen print of a DIR of the directory you are trying to delete files in?

One other thing, I'd change your naming conventions for stored procedures. Every time you execute the procedure sp_AdminListApplicants, SQL Server will first look in the master database for the...

Just checking, what recovery model is your database using?

😎

I understand the confidential nature of the data. I was hoping you could come up with some generic data and structures that mimic what you are trying to do...

Not really much help for me. As i look at what you are asking, I actually see two missing pieces to helping you. The first, is a general...

The problem I am having in trying to answer your question is not knowing the data you will be loading. Having an idea of the source data would greatly...