Is there any simple way to detect and resolve SQL server database deadlock ?
My custom application hangs and the developer suspect that there is deadlock in the DB which I must fix for the…
Output I need below
Keycol data LineNo
I have this query that is supposed to look for instances occuring within the same timespan as the given dates. What I want is to see is if a person with a particular personID is booked …
What is the error in this code.?
DECLARE @OrderId AS INT = 10028
SELECT * FROM Orders
WHERE OrderId = @OrderId
Appreciate your help.
I have two tables (tablea and tableb). I would like to set the value of a column in tablea (call it tablea.column1) to zero, if I find a matching row in table b. The matching is done on 3 fields. The …
I have a SQL database that has a table for invoice header information and another for invoice detail information linked on invoice number. There is a 1:many relationship between header and detail. I…
Whats wrong in this query - Select * from tableA,tableA
I choose to run update statistics via maintenance plan, however when the update stats is complete I realized only some of the tables get updated whereas most of the table are not being update …
I have this currently but its producing duplicate rows.
I added a group by before the where and added the fields from prev and data table but it wouldnt run
Why i am getting a star, SSMS does not show me any error. Division Error
SELECT CONVERT(VARCHAR(2), 7140 / 12)
The USP creates a pk to for insert into TblCompare events.
Its falling down when it hits a null entry on the data field Fieldname as change or fieldname as prev. all the other pk components can …
I got this error when trying run my sql query... "Conversion failed when converting the varchar value 'Id' to data type int"
Please help me :(
I'm getting the attached error in my function, and when clicking on error it points me to something that doesn't really helps.
How can I find the culprit?
I have a table that I want to insert new data at the end of each day. The problem is I only want to insert data if the row doesnt already exist, the problem is to find out if the data already exists,…
I have a job on my SQL 2005 server that I want to view/Modify in SSIS but cannot find the package that is in the Job I have looked everywhere on the server and cannot find the package a want to …
i wanna check cte has value or not. if cte has value i will add all cte to my table. But error occurs:
Msg 156, Level 15, State 1, Line 20
Incorrect syntax near the keyword 'IF'.
I had this question after viewing SQL number of rows to be put into vertical columns (https://www.experts-exchange.com/questions/28998933/SQL-number-of-rows-to-be-put-into-vertical-columns.html).
I copied a database created in SQL Server Expressed to another drive. I then tried to attach it to a SQL Server Developers edition. I am getting this error:
TITLE: Microsoft SQL Server Management …
We had an Exchange 2003 Server on premise. We have moved to Office 365.
My email notifications from SQL Server 2005 have stopped working as I would have expected as the old exchange server …
Anyone would have some script that kills a lock process after a period of time and send email with headblock?
I have 2 tables a and b. I want to remove duplicates from table b which have a entry in a .
Sample data :
table a1 table a2
Hello EE experts,
I have a folder and I need to get the most old file from a folder in the SSIS package.
Is it possible? What transformation I can use for this?
Appreciate the help.
How do I subastract row 1- row2, etc.. within a same column to find a gap between the two row? I know how to do this via sql if between two column, but in my case all within a same column.
i "use Windows autentication"
i execute this t-sql
grant showplan to [SMI\elopezh]
the message is: Command(s) completed successfully.
i "included actual execution …
Let's see if I can explain this adequately...
I have two tables. The first table has a student's full name (first, middle, last). The second table has the name broken into it's parts (one field …