Forum Replies Created

Viewing 15 posts - 1 through 15 (of 25 total)

  • RE: How to archive old data from sql database

    SQLRNNR - Saturday, April 1, 2017 5:48 PM

    table paritioning is frequently used to meet this kind of requirement.

    I'm not a DBA by...

  • RE: Web URL in dataset results

    Get me? (9/22/2015)


    Are you parsing out the URLs from the rest of your text? SSRS wont just detect the URLs in the text box, and an action needs to...

  • RE: Web URL in dataset results

    pietlinden (9/17/2015)


    For grins, create a dummy table and just copy a bunch of tweet URLs, and see if they work. That's where I got them for my report. If...

  • RE: Web URL in dataset results

    Kristen-173977 (9/17/2015)


    When I post this reply the list of messages (below this Message Formfield) has your (FullStack's) messages displayed with a red background. I don't think I've ever seen...

  • RE: Web URL in dataset results

    How would I be able to tell if there were any illegal hyperlinks?

  • RE: Web URL in dataset results

    I can't see my replies. When I come to post a reply I can see them in red boxes, what does that mean?

  • RE: Web URL in dataset results

    Ok I'll rule out the INSERT statement, you know more than I overall and I appreciate the help. All the queries worked, is that bad? Should I gotten any bad...

  • RE: Web URL in dataset results

    Test reply because I can't see the others

  • RE: Web URL in dataset results

    If I run the query below, it returns results

    SELECT *

    FROM TweetsList

    WHERE TweetURL NOT LIKE 'http://%'

    AND TweetURL NOT LIKE 'https://%'

    AND TweetURL NOT LIKE 'ftp://%'

    AND TweetURL NOT LIKE 'mailto:%'

    AND TweetURL NOT LIKE...

  • RE: Web URL in dataset results

    Ok I'll rule out the INSERT statement, you know more than I overall and I appreciate the help. All the queries worked, is that bad? Should I gotten any bad...

  • RE: Web URL in dataset results

    pietlinden (9/17/2015)


    What happened when you ran the query to see if there were any "illegal" hyperlinks?

    The INSERT statement should have nothing to do with it, but it's your...

  • RE: Web URL in dataset results

    I used the query below against my production data, I got back a pretty much all data that is being feed in.

    SELECT *

    FROM Table

    WHERE column NOT LIKE 'http://%'

    AND column NOT...

  • RE: Web URL in dataset results

    I just reviewed the VALUES area of the insert statement and nothing jumps out. But I think this will be the area of focus

  • RE: Web URL in dataset results

    I used the query below against my production data, I got back a pretty much all data that is being feed in. Is it possible that the issue is the...

  • RE: Web URL in dataset results

    pietlinden (9/17/2015)


    Post if it still doesn't work and explain what you did step by step... because try as I might, I can't reproduce the issue. Can you open the...

Viewing 15 posts - 1 through 15 (of 25 total)