|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
You don't need a fax machine to get faxes. Get a fax-to-email fax number from CallWave. Try it free.
|
|
#1
|
|||
|
|||
|
need to change stored proc. a bit
ok here's the thing :
CREATE PROCEDURE Split ( @OrderList varchar(500) ) AS BEGIN DECLARE @OrderID varchar(10),@Pos int SET @OrderList = LTRIM(RTRIM(@OrderList))+ ',' SET @Pos = CHARINDEX(',', @OrderList, 1) IF REPLACE(@OrderList, ',', '') <> '' BEGIN WHILE @Pos > 0 BEGIN SET @OrderID = LTRIM(RTRIM(LEFT(@OrderList, @Pos - 1))) IF @OrderID <> '' BEGIN INSERT INTO Testowa(ide) VALUES ( CAST (@OrderID AS int ) ) --Use Appropriate conversion END SET @OrderList = RIGHT(@OrderList, LEN(@OrderList) - @Pos) SET @Pos = CHARINDEX(',', @OrderList, 1) END END RETURN END GO what it basically does is - it takes a string like '34,2,3,5' and takes ',' as a separator to retrieve values that it should insert into a table 'Testowa' what i'd like to have is : take string like '1,32,4,5' and recognize that it should insert values like this : table Testowa ------------- id | num ------------ 1 32 4 5 can someone rearrange this procedure for me so it'd do this? thanks
__________________
ania |
![]() |
| Viewing: Dev Shed Forums > Databases > MS SQL Development > need to change stored proc. a bit |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|