Forum Replies Created

Viewing 15 posts - 6,046 through 6,060 (of 7,164 total)

  • RE: USING CASE

    ash0550 (6/16/2011)


    Nope it is not working

    Anyways thanks

    It may not be "working" because only you can see your screen. Please provide sample DDL and DML as well as your expected results...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Finding dates in Dates tally table

    Michael Valentine Jones (6/16/2011)


    opc.three (6/16/2011)

    ...

    That said, Michael's script has "DATE_ID = Days since 1753-01-01". I am not modeling anything more than 111 years old...was it done this way in the...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Transfer data from Sybase to SQL Server 2005/2008

    You're welcome, thanks for posting back 🙂

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Copy From FlatFile Using Wildcard in File Name

    Under Collection what do you have for the "Retrieve file name" setting?

    > Fully qualified (you want to select this one)

    > Name only

    > Name and extension

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Copy From FlatFile Using Wildcard in File Name

    No sweat...besides I don't think that's the root issue, I just wanted to confirm the mask was working, which it sounds like it is. SSIS can handle files with spaces...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Finding dates in Dates tally table

    Jeff Moden (6/14/2011)


    opc.three (6/14/2011)


    DayInstanceInMonth - tinyint - values 1-5 representing the n-th time this day has occurred in the month

    Most people don't think of such a thing. I was...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Problem using IF EXISTS(SELECT * FROM MYVIEW)

    gcresse (6/13/2011)


    I was able to resolve my problem by replacing the IF EXISTS with an IN statement. Apparently the exection plan is generally more efficient for IN than IF...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Does anyone have a good reason to run xp_CmdShell?

    No.

    How's that for short, sweet and accurate? 😉

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Row count in temp table

    GilaMonster (6/16/2011)


    ...Not what I was thinking about at all. For savepoints, the name of the transaction is still meaningless, the name of the savepoint is what's important.

    Agreed. There is an...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Code generation and any third party tools to generate SSIS packages

    billj-705548 (6/16/2011)


    I've read several posts including this one http://www.sqlservercentral.com/Forums/Topic1083821-364-1.aspx?Highlight=generate+output+columns that essentially ask the question "Is there a way to dynamically generate output columns from a source." Based on the...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Building an ARRAY and then LOOP through results

    This thread should be moved into the Relational Theory forum 🙂

    Try thinking of an array as a column turned on its side and go from there.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: One procedure to insertupdate all master tables using if statements

    While your manager is outside the box ask him/her to consider what will happen when two people need to modify "The Proc"...one to change how Lady GaGa does her work...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Row count in temp table

    Not trying to step in front of Gail...my shadow would maybe cover her pinky toe but the thread looked idle...

    SAVE TRANSACTION is when naming a transaction becomes relevant.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Phrases that Resonate

    Fully Baked is a great one for non-techs and techs alike!

    I also like "transparent". It worked in one particular shop quite well for non-techs as "don't worry, we know we...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • RE: Select Tree and Order by from another table

    Jeff Moden (6/16/2011)


    You didn't read the entire post! 😉 I told you how to get that. Just remove the "*," from the code. 😉

    Nice...and with 2 minutes to...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 15 posts - 6,046 through 6,060 (of 7,164 total)