I am looking for more advanced code samples which presents following
senarios.
+ SP which transfers recirds from dataset/datatables/result sets.
+SP which performs some operations on datatable/dataset/recordset brfore

Hi all -- apologies in advance if this should be posted in another newsgroup
(which one??)
I have migrated an application from:
   VS 2003 + SQL Server 2000

i have a big table and i want to split a column
exemple
columnA = 'TOTO THE CLOWN'
i want to :

I've written a managed (C#) stored procedure with the following signature:
[Microsoft.SqlServer.Server.SqlProcedure]
public static void Sproc(string startDate, string endDate, string idList)...
Sometimes when I call this sproc, my comma-separated list of IDs exceeds