Database

THE TRIGGER WON'T HAVE PARAMETERS.

Here other possible cases SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified[^] thatraja My Dad had a Heart Attack on this day so don't... Pompeyboy3 here | Nobody remains a virgin, Life screws everyone :sigh:

Then you'd better introduce OP to Bobby Tables[^] .. or maybe even discover him yourself. Peter Software rusts. Simon Stephenson, ca 1994.

thanks u :laugh:

I don't think you need dynamic columns. From your descriptions, the columns are fixed i.e. they are SalesCountry, CurrentMonthSales, and PriorMonthsSales. What you need is a dynamic report i.e. data is provided to the report depending on some input criteria. Assuming you are using SQL Server as the database, you need to create a stored procedure that takes a parameter for the current period, then it returns data to your report using those 3 columns. So, the data is dynamic but the columns are fixed. Since you don't specify what report engine or database you're using, I can't be more specific.

Look into 1) Mirroring - One of several strategies that give you fail-over protection 2) Transaction log backup - This is the preferred method for frequent backup needs. You do one full backup then use the transaction log backup to update a database.

Very true, but he's failed to indicate how a ResultCritVal or TargetCritVal are calculated or populated. He's only shown what values for the original columns are to be. By using the views I suggested, the conditions for each criteria are provided. How those column values are 'translated' to a ResultCritVal or a TargetCritVal would still be necessary. :) Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra] posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]

Thanks for this idea. The statistics did not bring improvement. Eventually an index on column Table1ID of Table2 brought the solution.

Keep in mind that it also doubles the size (in bytes) of the field! :) Luc Pattyn [My Articles] Nil Volentibus Arduum

Caveat I almost never use sql mail. Are you sure that you can use a public SMTP server from sql mail. It would never occur to me to try, we always use an internal server. Never underestimate the power of human stupidity RAH

You're doing fine, sensible question and layout is not critical, glad to be of service! Never underestimate the power of human stupidity RAH

I have always found it much easier to implement my own methods for populating, paging and editing in the DataGridView using POCO classes filled by using ADO than using DataSets to be honest. When I was a coder, we worked on algorithms. Today, we memorize APIs for countless libraries — those libraries have the algorithms - Eric Allman

Eddy Vluggen wrote: First add all the columns and do the insert when all columns are present, or make sure that the column you're going to add accepts null-values. its not sure how many column are in current sheet,so how can i do this? how can add column to accept null values. is there no any method to add column after inserting row in table.

Blue_Boy wrote: Did you mean get all column name list of current table. yes

Just wondering how you converted an xls file "back to the table in mydata"?

Try replication with SQL Server. In particular look at pull subscriptions. http://technet.microsoft.com/en-us/library/ms151170.aspx[^]

Thanks. Somehow I had missed that article. It does give a shove in the right direction. So far we have built a temp table instead. Maybe that can be made cleaner. :) Don