...

You're welcome. I have to keep SQL2K as well as SQL2K8 db's going and continue development in both environments. Lots of times, great tips come along, that just flat out don't help much in SQL2K ... At least I don't have to keep SQL7 and 6.5 working any...

You're welcome. I have to keep SQL2K as well as SQL2K8 db's going and continue development in both environments. Lots of times, great tips come along, that just flat out don't help much in SQL2K ... At least I don't have to keep SQL7 and 6.5 working any...

You're welcome. I have to keep SQL2K as well as SQL2K8 db's going and continue development in both environments. Lots of times, great tips come along, that just flat out don't help much in SQL2K ... At least I don't have to keep SQL7 and 6.5 working any...

I guess you could use them together: SELECT CHOOSE(IFF(....),url1, url2) As for the IIF, I guess that will make MS Access users happy. I am not sure it does anything much better than the CASE statement. Anything that is not ANSI, however, wil...

i-catching solutions...

I guess you could use them together: SELECT CHOOSE(IFF(....),url1, url2) As for the IIF, I guess that will make MS Access users happy. I am not sure it does anything much better than the CASE statement. Anything that is not ANSI, however, wil...

Of course, this does not work in SQL Server 2000. declare @n int set @n = 3 -- works in 2K8 - Fails in 2K select top (@n) * from tally -- works in 2K8 and 2K set Rowcount @n select * from tally s...

Of course, this does not work in SQL Server 2000. declare @n int set @n = 3 -- works in 2K8 - Fails in 2K select top (@n) * from tally -- works in 2K8 and 2K set Rowcount @n select * from tally s...

Of course, this does not work in SQL Server 2000. declare @n int set @n = 3 -- works in 2K8 - Fails in 2K select top (@n) * from tally -- works in 2K8 and 2K set Rowcount @n select * from tally s...