Regardless the advantage or disadvantage of doing that, i want to know, is it possible or not, and how to do it!

More than 300!!

A lot of them!!!

For two reasons.

1. To reduce the total number of stored procedures in my DB.

2. And i want to compare the performance whether...

Well, the structue is a normal table structure. However, i do have a web based application ASP.NET with VB.NET, and i would like to insert thousands of rows in one...

CREATE PROC SP_validatePayment

@AmountPaid numeric(9),

@MethodOfPayment int ,

@ListOfBillsPaid nvarchar(4000)

Begin

DECLARE @TranStarted...

Well, are u saying that i have to have more than one connection string in my web.config, each on which will have its own credentials!!??

Hello,

ok thx

Thanks for your replay, however, i temporarly created a table that will hold the final data for my report, and also another view for it.

what i did was, i...