ALTER PROCEDURE [dbo].[backup_database] ( @DbName VARCHAR(250), @dbpath VARCHAR(500) ) AS DECLARE @Currentdate VARCHAR(10) DECLARE @Currenttime VARCHAR(15) BEGIN BEGIN TRY SET @Currentdate =CONVERT(VARCHAR(10),GETDATE(),105) SET @Currenttime = REPLACE(RIGHT('0'+LTRIM(RIGHT(CONVERT(varchar,getDate(),100),8)),8),':','-') SET @dbpath = @dbpath +'' +@Currentdate+'_'+@Currenttime+'_'+@DbName +'.' + 'bak' PRINT @dbpath BACKUP DATABASE @DbName TO DISK = @dbpath END TRY BEGIN CATCH SELECT ERROR_NUMBER() as ErrorNumber, ERROR_MESSAGE() as ErrorMessage PRINT 'Backup Could not be taken for '+@DbName+'' END CATCH END
I want to run the above procedure at an interval of 8 hours.
I have a table that contain the votes(publicVotes) against each contestant. Now what i am trying to do is to calculate the percentage of votes each contestant recieved according to the column SchedularID. how i can get it done and would it be easy to user store procedure or view?
I have a certain report I want to make where I want to calculate the slope of a dataset(turnover column) following the formula:
SumXY-MeanY*SumX / SumXX-MeanX*SumX
In order to do that the X-range has to be an integer from 1 to the last datarow. In my report I get this exact number with the rownumber(nothing) formula. But it seems I can't calculate with it in the expression for the slope because it gives errors:
I need financial year in system date.actually i calculate financial year like below in VB code. [Code].... i just like the same in sql server query.for example suppose my query like"select*from admission where std_code=1 and fnyr in (select finy in system date)"<---i need here.
We have a demand system where customer can demand the quantity they want for a particular deal.
For each demand they submit, a new record is added to the DealDemandRequest table with the CustomerID, DealID, Quantity
I want to be able to to calculate the total quantity demanded by a particular customer. Current I query the DealDemandRequest table for all the records by a particular customer and then do a sum of the Quanity column.
However, we are expecting this table to be over 1 million record and it is reallly really slow right now.. Any better ways?
I had just started with Visual Studio 2008 + VB.net. I've now designed my tables, and basic gridview functions properly.Now I'm faced with the problem of having to calculate a value based on 2 - 3 columns/data in the gridview, display the result in an existing column in the same gridview, and saving the calculated value in the datasource.I had initially created the "Total" column as a textbox displaying a manually calculated amount that is saved in the datasource. Now, I want to change the field to auto-calculate based on 2 other columns.
I have a gridview, I am binding the gridview with a datatable and in the gridView, my autogenerateColumn is set to true since I am generating the columns dynamically coming from database. I am also doing doing showFooter =true. There are values in the rows of these dynamically generated columns. I need to calculate the average of each of these columns and display it in the footer. so for e.g, I have
A B C 10 11 12 13 14 15 16 12 11 -- -- -- 13 12.3 12.6
I am having some issues with the performance. I am binding a Gridview with around 200 records and it is taking a long time. At one time I only display 10 records on the page, but I bind all the 200 records.
Generally what is the number of records that should be bound to a gridview ?
I'm displaying a bunch of items in a ListView. Each item has a button that the user can click if he/she is not interested in the item. What I want to do is this: if the user clicks the button, I want to remove that item from the list but I don't want to necessarily make a datadabase trip for each and every item the user clicks. I'd rather make one DB trip and take care of all the items user has clicked. However, as the user clicks them, I'd like to remove them from the ListView.
I have created a student webpage with many tables like student info,test1 marks,test 2 marks and so on now i have to generate a report for each and every student with their details and average marks in each subject