Forum Replies Created

Viewing 15 posts - 2,956 through 2,970 (of 3,544 total)

  • RE: Business Date Calculation

    quote:

    SELECT rt.account_id, rt.account_status, DATEDIFF(DAY,rt.status_creation_datetime,GETDATE())-COUNT(*)

    FROM Result_Table rt, Calendar_Table ct

    WHERE ct.DateField BETWEEN rt.status_creation_datetime AND GETDATE()

    GROUP BY rt.account_id, rt.account_status, rt.status_creation_datetime

    Far away is close at hand in the images of elsewhere.
    Anon.

    November 11, 2003 at 6:08 am

    #481565

  • RE: ODBC Connection

    quote:

    When he uses the wizard it cannot see the test box.

    What wizard? What test...

    Far away is close at hand in the images of elsewhere.
    Anon.

    November 10, 2003 at 6:50 am

    #481405

  • RE: Remote Folder in Linked Server

    It would seem that permissions are OK. "login unknown or wrong password" would indicate that sql is using the wrong credentials. Has someone changed the Adminstrator password since sql was...

    Far away is close at hand in the images of elsewhere.
    Anon.

    November 7, 2003 at 8:08 am

    #481264

  • RE: Remote Folder in Linked Server

    ...Administrator account of the machine.../code]

    I suspect that there is a permission/access problem to do with the local Administrator account. Did you login as Administrator to create the mapped drive? Was...

    Far away is close at hand in the images of elsewhere.
    Anon.

    November 7, 2003 at 7:33 am

    #481246

  • RE: Parsing a Text Field into Columns

    The problem with above is the 8k limit and if the numbers are > 1 digit. Using '%REC%:%' should cater for this.

    The code below will give you the number of...

    Far away is close at hand in the images of elsewhere.
    Anon.

    November 7, 2003 at 7:24 am

    #481244

  • RE: Email Results of Excel File from a DTS Pkg

    In the same package create a new step to do the email (remove code from first step) and change the properties of the first step to quit on failure so...

    Far away is close at hand in the images of elsewhere.
    Anon.

    November 7, 2003 at 6:16 am

    #481231

  • RE: Remote Folder in Linked Server

    Duplicate post.

    http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=17997&FORUM_ID=5&CAT_ID=1&Topic_Title=Remote+Folder+in+Linked+Server&Forum_Title=Administration

    Far away is close at hand in the images of elsewhere.
    Anon.

    November 7, 2003 at 6:02 am

    #481225

  • RE: Remote Folder in Linked Server

    Are you sure the mapped drive exists, you will get this error if not.

    Test with

    xp_cmdshell 'dir F:\descarga\00005\'

    Alternatively use UNC

    Edited by - davidburrows on 11/07/2003 ...

    Far away is close at hand in the images of elsewhere.
    Anon.

    November 7, 2003 at 5:59 am

    #481224

  • RE: Remote Folder in Linked Server

    What account is sql server running under. If it is set to localsystem then you will not be able to access across a network.

    Far away is close at hand in the images of elsewhere.
    Anon.

    November 7, 2003 at 5:44 am

    #481218

  • RE: How to find the no concurrent users ?

    quote:

    select count(*) from master..sysprocesses

    where dbid = db_id('dbname')

    This will give you then number of...

    Far away is close at hand in the images of elsewhere.
    Anon.

    November 6, 2003 at 6:41 am

    #481058

  • RE: How To: Become proficient SQL guru?

    Hi Frank,

    quote:

    I have very basic skills only in DTS, just enough to get my jobs done.

    Far away is close at hand in the images of elsewhere.
    Anon.

    November 6, 2003 at 4:24 am

    #481034

  • RE: Help: Ways of persisting the resultset from SP?

    quote:

    This would fail with sp's that return more than 1 result set as output

    And those...

    Far away is close at hand in the images of elsewhere.
    Anon.

    November 6, 2003 at 4:00 am

    #481027

  • RE: Querying the Active Directory from SQL Server

    I think error 7321 is caused by a malformed LDAP query.

    Try the following. If it works then the link is OK, the query is the problem.

    Far away is close at hand in the images of elsewhere.
    Anon.

    November 6, 2003 at 3:35 am

    #481023

  • RE: Retreive Output Parameter

    in the proc define the output param with single @ as in

    @IndexOut Int output

    when you want to refer to the output use

    myCommand1.SelectCommand.Parameters("@IndexOut").Value

    Edited by...

    Far away is close at hand in the images of elsewhere.
    Anon.

    November 5, 2003 at 7:13 am

    #480889

  • RE: HELP! HOWTO Create new tables from a sql text file

    Bah humbug

    I do hate multiple posts and cross posts

    Edited by - davidburrows on 11/05/2003 07:07:16 AM

    Far away is close at hand in the images of elsewhere.
    Anon.

    November 5, 2003 at 7:07 am

    #480888

    • Viewing 15 posts - 2,956 through 2,970 (of 3,544 total)