-
May 31st, 2018, 08:40 AM
#1
Thread Starter
Frenzied Member
Test
Getting errors trying to reply....
-
May 31st, 2018, 08:41 AM
#2
Thread Starter
Frenzied Member
Re: Test
Starting thread works. Hmmm
-
May 31st, 2018, 08:44 AM
#3
Thread Starter
Frenzied Member
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
-
May 31st, 2018, 08:50 AM
#4
Thread Starter
Frenzied Member
Re: Test
Originally Posted by topshot
Now the same error happens here.
-
May 31st, 2018, 08:51 AM
#5
Thread Starter
Frenzied Member
-
May 31st, 2018, 08:52 AM
#6
Thread Starter
Frenzied Member
Re: Test
Must be related to tags as it will keep occuring until I reload page and try new reply without tags.
-
May 31st, 2018, 08:53 AM
#7
Thread Starter
Frenzied Member
Re: Test
If you want to display the differences:
snip
which will display as:
snip
-
May 31st, 2018, 08:53 AM
#8
Thread Starter
Frenzied Member
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
-
May 31st, 2018, 08:55 AM
#9
Thread Starter
Frenzied Member
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);
-
May 31st, 2018, 08:56 AM
#10
Thread Starter
Frenzied Member
Re: Test
Gave the error then but still posted.
-
May 31st, 2018, 09:06 AM
#11
Thread Starter
Frenzied Member
Re: Test
Tried clearing cookies and logging out and back in but no change.
-
Jul 18th, 2018, 03:38 PM
#12
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|