The version of the "publish" page is linked to the version of Visual Studio. If you want the newer page, you need to upgrade Visual Studio. VS2019 community edition is free, so there's no reason to continue using such an ancient version: Visual Studio Community 2019 - Free IDE and Developer Tools[^] "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

Did you try the latest versions of Visual Studio like 2017 or 2019? They have radical improvements right from the installer stage.

That's not creating multiple parameters, that's appending two strings, so the ID that you would be creating would end up looking something like this - __$$txtID__$$txtName (I know, those aren't the actual characters that would be put in, but this is for demonstration) - so, the ID that the JavaScript would be looking for wouldn't exist anywhere on the page (BTW - this question has nothing to do with the .NET framework, you would have been better off posting this in the ASP.NET forum instead).

Your SQL box timed out sending the mail to your mail server. You need to increase the timeout. Depending on which version of SQL you have, you might need to install a Cumulative Update in order to change the timeout: https://support.microsoft.com/kb/968834[^] You should then be able to use the sysmail_update_account_sp stored procedure[^] to increase the timeout. "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

/****** Script for Select the Time difference in HH : MM ******/ SELECT [Id], CONCAT (DATEDIFF(HOUR ,StartDate, EndDate), N' : ', (DATEDIFF(MINUTE,StartDate, EndDate) % 60)) as TimeTaken FROM [dbo].[YourTable] Above example, I am first finding the Hour, then finding the minutes. Finally, do a Concatenation to get the results in the format of HH:MM. Hopes this helps.

How do you expect us to find out code for that transformation if you refuse to tell us the transformation rules?

And if the workload isn't too heavy you could use a Web Service (WCF or similar) to provide a single access point so the clients don't actually touch the database. The service could then perform the actions one-by-one. You'll never get very far if all you do is follow instructions.

Hi First create table CREATE TABLE apl_Error ( Error_Desc VARCHAR(MAX), Error_Date DATE ) After that create this procedure CREATE PROC SAMPLE @ERROR_DESC VARCHAR(MAX) OUTPUT AS BEGIN BEGIN TRY CREATE TABLE #TABLE(ID int,fName varchar(20)) INSERT INTO #TABLE VALUES('A1','CHOICE') SELECT @ERROR_DESC=NULL END TRY BEGIN CATCH INSERT INTO apl\_Error(Error\_Desc,Error\_Date) SELECT cast( RTRIM(LTRIM(CAST(ERROR\_STATE() as CHAR(10)))) +','+ RTRIM(LTRIM(CAST(ERROR\_LINE() AS CHAR(5))))+','+ERROR\_PROCEDURE()+','+ERROR\_MESSAGE() as varchar(max)),GETDATE() SELECT @ERROR\_DESC='Error on Inserting' END CATCH END to execute this procedure DECLARE @NAME VARCHAR(MAX) EXEC SAMPLE @ERROR_DESC=@NAME OUTPUT SELECT @NAME AS Error_Description then see apl_Error table now you can see the message and date. Error_Desc Error_Date 1,8,SAMPLE,Conversion failed when converting the varchar value 'A1' to data type int. 2013-07-05

Hi Robymon, The example you have given is incorrect. Adding 12 days to 20-02-2013 will not give result as 01-03-2013, but will give 04-03-2013 The solutions given by "Richard Deeming" and "Dennis E White" are correct. Thanks & Regards, Niral Soni

I wouldn't do that. It's against the "Rules" of normalization. You don't want to make a row dependant on another row in the same table. Think of all the fuzz to update the table when you find out someone inserted some wrong data last year, or when HR decides to change the rules (quite probable actually). So you should make a query that gets you the result you want instead. Hint, checkout ROLLUP. For example: SELECT EmpID, CASE WHEN (GROUPING(Leave_Year) = 1) THEN 'Total Balance' ELSE ISNULL(Leave_Year, 'UNKNOWN') END AS Leave_Year, SUM(Balance) AS Balance FROM MyTable GROUP BY EmpID, Leave_Year WITH ROLLUP I haven't tested this code, but it should give you an idea. I also assumed SQLServer, Different Databases have different syntax. Use Google. Be excellent to each other. And... PARTY ON, DUDES! Abraham Lincoln

There is no inbuilt-mechanism to restore or read deleted rows in SQL Server 2000. You must implement logical deletes instead of physical deletes to be able to achieve that. (For example, an IsDeleted(bit) column in every table). As Eddy suggested, the only other ways is to work on a restored copy of the database.

Crossposting is evil... You should never do that here, it is annoying. We wander from forum to forum willing to help. For easy/fast questions Q&A, for longer questions forums. Keep in mind that crossposting will get you downvotes though. [www.tamautomation.com] Robots, CNC and PLC machines for grinding and polishing.

I have modified the solution to include the dynamic query.

try searching first[^]

As you are trying to create the date from a specific string, you should realise that the problem is actually at the point that you parse the date. Basically the to indexes in your substrings are out by one. Try: var today = new Date(Dte.substring(6,9), Dte.substring(3,4), Dte.substring(0,1)); *pre-emptive celebratory nipple tassle jiggle* - Sean Ewington "Mind bleach! Send me mind bleach!" - Nagy Vilmos CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier

Put it like, CONVERT( VARCHAR, @To AS DATETIME, 103 ) ) - Happy Coding - Vishal Vashishta

Look here: Calculating the Difference between Two Dates in JavaScript[^] Difference in Years, Months and Days[^] A good discussion here: Difference in Months between two dates in JavaScript[^] Sandeep Mewara [My last tip/trick]: Browser back button issue after logout

Thank you very much...