of course!

thanks for the recap!!

My query extracts the daily sales figures from production for the previous day and every morning at 9am a report is sent to management detailing everything that has happened the...

i have the html mail up and running, but im hoping i would be able to reference an external css file with images sitting on a server somewhere.

is this...

is it possible to reference external style sheet and images for a sql mailer?

can anyone help with an html mailer?

DECLARE @AppPasswords TABLE(PasswordID INT IDENTITY(1,1), UserID INT, Password VARCHAR(50), PwdDateCreated DATETIME)

INSERT INTO @AppPasswords (

[UserID],

[Password],

[PwdDateCreated]

) VALUES (

1,

HashBytes('MD5', 'fakepassword'),

'2008-11-24 10:16:44.461' )

SELECT * FROM @AppPasswords

IF EXISTS (SELECT * FROM @AppPasswords WHERE

[UserID]...

no worries people. i found a solution.

:w00t:

mmm, looks like hashing the column is the preferred method...

any advice and code examples?

yip. got it to compile.

but i found a better way, as my previous post.

thanks guys

found a solution. just declare a table variable with columns, UserID, Merchant and Classification

and make necessary changes.

DECLARE @user-id INT

DECLARE @OldUsername VARCHAR(50)

DECLARE @NewUsername VARCHAR(50)

DECLARE @OldClassification VARCHAR(50)

DECLARE @NewClassification VARCHAR(50)

DECLARE @OldMerchant...

hi Seth, you code does not compile.

Msg 137, Level 15, State 2, Line 28

Must declare the scalar variable "@NewUserName".

Msg 137, Level 15, State 2, Line 41

Must declare the scalar variable...

thanks

thanks... had anyone else worked on something similar who can offer some more advice?

thanks guys

thanks thats fantastic. exactly what i was looking for...