Forum Replies Created

Viewing 15 posts - 4,201 through 4,215 (of 8,731 total)

  • RE: Contains use on Dynamic Parameters

    Could you give more information?

    How about sample data so we can reproduce what you're trying to do?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    September 16, 2015 at 6:37 am

    #1827044

  • RE: Export MONEY datatype to Oracle

    sgmunson (7/27/2015)

    aaidanmary (7/27/2015)

    yes really I accept this point.Export money datatype is reduce in my loading time.I analysed.I hope this information. (EDIT: removed URL)

    I see no relevance to the problem associated...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    September 16, 2015 at 6:30 am

    #1827043

  • RE: Execution plan ignoring index, insisting on Key Lookup

    That's probably because the optimizer thinks that the key lookup is more efficient than the index.

    You can force the use of the index and compare performance.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    September 15, 2015 at 12:09 pm

    #1826861

  • RE: Intermittant fault on script.

    Do you have any other process running constantly that might be dropping the linked server?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    September 15, 2015 at 10:05 am

    #1826807

  • RE: Grouping columns

    Or something like this?

    CREATE TABLE SampleData(

    filename char(3),

    col1 char(1),

    col2 char(1),

    ...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    September 15, 2015 at 6:41 am

    #1826710

  • RE: Script to remove any foreign characters

    Have you tried something like this?

    Update TABLE

    set LEAD_NOTES__C = CAST( LEAD_NOTES__C AS varchar( 8000)) --Or whatever length you need.

    This will remove unicode characters and replace them with a question mark...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    September 14, 2015 at 8:51 am

    #1826395

  • RE: Today's Random Word!

    whereisSQL? (9/14/2015)

    anthony.green (9/14/2015)

    Ed Wagner (9/14/2015)

    Stuart Davies (9/14/2015)

    Ed Wagner (9/14/2015)

    anthony.green (9/14/2015)

    snickers

    Candy

    Girl

    Boy

    George

    Jungle

    Book

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    September 14, 2015 at 8:04 am

    #1826370

  • RE: Get the total number of attachments of a group ID

    Check this for help: http://www.sqlservercentral.com/articles/comma+separated+list/71700/

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    September 14, 2015 at 7:30 am

    #1826347

  • RE: Get the total number of attachments of a group ID

    I'm sorry, I can't help with that because it goes against my beliefs. You shouldn't be storing concatenated values like that. You can generate the string when querying the table,...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    September 14, 2015 at 6:46 am

    #1826330

  • RE: Round

    I agree that the behavior of SQL Server is unexpected as it interprets the 0.999 as a decimal(3,3) which won't allow integers.

    However, if you're using this code, you deserve the...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    September 14, 2015 at 6:33 am

    #1826329

  • RE: Are the posted questions getting worse?

    I saw a truck for this place[/url] this morning on my way to work. I wonder if they serve pork chops as a secret menu item. 😀

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    September 11, 2015 at 12:34 pm

    #1826121

  • RE: Trouble w/ a WHERE statement.

    We would need some DDL and sample data to try to understand what's going on in here and give proper advice.

    This is what I got from your query, but...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    September 11, 2015 at 12:24 pm

    #1826116

  • RE: How to read New Posts on SQLServerCentral?

    You're right. The forum options are limited and the software can be better. I've understood that this happens because this isn't a priority for Redgate and just try to keep...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    September 11, 2015 at 11:59 am

    #1826103

  • RE: Need help with group By

    You could use something like this:

    WITH Addresses AS(

    SELECT *,

    DENSE_RANK() OVER (PARTITION BY BLOCK, STREET, CITY ORDER BY...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    September 11, 2015 at 11:49 am

    #1826099

  • RE: Optimisation of unpivot/insert code

    You can try this option: http://www.sqlservercentral.com/articles/CROSS+APPLY+VALUES+UNPIVOT/91234/

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    September 11, 2015 at 11:18 am

    #1826086

Viewing 15 posts - 4,201 through 4,215 (of 8,731 total)