Sorry for bothering everyone =)

I got it to work =) Using CURSOR =)

var1, var2, var3 and etc will determine whether email needs to be sent or not.

so result is to sent email. I use sp_smtp_email for that or something like it.

sample for...

Ok, how can I use WHILE here? SOrry for my stupidity.

var1, var2 and etc - they check for number of notes for users and if they are > 0 - it sends out emails to them. The problem is we...

Nevermind everyone =) I made it work

that's just a part of sp_smtp_email thingy...

it returns 1 or 0. When it returns 1 - nothing was sent, 0 - when it was sent successfuly

Alright, thank you. I never even paid attention to Management section in EM =)

I'm not familiar with Windows-based stuff.... where such job can be created?

got it to work.

Simple thing like that:

UPDATE Leave_Professional_Funds SET [SApproved] = @RegFee WHERE [LeaveRequestID] = @LeaveID AND [Name] = "Registration Fee"

 UPDATE Leave_Professional_Funds SET [SApproved] = @ETFee WHERE [LeaveRequestID] = @LeaveID AND [Name] =...

Oh ok,

Thank you.

INNER JOIN FOO.num1

or left join?

Would that be ok though if user decides to sort only by one column? Cuz that way only 'xxxx,x' would be passed in.

if that would be ok, could you show...

Alright, I figured something out =) Thanks.

Alright, I figured something out =) Thanks.