On 25-Jan-2004 Hassan Shaikh wrote:
Hi,
I've a unique requirement where the transaction number should be
automatically generated (increment). I can't use AUTO_INCREMENT
column. The TRAN_NO is supposed to be in MF format, where:
Field: TRAN_NO CHAR(10)
M = Encoded current
On 22-Jan-2004 Michael McTernan wrote:
Hi there,
Thanks for your quick response!
Why all the locks, temp tables and updates? You can just do:
SELECT
CASE WHEN B.y IS NULL THEN A.x ELSE B.y END AS newX
FROM
A LEFT JOIN B ON A.x = B.x
Spot on - many thanks! I wasn't aware of the
On 24-Jan-2004 [EMAIL PROTECTED] wrote:
Here's a fun one to tickle your brains:
I've got a table holding the results of a bandwidth tester thingie.
Its
columns hold the date and time the test was run, the fully-qualified
machine
name of the computer that took it, its IP address, and the