Hi, This kind of problems are called Cross Tab Queries and can be solved easily using PIVOTING (a feature from SQL SERVER 2005+). Here is an example Pivots with Dynamic Columns in SQL Server 2005[^] You can even look into a) Cross-Tab reports in SQL Server 2005[^] b)Using PIVOT and UNPIVOT[^] In Sql Server 2000, Pivoting was achieved using Case along with an aggregate function. Look here Pivot Table Data in SQL Server 2000 and 2005[^] However, a few days back I gave a similar kind of answer in Bytes. U can have a look Month to month yearly results[^] Hope this helps :) Niladri Biswas

Hey.. This is not dealing with any AJAX requests to WebMethods. Dont mix up this with client server architecture. Actually you are now dealing with Server-Server communication. Just add Web Reference to the Webservice from within your proxy webservice. The Classes will be created automatically. You just need to create object of them and call the functions of your need. :-D http://msdn.microsoft.com/en-us/library/8wbhsy70(VS.80).aspx[^] This might help you... :rose: Abhishek Sur My Latest Articles **Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB **Don't forget to click "Good Answer" if you like to.

Use Max(stringvalue) for your aggregate function (you are after all aggregating 1 value), you can see an example here[^] Never underestimate the power of human stupidity RAH

Thanks for the information. I really was hoping this would not be the case. So then the next questions will to be; Is there a way via stored procedure to: A. Command for turning on and off constrants? B. Command to turn off and on auto increment, or would truncating reset increments to 0? C. Is there a command that will allow for copying data between one DB server and DB another in SQL 2005? D. Is any of this easier in CLR functions? Thanks, Leo T. Smith Program/Analyst Supervisor

Actually I ready keep the sensitive information on server only, but there comes a time when knowing when an element has changed a value could be useful. I find the reasons more compelling as I use AJAX and client side scripting. An example would be for an extender control that needs to do some action when the control that it has extended (i.e. text input) has had its value changed is used to set other internal things within the control. If there was a trigger that fired when this happened, you would not force a programmer to use your behavior to set things up when the value changed. I know that under the current paradign this is not a common occurance, but in the future it could become a greater problem in making more user friendly applications. Just my thoughts. Thanks for your time, Leo T. Smith Program/Analyst Supervisor

You can use the Page.ResolveUrl method or the Page.ResolveClientUrl method to turn a path containing ~ into a path usable in the browser. This of course doesn't work for CSS files or Javascript files, as there is no server code in them. Despite everything, the person most likely to be fooling you next is yourself.

Leo Smith wrote: EXAMPLE:Validation (): Element 'scriptmanager' is not supported Looks like you are missing AJAX framework

I would recommend using Windows Authentication. You can set it up independently of wither or not the web application is using windows authentication (ie. you can still use it when the web application is set to 'enable anonymous access'). You'll need to configure the application pool identity to a domain account. Then instead of adding a windows login to your SQL Server instances for the account add a group and grant permissions on your SQL Servers to that group. Then you can manage the user accounts used by your web server using your domain controller w/o affecting your sql servers or worring about SID issues. I'm assuming your application doesn't require Windows Authentication, but just to cover all the bases in case you need it - you can temporarily set the identity of the user for a block of code and impersonate the windows domain account when you need to for database access while maintaining the identity of the user for all other contexts w/in the application. Mark's blog: developMENTALmadness.blogspot.com

Glad to be of some help. Regards, Gareth.

You could use an INSTEAD OF UPDATE trigger that fires when an UPDATE statement is executed against your table. The inserted table would contain details of the changes which were going to be made. You can then examine these values and execute a different UPDATE statement which either updates the fields as they were originally going to be updated, or sets fields to NULL where the value <= 1/1/1900. Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush

I've not get exactly what you are looking for... however check whether sp_adduser and sp_addlogin solves your problem. Regards KP

Thanks, Leo Leo T. Smith Program/Analyst Supervisor

You can invoke API calls with C#.

Thanks, a couple of these looks like what I need. I went and checked them out locally and actually found one. Leo T. Smith Program/Analyst Supervisor

I'm not familiar using xp_sendmail- i only tried to send mails by using sp_send_dbmail. Did you try out this function? maybe you could use that one!