1086 + 68 = 0? [modified]

[Tim Groven]

On your individual checks, try adding the exportbatchid.

select count(*) from caExportBatchRecord where ExportRecordTypeCode = 'SINV' and ExportBatchID = 1

select count(*) from caExportBatchRecord where ExportRecordTypeCode = 'SCRN' and ExportBatchID = 1

I bet you get zero for each query.

[Brady Kelly]

I double your bet I don't. :-\ By the way, this is NOT a help forum. The text at the top of this page says, "Subtle Bugs is a forum to post examples of interesting, aggravating and subtle bugs that you've found and fixed."

Semicolons: The number one seller of ostomy bags world wide. - dan neely

[MidwestLimey]

Brady Kelly wrote:

'SINV, SCRN'

Hmmmmmm, don't like those ticks, do you? :)

---

I'm largely language agnostic

---

After a while they all bug me :doh:

---

[codemunch]

'SINV, SCRN' vs 'SINV', 'SCRN'

[Tim Groven]

Oops. Sorry, newbie here, and obviously not that helpful either. :laugh:

[Brady Kelly]

Caydence wrote:

:laugh:

You got that right. This is one of those boards where it's OK to point and laugh. You can reserve being helpful for the serious boards. :)

Semicolons: The number one seller of ostomy bags world wide. - dan neely

[Dewm Solo]

??? WTH Subject: 1086 + 86 = 0?

Brady Kelly wrote:

select count(*) from caExportBatchRecord where ExportRecordTypeCode = 'SINV' 1086 records select count(*) from caExportBatchRecord where ExportRecordTypeCode = 'SCRN' 68 records

Reading seems to be a challenge here :wtf:

Dewm Solo - Managed C++ Developer

[Brady Kelly]

No, the real challenge seems to realising the subject line has sweet f-all to do with the actual bug. :cool:

Semicolons: The number one seller of ostomy bags world wide. - dan neely

[PIEBALDconsult]

Brady Kelly wrote:

OK to point and laugh. You can reserve being helpful for the serious boards

Pointing and laughing doesn't help? I should think that it at least drives the lesson home. :-D

[Dewm Solo]

Of course you can always cheat and go back to change it. Then again, miss writing stuff seems to be a habit:

Brady Kelly wrote:

No, the real challenge seems to realising the subject line has sweet f-all to do with the actual bug.

;P

Dewm Solo - Managed C++ Developer

[Brady Kelly]

Give me a break, I'm still at work at 22h00 on a Friday night. By choice. :doh:

Semicolons: The number one seller of ostomy bags world wide. - dan neely

[Babycorn Starfish]

try where ExportRecordTypeCode in ('SINV', 'SCRN')

[Alsvha]

Bah - going and spoiling it :)

--------------------------- Blogging about SQL, Technology and many other things