🚀 go-pugleaf

I tried that and it then is a keyword, but it still doesn't work with a 
syntax error.
Couldn't figure it out from the MS SQL Server help either. I am keen to try 
this as I know that in Interbase
using the rdb$db_key can speed certain queries up enormously, like this 
particular one.

RBS

"Wayne Niddery [TeamB]" <wniddery@chaffaci.on.ca> wrote in message 
news:45d8b10f$1@newsgroups.borland.com...
> RB Smissaert wrote:
>> Thanks, I tried that, but got a syntax error.
>> How do I use it? This was my query:
>>
>> SELECT
>> EL1.ENTRY_LINK_TYPE,
>> COUNT(EL1.CHILD_ENTRY_ID)
>> FROM
>> ENTRYLINK EL1 INNER JOIN ENTRYLINK EL2 ON
>> (EL1.PARENT_ENTRY_ID = EL2.PARENT_ENTRY_ID AND
>> EL2.@Identity > EL1.@Identity)
>> GROUP BY
>> EL1.ENTRY_LINK_TYPE
>
> Sorry, try doubling it:
>
> EL2.@@Identity > EL1.@@Identity)
>
> - @Identity gets you a new value, sort of like calling an InterBase 
> generator
> - @@Identity gets current value for a row.
>
> Caveat: I'm not an MSSQL expert, I actually know this only from reading 
> other posts over time, so I *could* still be wrong, but I think I have it 
> straight now.
>
> -- 
> Wayne Niddery - Winwright, Inc (www.winwright.ca)
> "The moment the idea is admitted into society that property is not as
> sacred as the laws of God and there is not a force of law and public
> justice to protect it, anarchy and tyranny commence." - John Adams
>