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 |
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
 Posted - 2008-04-11 : 13:57:29
|
| how we can concatenate the two values as one parameterCREATE PROCEDURE dbo.usp_GetTD @CTMP VARCHAR(100)ASSELECT * FROM tablePWHERE Ptno IN (@CTMP)execute usp_temp '111-11-1111','222-22-2222'Thanks for help in advance !! |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-04-11 : 14:10:32
|
http://www.sommarskog.se/dynamic_sql.html
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-04-14 : 05:20:47
|
| http://www.sommarskog.se/arrays-in-sql.htmlMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
concatenate