Results 1 to 12 of 12

Thread: Test

  1. #1

    Thread Starter
    Frenzied Member
    Join Date
    Dec 2014
    Location
    VB6 dinosaur land
    Posts
    1,191

    Test

    Getting errors trying to reply....

  2. #2

    Thread Starter
    Frenzied Member
    Join Date
    Dec 2014
    Location
    VB6 dinosaur land
    Posts
    1,191

    Re: Test

    Starting thread works. Hmmm

  3. #3

    Thread Starter
    Frenzied Member
    Join Date
    Dec 2014
    Location
    VB6 dinosaur land
    Posts
    1,191

    Re: Test

    As does replying here. Keep getting error when trying to reply to
    http://www.vbforums.com/showthread.p...entical-tables

    Something went wrong!

    Sadly, you’ve reached a page that can’t be displayed.

    We’ve logged this action, so we are aware there is an issue!

    At this time, please hit your browser’s back button or simply close this page!

    The incident ID is: N/A.
    Event id: 4888001910676436

  4. #4

    Thread Starter
    Frenzied Member
    Join Date
    Dec 2014
    Location
    VB6 dinosaur land
    Posts
    1,191

    Re: Test

    Quote Originally Posted by topshot View Post
    As does replying here. Keep getting error when trying to reply to
    http://www.vbforums.com/showthread.p...entical-tables
    Now the same error happens here.

  5. #5

    Thread Starter
    Frenzied Member
    Join Date
    Dec 2014
    Location
    VB6 dinosaur land
    Posts
    1,191

    Re: Test

    but only sometimes

  6. #6

    Thread Starter
    Frenzied Member
    Join Date
    Dec 2014
    Location
    VB6 dinosaur land
    Posts
    1,191

    Re: Test

    Must be related to tags as it will keep occuring until I reload page and try new reply without tags.

  7. #7

    Thread Starter
    Frenzied Member
    Join Date
    Dec 2014
    Location
    VB6 dinosaur land
    Posts
    1,191

    Re: Test

    If you want to display the differences:
    snip

    which will display as:
    snip

  8. #8

    Thread Starter
    Frenzied Member
    Join Date
    Dec 2014
    Location
    VB6 dinosaur land
    Posts
    1,191

    Re: Test

    If you want to display the differences:
    snip

    which will display as:
    Code:
    col1	col2	In_Tab1	In_Tab2
    000002001	Taxable Cash Customer	1	0
    090002001	Taxable Cash Customer	0	1
    602010000	ACME Software	1	0
    602010000	ACME Company	0	1

  9. #9

    Thread Starter
    Frenzied Member
    Join Date
    Dec 2014
    Location
    VB6 dinosaur land
    Posts
    1,191

    Re: Test

    So maybe it just doesn't like the SQL within my code tags???

    If you want to display the differences:
    SELECT col1, col2, COUNT(SRC1) In_Tab1, COUNT(SRC2) In_Tab2
    FROM (SELECT col1, col2, 1 AS SRC1, NULL AS SRC2
    FROM table1
    UNION ALL
    SELECT col1, col2, NULL AS SRC1, 2 AS SRC2
    FROM table2) a
    GROUP BY col1, col2
    HAVING COUNT(SRC1) <> COUNT(SRC2);

  10. #10

    Thread Starter
    Frenzied Member
    Join Date
    Dec 2014
    Location
    VB6 dinosaur land
    Posts
    1,191

    Re: Test

    Gave the error then but still posted.

  11. #11

    Thread Starter
    Frenzied Member
    Join Date
    Dec 2014
    Location
    VB6 dinosaur land
    Posts
    1,191

    Re: Test

    Tried clearing cookies and logging out and back in but no change.

  12. #12
    Administrator Steve R Jones's Avatar
    Join Date
    Apr 2012
    Location
    Largo, FL.
    Posts
    1,826

    Re: Test

    Test
    Wi-fi went down for five minutes, so I had to talk to my family....They seem like nice people.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width