Forum Replies Created

Viewing 8 posts - 1,546 through 1,553 (of 1,553 total)

  • RE: registering a remote database

    If you're certain that the server is accessible over the network, I'd suggest you investigate the last part of the message - 'access denied'

    Make sure you're trying to register...

  • RE: Read CSV File in SP

    I don't have much experience with BULK INSERT (always uses bcp ) and I also stay away from csv files, but...

    Try to specify the fieldterminator as "\",\"" (should translate to...

  • RE: TABLOCK HINT NOT USED IN ISQL

    Could be.

    Have you tried with OSQL instead of ISQL?

    /Kenneth

  • RE: ISQL with -Q option

    Can you expand on what kind of error you get?

    Does the proc AGGT_INRUNNING really accept 'score' as input parameter?

    /Kenneth

  • RE: Sum of the count

    Another way to skin the same cat =;o) - ROLLUP instead of UNION

    SELECT CONVERT(char(7),Date_Requested,120),

    COUNT(*)

    FROM Accident_Reg

    GROUP BY CONVERT(char(7),Date_Requested,120)

    WITH ROLLUP

    =;o)

    /Kenneth

  • RE: Help with getting or setting row number in table

    Just a question from the curious..

    You talk about subnets, but nowhere do I see the netmask? Are you assuming default subnetmasks always?

    If not, then you must also pair each...

  • RE: filter out alphabetics

    Just be aware that isnumeric() has it's flaws, depending on the actual charachters you want to filter, this may or may not have an impact on you...

    ie isnumeric() considers TAB,...

  • RE: filter out alphabetics

    Just be aware that isnumeric() has it's flaws, depending on the actual charachters you want to filter, this may or may not have an impact on you...

    ie isnumeric() considers TAB,...

Viewing 8 posts - 1,546 through 1,553 (of 1,553 total)