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 |
|
baddulas
Starting Member
11 Posts |
 Posted - 2014-06-27 : 03:04:05
|
| Hi All,Please help me...I need a stored procedure's for below Scenario:tblProduct is a parameter table that has values list of Products and every product has code (Eg, PEN A, BOOK B , PENCIL C and so on)For every value a procedure sp_findIndex will be called sp_findIndex finds the index of the alphabet based on the tblKeyValue a key value table which has two columns key and value, key 1,2,3.... and values A,B,C..Further sp_findIndex calls sp_evenOdd with the index as input and provides an output whether index is an even or an odd number which is printed through sp_findIndex procedure Task 1List down even and odd for all the products.Task 2Now warp this logic to stored procedure sp_wrapper which takes input Product names separated by comma.Thanks in Advance......... |
|
|
djj55
Constraint Violating Yak Guru
352 Posts |
Posted - 2014-06-27 : 09:02:49
|
| What do you have so far?djj |
 |
|
|
|
|
|
Stored Procedure Creation