Fiddler[^] Navaneeth How to use google | Ask smart questions

Summary takes a delegate to calculate tax, however, the Summary method seems out of place since there is nothing to provide a return value to amount meaning the only possible action the summary method can perform is to sum all of the applied taxes. Need software developed? Offering C# development all over the United States, ERL GLOBAL, Inc is the only call you will have to make. Happiness in intelligent people is the rarest thing I know. -- Ernest Hemingway Most of this sig is for Google, not ego.

I suggest the default is bc it is useful when coding a proc, it is only when you go to production that you want to turn it off. It would be nice to be able to turn it off as a database/server option. Never underestimate the power of human stupidity RAH

Chris Maunder wrote: Can you go here[^] and let me know if it's seeing your phone as a mobile device? Yes it does. It detects the Browser as "IPHONE", and Display Mode is "MobileDevice", and down below "Mobile device" is True. Regards, Nish Nish’s thoughts on MFC, C++/CLI and .NET (my blog) My latest book : C++/CLI in Action / Amazon.com link

whenever you are going to use cache , that mean it is server side and can be accessable by all. suppose you have 5000 records that can be displayed to maximum user, then simply put the data into cache by retreiving from database first time, rathar than calling every time from data base. it should improve your performance. but while using caching, you have to consider many points like, cache dependecy, Expary etc. cheers, Abhijit Think Sharp | Code Sharp | C Sharp

You wrote your own ETL Solution????? :omg: could you give me a headstart on that..not sure if i could have thought of that ever... Keep DotNetting!! GeekFromIndia

Now I am applying for last 2 weeks for various companies and there is no call for interviews During the last computer recession six years ago, I went eight months without an interview. I would go for months without even a callback to tell me to drop dead. Granted, I'm fairly specialized, but my friends weren't having any better luck either. Anyone who thinks he has a better idea of what's good for people than people do is a swine. - P.J. O'Rourke

Hi, for each tuple in source table you have to create 3 instances in destination table, you can do this via stored procedure, by help of various methods of choice. take temp table with columns [SrNo numeric identity(1,1)] and four column of source table. transfer source table into temp table take max SrNo in a variable say count for each row of temp table from 0 to count BEGIN insert destination table([source col1],[source col2],F1,[source col3] insert destination table([source col1],[source col2],F2,[source col4] insert destination table([source col1],[source col2],F3,[source col5] END I think this way will transfer all your record from source table to destination table in desired manner. Bi

It's hard to say what's a better way since you don't specify what is it that you are not satisfied with in DTS. However, another alternative could be using bcp (Bulk Copy Program) from command line or SqlBulkCopy class from C#. Mika

yeah...thats the way we are doing right now... but if your table is accessible at many places/procs in application it can be difficult to manage or make sure that every developer is adding this attribute. if anyone missed it..our business logic will fail...so i feel its better to add a trigger once and forget about it.. but i was wondering if there are any disadvantages of using triggers??? Keep DotNetting!! GeekFromIndia

Great. Did wonder, I usually test first but couldn't this time. Still, it got you where you wanted to go. :-D Bob Ashfield Consultants Ltd

you can check to if the HttpContext is null.If HttpContext is not null then its an ASP.NET web application: if (HttpContext.Current != null) { //We are in a web app, use a request scope }

Schemas can be used to organize any type of objects. You just make the schema owner dbo. Here is an article discussing the topic. http://www.sqlteam.com/article/understanding-the-difference-between-owners-and-schemas-in-sql-server[^]

You can use AJAX framework to handle the exceptions from webservice. Have a look at it[^]. Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Try using Server.MapPath to resolve the virtual path in to physical path from the dll. You should reference the System.Web.dll before trying to do that. HTH Nirandas, a developer from India. http://www.nirandas.com