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 c
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, an
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 wa
