Forum Replies Created

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

  • RE: Values <> null

    Remember:

    Never assume anything because it can make a donkey out of u and me

    Won't let me SUBSTRING('assume',1,3) 😀

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

  • RE: Doing a FTP Pull into Sql Server 2008

    I use SSIS and WinSCP.

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

  • RE: T-SQL Oddities

    all good programmers can write incomprehensible code in any useful language, and bad programmers can't write any other sort.

    That makes the day start off well 😀

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

  • RE: No More NULL

    Only just read it so I didn't notice what date it was from. Busy thinking of all the problems it would cause.

    Good one. 😀

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

  • RE: Check Existence of Folder and File on FTP Server through Script

    I found this. Useful whilst waiting for a file to ftp or download.

    http://www.konesans.com/filewatcher.aspx

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

  • RE: T-SQL Oddities

    Ah.

    That would explain why I couldn't find the b@##y st??%d table

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

  • RE: SSIS using source of password-protected Excel Files

    Exactly that. Set password to empty ("") and SaveAs. Then the connection manager shouldn't complain.

    $comments = @'

    Script name: Remove-Password.ps1

    Created on: Tuesday, July 03, 2007

    Author: Kent Finkle

    Purpose: How can I...

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

  • RE: T-SQL Oddities

    At least in 2k8 we have Intellisense otherwise it might be a tad difficult remembering which symbolic (or should that be shambolic) table is which 😉

    Now was it...

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

  • RE: SSIS using source of password-protected Excel Files

    My first thought was that you may be able to use Poweshell. A quick look around and I found this:

    http://www.eggheadcafe.com/software/aspnet/34092087/can-i-open-a-password-pro.aspx

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

  • RE: SSMS - feature

    Just tried it out on a 2005 version and the pop-up appears but not on 2008 :w00t:

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

  • RE: SSMS - feature

    Nothing here unless I hold down CTRL, then I can click the link.

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

  • RE: Administering SQL from a Pocket PC

    LogMeIn?

    I know you might need help reading the screen but...

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

  • RE: How to transform table with few rows to one row?

    Duplicate post?

    http://www.sqlservercentral.com/Forums/Topic887100-338-1.aspx

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

  • RE: How to create task in order to get one instead 3 column?

    You just need to tweak Arjuns code a bit

    create table #t(customernumber varchar(10), notes varchar(10), lastvisitdate smalldatetime)

    insert into #t values(100000, 'text 1', '10.feb.2010')

    insert into #t values(100000, 'text 2', '10.feb.2010')

    insert into...

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

  • RE: SSIS for Secure FTP connections

    I use WinSCP. It supports UNC paths.

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

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