Viewing 15 posts - 25,276 through 25,290 (of 26,490 total)
February 6, 2008 at 7:54 am
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
February 5, 2008 at 4:42 pm
Could you provide the DDL for the entire sp, not just the query it is running?
thanks
February 5, 2008 at 4:07 pm
I'll have to remember that as well. Didn't have time to do any testing, had an unscheduled meeting.
😎
February 5, 2008 at 12:17 pm
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?
😎
February 5, 2008 at 11:06 am
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...
February 5, 2008 at 10:29 am
True, In SQL 2008 you can get the date portion just by assigning a datetime value to a variable of the DATE type.
😎
February 5, 2008 at 7:03 am
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)
😎
February 4, 2008 at 10:56 pm
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,...
January 31, 2008 at 10:13 am
Just checking, as I have seen people just running full backups with the database using the Full recovery model.
January 31, 2008 at 7:06 am
Can you provide a screen print of a DIR of the directory you are trying to delete files in?
January 30, 2008 at 12:54 pm
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...
January 30, 2008 at 12:42 pm
Just checking, what recovery model is your database using?
😎
January 30, 2008 at 9:45 am
Viewing 15 posts - 25,276 through 25,290 (of 26,490 total)