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 |
|
TajKazi
Posting Yak Master
101 Posts |
 Posted - 2014-11-27 : 02:31:14
|
| v_to_maillist := v_nominatorEmail;v_email_key_value_pair1 (1) (1) := 'Award Info : ';v_email_key_value_pair1 (1) (2) := v_awardinfo;v_email_key_value_pair1 (2) (1) := 'Nominee(s) : ';v_email_key_value_pair1 (2) (2) := v_nomineeinfo; v_email_key_value_pair1 (3) (1) := 'Nominated By : ';v_email_key_value_pair1 (3) (2) := v_nominatorinfo; v_email_key_value_pair1 (4) (1) := 'Modified By : ';v_email_key_value_pair1 (4) (2) := v_modifiedby;PKG_FORGE_CLIENT.USP_CREATE_NOTIFICATION(null, v_to_maillist, null, null, v_email_context, v_email_subject, v_email_content1, v_email_key_value_pair1, v_email_content2, p_iserror); here i passing values as an array please someone tell me how to do this in sql server |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-11-27 : 09:31:14
|
| In SQL Server (and standard SQL) an Array is represented by a table. So, create a table for v_email_key_value_pair and use that instead. |
 |
|
|
|
|
|
array