Forum Replies Created

Viewing 15 posts - 2,401 through 2,415 (of 7,164 total)

  • RE: Extract only numbers from string which contains special characters too

    My solution requires the use of a Tally Table (a.k.a. a Numbers Table). For this example my tally table is stored in the master database and is made accessible by...

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

    January 13, 2013 at 9:08 am

    #1576680

  • RE: SQL ADVANCE COPY/MOVE AND RENAME FUNCTIONS

    I would not recommend using xp_cmdshell for this. I recommend keeping the option disabled on your instance if at all possible. Truthfully I would not do this work in T-SQL...

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

    January 13, 2013 at 8:27 am

    #1576679

  • RE: Conditional joining of Table A nested ID/heirarchyid to table A or B?

    Physical objects have at most one descendent virtual object row.

    Virtual objects have zero or more descendent virtual object row(s).

    Which might be more common, someone asking to which physical object does...

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

    January 13, 2013 at 8:08 am

    #1576678

  • RE: Multiple outputs from XML Source

    If you have a complex XML file and SSIS detects 80 outputs then you'll have to process each of the 80 outputs in some form or manner if you want...

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

    January 12, 2013 at 10:34 pm

    #1576663

  • RE: How to handle mutiple outputs in xml source

    Please do not cross-post. It just fragments responses and wastes people's time.

    Direct all replies here:

    http://www.sqlservercentral.com/Forums/FindPost1406209.aspx

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

    January 12, 2013 at 10:34 pm

    #1576662

  • RE: SQL Security Best Practices - Dealing With User Name Changes

    AD Groups as SQL Logins and Database Users work great unless you need the User to have a default schema. In SQL 2012 the loop has been closed, but this...

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

    January 12, 2013 at 10:32 pm

    #1576661

  • RE: How to handle mutiple outputs in xml source

    If you have a complex XML file and SSIS detects 80 outputs then you'll have to process each of the 80 outputs in some form or manner if you want...

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

    January 12, 2013 at 10:23 pm

    #1576660

  • RE: Update Recordset with foreach loop

    Please do not cross-post. It just fragments replies and wastes people's time.

    Direct all replies here: http://www.sqlservercentral.com/Forums/Topic1406350-148-1.aspx

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

    January 12, 2013 at 10:18 pm

    #1576659

  • RE: Issues With DB2 CHARACTER Field Source - SSIS 2008

    From the error message the package appears to be failing on the OLE DB Source so I am wondering, is it even reaching the Data Conversion you said you added?...

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

    January 12, 2013 at 10:16 pm

    #1576658

  • RE: Plan Usage for stored procedures

    That can be caused by two sessions executing the proc with different SET options, e.g. ARITHABORT. Each execution plan has within it the set of server options that are set....

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

    January 12, 2013 at 10:08 pm

    #1576657

  • RE: SELECT vs INSERT INTO

    Sean Lange (1/11/2013)

    You do not have as much control over the datatypes when using a select into either, it will use the datatype from the source. That is not a...

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

    January 12, 2013 at 9:01 pm

    #1576655

  • RE: Test results report

    Not a problem. I hadn't played with unpivoting data in a long time so I took it on as a learning challenge. It took me about a half hour to...

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

    January 12, 2013 at 4:56 pm

    #1576641

  • RE: Test results report

    This is unpivoting multiple columns. See how these results look:

    WITH TestQuestions(Id, Question, AnswerNumber, Answer, IsCorrect)

    AS (

    ...

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

    January 12, 2013 at 5:30 am

    #1576561

  • RE: Increasing memory on 32 bit sql cluster with AWE already enabled

    durai nagarajan (1/11/2013)

    opc.three (1/11/2013)

    Bhuvnesh (1/11/2013)

    Setting max memory will do the job.

    +1

    i ddint get this..

    +1

    It means: I agree with the statement.

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

    January 11, 2013 at 1:07 pm

    #1576489

  • RE: Access Excel Hyperlinks from SQL

    Greg Snidow (1/11/2013)

    opc.three

    The C# code I provided does exactly that

    Ah, my bad then. I'm C# illiterate (and all flavors of C for that matter). Now that you pointed...

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

    January 11, 2013 at 8:56 am

    #1576369

Viewing 15 posts - 2,401 through 2,415 (of 7,164 total)