here's the results of the second pass that Jeff asked for:

SQL2000/QA ...

ok here's some performance numbers from my machine, which has both SQL2000 and SQL 2005:

Jeff's inner join example took ...

I'm assuming the field is a varchar field,

you din't give an example but there's two methods to look at below;

if the values are always the same position, or the...

this isn't what you want to here, I'm sorry.

.NET does not use codes to identify it's exceptions like VB 6.0 did. In

.NET, everything you encounter is a "type", including exceptions....

Best;

by simply clicking on your name and looking over your previous posts, it's obvious that the moment you encounter a question, you post it here first without ever attempting to...

so...

Your saying CLR's are for people who know sql, or people who don't know sql...I'm confused. 😉

the way to do that would be with a scalar function then:

Create Function dateConstant ()

returns datetime

AS

begin

return '01/01/2007'

end

select dbo.dateConstant()

i might be second guessing you, but i believe you want to change the date to a PARAMETER, and not a CONSTANT, right?

If my re-interpretation is right, then you want...

something like this might get you closer to where you want to go... the fines are calculated, as well as the days delayed.

create table Borrowers(

MemberID int,

ItemID...

you'll have to save the winners in a table somewhere, in order to exclude them.

create table PreviousWinners(id int, Sample varchar(10))

select T1.ID,T1.Sample,MAX(RND) from T1,

Left Outer Join PreviousWinners on T1.Id=PreviousWinners.Id AND T1.Sample...

i don't think you can use a calculated column in this case, because the penalty amount resides in a different table(P as Penalty Table) than the items that determine the...

no i don't think your missing anything; an encyption method is a style to do it back and forth, but the actual implementation is not going to be the same...

The DBA Toolkit found here on SqlServerCentral includes an extended stored procedure for the blowfish encryption method:

http://www.sqlservercentral.com/articles/Security/sql2000dbatoolkitpart1/2361/

you could give that a try; it may or may not work; for example,...

you forgot the single quotes...

IF @TmpString NOT LIKE '[0-9]'

or if it was part of a large string, you'd add percent signs for the wildcard matches:

IF @TmpString NOT LIKE...

can't you test with two clauses in the WHERE statement for a match, and also that it doesn't have the trailing word after it? you need to take the spaces...