i have a string "12345690-1239949-499-9878-" it may contain any number of studentID's
its being passed to a stored proc variable of string DataType in SQL Server 2000
the prob is if it exceeds 8307 length it would fail.
I want to split the string and loop thru it and let only 8307 (length) of studentIDs be passed to the stored proc in a loop (calling loop multiple times in the loop) how can it be done...
lets say max is 8307 / 8 digits being passed as studentIDs so the no of records passed = 1038 records passed successfuly. So I can display a message to the client that way