1086 + 68 = 0? [modified]

[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