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...

Yes, you may want to look at upgrading from SQL Server 2000 to SQL Server 2005 (maybe even SQL Server 2008 as it comes out this year).

Standard suport for SQL...

I pulled this from another thread: http://www.sqlservercentral.com/Forums/Topic342856-19-1.aspx#bm343852

All you need to do is basically store your command in a global variable. You can create a global variable by right-clicking the...

I used SQL Mail at my last employer. We had to install Outlook on the server and setup a mail profile. For the most part, it was reliable....