Viewing 15 posts - 16 through 30 (of 56 total)
Hi,
Thanks for your answers Michael and Martin, that explains it quite well for me.
Thanks again.
October 6, 2009 at 6:10 pm
Full path was required:
"c:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\dtexec.exe" /DTS "\MSDB\packagename" /SERVER servername /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING V
thanks!
September 20, 2009 at 5:51 pm
Hi,
I have been getting the same error for a while now. I expect it may have had something to do with a windows update that was rolled out by our...
August 3, 2009 at 4:20 pm
HI,
Nevermind. My account had become disconnected from the domain overnight.
July 14, 2009 at 5:40 pm
Hi,
I once worked with a database where the table design (primary key in particular) had been made with alias's in mind. I really liked it and found it very useful...
May 7, 2009 at 4:22 pm
Hi,
Thanks for your reply.
I am investigating this avvenue, however my server admin cannot seem to find the DTSexec executable on the server as yet. I am hoping he is making...
April 29, 2009 at 4:28 pm
Hi,
I worked it eventually
Create a variable like:
RIGHT("0" + (DT_STR, 2, 1252)DATEPART("dd", GetDate()), 2) + "." + RIGHT("0" + (DT_STR, 2, 1252)DATEPART("mm", GetDate()), 2) + "." + (DT_STR, 4, 1252)DATEPART("yyyy",...
February 18, 2009 at 5:45 pm
hi,
I managed to re-write my function to use a while-loop istead of recursion.
ALTER FUNCTION GET_PREVIOUS_MENTAL_HEALTH_DAYS
(
@EPISODE_NUMBER NUMERIC
)
RETURNS INT
AS
BEGIN
DECLARE @TOTAL_PREVIOUS_DAYS AS INT
DECLARE @PREV_DAYS AS INT
SET @TOTAL_PREVIOUS_DAYS = 0
WHILE @TOTAL_PREVIOUS_DAYS <= 60 AND...
February 5, 2009 at 4:58 pm
Hi,
Expected Result
--------------------
SB_EPISODE_NUMBER, PREVIOUS_DAYS
12345, null
12346, 17
12390, null
12345, 5
Not all current psych admissions will have any prior psych admission\stay
The previous admission may or may not be psych stay
Only stays within the...
February 5, 2009 at 3:23 pm
Hi,
I have the EXACT same question.
I hope we get an answer :>
Hopefully regular backups dont count, but only actual data modification\reads from non system tables.
PS. My database is an old...
October 22, 2008 at 6:56 pm
Ill try nvarchar next time..
I imported it into MS Access first and then into SQl Server.
September 30, 2008 at 4:16 pm
SELECT *,ROW_NUMBER() OVER (ORDER BY fldName) FROM #Test1
pretty sure that doesn't work in 2000 :>
September 23, 2008 at 4:22 pm
Adrian Nichols (9/23/2008)
If you're going to do this in Crystal, I can't remember if this is correct or not, but I have a nagging feeling that there is a special...
September 23, 2008 at 4:19 pm
It may be of some assitance to stop the user on the web page from submitting the form twice.
function pleaseWait( btnsubmit, btnwait )
{
document.body.style.cursor = "wait";
var btn = document.getElementById(btnsubmit);
btn.style.display="none";
var btn =...
September 11, 2008 at 12:07 am
Viewing 15 posts - 16 through 30 (of 56 total)