Decreasing a value across multiple rows until 0 - If I have several records in a table such as this: 100 50 50 20 And I want to subtract 175, I want a result...
Finding a substring and extracting a number associated with it - Hi, I have a text string that appears in files as below: 'There were 6 discharges and 3 admission since reporting 21/04/2016' However...
Job doesn't run as per schedule at 1:05a, but runs when triggered manually. - Hi, I am not sure if this is a unique issue for me or is it a known issue for others...
Stored Procedure execution - Hi Team, In one of our prod server one stored procedure is taking long time to execute than normal execution. It is...
Somewhat urgent issue related to AG - All, I have this error in a logfile "Unable to access availability database because the database replica is not in...
TSQL Select specific records and child records from same table - Hi guys. I'm fairly new to SQL, but learning quickly. I've got a situation where I need to query a...
CTE Script Needed for delete statement - Hi, we are using below script for delete records.but it is taking time USE AdventureWorks2008R2; GO DELETE * FROM Purchasing.PurchaseOrderDetail WHERE DueDate = '20020701'; GO is there any possibility...
query performance tuning - Hello! I am running a query which is taking 23 mins to run in my dev server. I need your...
Using SSIS to copy rows from SQL server 2008R2 to MySQL - I'm hoping that someone might have some good advice on this one. Basically I have a table with 3.5M rows...
Single database attached to two instance - how to take backups from each instance - This is venu, i am learning SQL Server DBA.... while practice i got a doubt. 1. I have attached "AdventureWorks2012' in...
How to practice SQL server at home - Hello everyone. I would like to know if it is possible to use SQL Server Management Studio at home so...
Query - Hi I have 1 query which returns record order by ID like this. Now i want that in addition to the...
not able to find why/where this error is comming. - hi, i am getting this error"The current transaction cannot be committed and cannot support operations that write to the log file....
HTML Backup Report Design Considerations & T-SQL script - I'll be quick on this one. Basically, I have a requirement to develop a script that would provide the client...
Help creating a dynamic table of numbers - Hello all, I'm trying to dynamically create a table of days spanned for a aging report. I would like the end...
Date Range overlaps - hi I have the sample data:Insert Into @Table (Id,Code, StartDate, EndDate, TimeDiff) [code="sql"]SELECT 1, 'DA6310', '2016-06-20 09:25:00.000', '2016-06-20 11:15:00.000', 110 Union...
What are the different database types? - I will be celebration the USA's Independence, have some bar-b-que and go hiking with my family. :-D But I also intend...
SSRS show trend chart by up and down arrow over column chart per series groups - chart data Values- No of Itemsold Group-Product(ProductA,ProductB,ProductC...) Series -Year(2013,2014,2015,2016) I have to show the trend of the item sold for each group by a...
SSRS report manager not rendering charts - We have built out a new report server using SQL 2012. After deploying our new and old reports to this...
Rename file - prefix with file date - I receive three versions of a file each day, which I then import. But the file names are such that...
