Forum Replies Created

Viewing 15 posts - 16 through 30 (of 56 total)

  • RE: Foreign Keys Vs Indexs

    Hi,

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

    Thanks again.

  • RE: Using Excel Connection manager on 64 bit servers

    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!

  • RE: Can't Open Existing or Create New SSIS projects

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

  • RE: Job Failing due to Server access permissions

    HI,

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

  • RE: Enhancing the readability of your code: Table aliasing in sql

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

  • RE: Execute SSIS task problem

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

  • RE: Excel Datasource - Changing sheet name

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

  • RE: Recursive Function problem

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

  • RE: Recursive Function problem

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

  • RE: How to check when a database was last updated

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

  • RE: Import Data From Excel as varchar

    Ill try nvarchar next time..

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

  • RE: Row number returned in resultset

    SELECT *,ROW_NUMBER() OVER (ORDER BY fldName) FROM #Test1

    pretty sure that doesn't work in 2000 :>

  • RE: Row number returned in resultset

    Adrian Nichols (9/23/2008)


    Hi,

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

  • RE: Locking Issue raising by Stored Procedure.

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

  • RE: Bulk Insert Task

    Thankyou.

Viewing 15 posts - 16 through 30 (of 56 total)