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...

Luke identified that it's no problem running it concurrently.

i call it ugly search becauuse it's not something you want production users to use, and image you have a 12 million...

this might help;

i create a proc i called "uglysearch" which searches every varchar,char,nvarchar and nchar column for a string.

it returns the table and column, as well as the sql to...

there's no builtin search specific to the cliptext window, but the file of snippets you collect is saved in the \EditPlus 2\ folder as a text file ending in .ctl,...

hope this helps...this is the model i use for find and replace in text fields.

in this case, the sample is replacing a relative HTML link witha full http: link,...

can you paste the query as text here as well? it helps to be able to see that as text and not as an image in order to help better.

lol encrypting is a good answer. way to go!

there's an excellent stored proc called sp_generate_inserts Written byNarayana Vyas Kondreddi

http://vyaskn.tripod.com

he's got one for 2000 and 2005 and it generated statements like...

you can use the table value function as a joined table or as an in() statment as well, if it's not obvious: i used a #tmp table,b ecause you might...