Hi,

Thanks for your answers Michael and Martin, that explains it quite well for me.

Thanks again.

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!

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

HI,

Nevermind. My account had become disconnected from the domain overnight.

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

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

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

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

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

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

Ill try nvarchar next time..

I imported it into MS Access first and then into SQl Server.

pretty sure that doesn't work in 2000 :>

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

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

Thankyou.