Forum Replies Created

Viewing 15 posts - 5,296 through 5,310 (of 6,042 total)

  • RE: Query accounts, domain groups, and members who have admin membership.

    mw162 (2/9/2012)


    Really useful thanks. Was only looking at this myself yesterday but didn't go the extent of group members. I've amended the script slightly for our use to show the...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Change Management

    Revenant (2/3/2012)


    Eric M Russell (2/3/2012)


    . . . We developers tend to forget things like that unless someone in the organization is keeping score.

    That's what TFS does - if you use...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Issue with Loading data from Excel sheet to SQL Server Table using SSIS package

    jkp2311 (2/3/2012)


    Do i need the Microsoft office 2007 in my machine...?

    On the machine running SSMS Data Import Wizzard, SSIS, etc. you would need the Excel data provider installed. SQL Server...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Change Management

    If you work for a publicly traded company in the US, then a compliant change management process is required by SOX.

    I think that those who work in an organization...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Issue with Loading data from Excel sheet to SQL Server Table using SSIS package

    jkp2311 (2/3/2012)


    Hi,

    I have get some crazy error when i am trying to import data

    from Excel sheet to SQL Server table using SSIS Packages.

    PLease read the below error message.

    Please help me...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Load data from excel sheet to table

    Stewart "Arturius" Campbell (2/3/2012)


    Eric M Russell (2/3/2012)


    I've worked on projects in the past where the business would provide Excel sheets for populating reference tables, and they would basically just create...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Load data from excel sheet to table

    I've worked on projects in the past where the business would provide Excel sheets for populating reference tables, and they would basically just create and fill in the data in...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Twist in ISNULL function

    Mark Hill-285393 (2/2/2012)


    I am in the habit of using COALESCE for such things, mainly because I also use MySql, which doesn't have ISNULL. But everyone should read the link...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Trimming data from cells.

    Jeff Moden (2/1/2012)


    Eric M Russell (2/1/2012)


    tyson.price (2/1/2012)


    Eric M Russell (2/1/2012)


    There is no concept of a "cell" in SQL Server. Are you talking about SQL Server or Excel?

    I see what you...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Trimming data from cells.

    subzzz_ (2/1/2012)


    Eric M Russell (2/1/2012)


    There is no concept of a "cell" in SQL Server. Are you talking about SQL Server or Excel?

    Sorry, my mistake.

    It's a force of habit from talking...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Trimming data from cells.

    tyson.price (2/1/2012)


    Eric M Russell (2/1/2012)


    There is no concept of a "cell" in SQL Server. Are you talking about SQL Server or Excel?

    I see what you are asking but as far...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Trimming data from cells.

    There is no concept of a "cell" in SQL Server. Are you talking about SQL Server or Excel?

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Newbie on Constraints...

    earnest.williams (1/26/2012)


    I'm a student and a newbie with databases. I was wondering if anyone could provide me some information on constraints. What would the basic way to write...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Morale Data

    Is a company's morale metrics visible only to employees or also to the general public? It sounds like a useful tool for someone evaluating job offers.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Healthy Work Habits

    Coincidentally, while shaving and getting suited up this morning, I started thinking about the idea that we should not consider the time we put in at work as "time spent"...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

Viewing 15 posts - 5,296 through 5,310 (of 6,042 total)