Check out this thread:

http://www.sqlservercentral.com/Forums/Topic443935-146-4.aspx#bm445106

😎

Here is another way to do it:

CREATE Function GetMonthEnd(@Date DateTime)

Returns DateTime

AS

Begin

Return (dateadd(mm, datediff(mm, 0, @Date) + 1, 0) - 1)

End

Could you provide the DDL for the entire sp, not just the query it is running?

thanks

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?

😎