Viewing 15 posts - 25,276 through 25,290 (of 26,487 total)
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
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...
January 29, 2008 at 12:43 pm
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...
January 29, 2008 at 11:36 am
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...
January 29, 2008 at 10:29 am
Viewing 15 posts - 25,276 through 25,290 (of 26,487 total)