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

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