Forum Replies Created

Viewing 15 posts - 496 through 510 (of 7,164 total)

  • RE: Getting SQL Server Error 7303

    Note too that the path you provide to the Excel file is from the perspective of the server.

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

    January 15, 2016 at 9:45 am

    #1852284

  • RE: Should CTE Be Used To Update Table

    John Mitchell-245523 (1/15/2016)

    You can avoid this by considering which direction your many-to-one relationship goes in before writing the query, or you can write your query in a different way.

    The MERGE...

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

    January 15, 2016 at 9:41 am

    #1852283

  • RE: Insert a suffix to the values

    guy 1966 (1/15/2016)

    Ok, I finally found what I needed

    UPDATE `categories_images` SET `categories_image`=REPLACE (`categories_image`,'.gif','');

    UPDATE `categories_images` SET `categories_image`=REPLACE (`categories_image`,'','');

    Thank you!

    @guy1966, I am not sure why you insisted on getting an answer for...

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

    January 15, 2016 at 9:34 am

    #1852281

  • RE: Best way to merge two large client databases

    Option 3, I have found, is the simplest to understand and let's you handle an entire "record" (ie the primary parent and all children) as a unit of work but...

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

    January 15, 2016 at 8:51 am

    #1852275

  • RE: Idetify repeated values from a table

    nm.rajesh (1/14/2016)

    But the measure values needs to be sequential . Like 17.4 in the example has to be repeated more than 8 times in sequence and then mark only those...

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

    January 15, 2016 at 6:51 am

    #1852234

  • RE: Email from condition

    http://stackoverflow.com/questions/886293/how-do-i-execute-a-stored-procedure-once-for-each-row-returned-by-query

    Typically looping and cursors are to be avoided but in cases where you must call a procedure once for each row for a relatively small number of rows it is...

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

    January 15, 2016 at 1:40 am

    #1852177

  • RE: Email from condition

    1000 is actually not much at all. Yes, again, you need to call the proc 1000 times to send a separate email to eaxh recipient. Do you have the emails...

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

    January 15, 2016 at 1:15 am

    #1852171

  • RE: Email from condition

    Calling the proc once for each email is the supported way. If you need bulk mailer capabilities and performance then Database Mail might not be right for you.

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

    January 14, 2016 at 10:28 pm

    #1852154

  • RE: Email from condition

    You need to call sp_send_dbmail once for every email you want to send.

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

    January 14, 2016 at 9:55 pm

    #1852146

  • RE: Idetify repeated values from a table

    I might be missing something, but why not this:

    Setup:

    USE tempdb;

    IF EXISTS ( SELECT *

    FROM ...

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

    January 14, 2016 at 9:53 pm

    #1852145

  • RE: Guarantee entire flat file loaded

    Fair enough. The topics on which I would like to do a deep dive with you someday just keeps on growing.

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

    January 14, 2016 at 9:37 pm

    #1852143

  • RE: Migrating SSIS 2005 to SSDT 2012

    When you go to Services do you see two "Integration Services" services, e.g. "SQL Server Integration Services" which would be from SQL 2005 and "SQL Server Integration Services 11.0" which...

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

    January 14, 2016 at 9:25 pm

    #1852141

  • RE: Data Source Schema Changes..

    b_boy (1/14/2016)

    What they expect from the new DW, is to have these new fields created imported and available for reporting.

    Are your custom fields stored in a EAV structure? In what...

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

    January 14, 2016 at 9:21 pm

    #1852140

  • RE: SQL query that outputs to XML

    See if this gets you close:

    SELECT sp.StudentID AS [@id],

    (

    SELECT 'final' AS type,

    ...

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

    January 14, 2016 at 9:13 pm

    #1852139

  • RE: Guarantee entire flat file loaded

    Jeff Moden (1/14/2016)

    I suppose what you say is why some people like XML. The root tag serves as both a starting and ending tag and you can embed...

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

    January 14, 2016 at 2:19 pm

    #1852088

Viewing 15 posts - 496 through 510 (of 7,164 total)