Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
zolf
Starting Member
15 Posts |
 Posted - 2007-09-29 : 02:44:18
|
| Hello there,how can i pass my own parameter values in the subject of Subscription email?.for example i want to pass the employee ID in the subject. |
|
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2007-09-29 : 12:12:29
|
| set the expression of the subject to:=Parameters!EmployeeID.Value.ToStringOr doesn't the subscription have access to the parameters? |
 |
|
|
zolf
Starting Member
15 Posts |
Posted - 2007-09-30 : 01:37:57
|
| thanks for your comment. Can I add a String and the employeeID.for example- Salary Receipt of =Parameters!EmployeeID.Value.ToString |
|
|
|
coolerbob
Aged Yak Warrior
841 Posts |
Posted - 2007-10-01 : 04:24:58
|
| ="Salary Receipt of " & Parameters!EmployeeID.Value.ToString |
|
|
|
zolf
Starting Member
15 Posts |
Posted - 2007-10-01 : 04:40:41
|
| thanks mate.appreciate your help.cheerszolf |
|
|
|
|
|
|
Pass Paramenter in Subject of Subscription email