I identified a couple of Update statements on a Large Partitioned table as Deadlock victims from extended events. How should I proceed with Fixing this? This table doesn't have an Index. We are using UniqueIdentifier (RefGuid) in where clause of both
I make Chart Report using SSRS I have problem is my long series label not show whole text For Example if label is "Personal Computer" it's show "Personal C......" see image below and this is whole Chart area it's have more space betwee
Simply this is my Question. I'm using SQL Server 2014 Standard Edition A) SQL Server Browser Enable B) TCP/IP, Named Pipes, Shared Memory Enable C) Default Port 1433 D) Server Properties -> Connection -> Allowed remote connections to this server E)
I want to update date time column in my SQL server.Consider the date time column contains following values, 2015-02-13 00:00:00.000 2015-02-18 00:00:00.001 2015-02-21 00:05:00.002 2015-02-13 00:03:00.003 2015-02-19 01:00:00.004 2015-01-13 00:00:00.00
I know how to check if the values exist in both table, but how can I add a column indicate it find something SELECT NAME, ID FROM TABLE_A TA WHERE EXISTS (SELECT 1 FROM TABLE_B TB WHERE TA.ID = TB.ID) Result NAME ID 1 123 2 234 3 345 What I want NAME
I tried many query to achieve the expected result , I couldn't find any solution. Actual:- ID | EmpDailyFee | EmpMonthlyFee | CompDailyFee | CompMnthlyFee 1 NULL 12 NULL NULL 1 50 NULL NULL NULL 1 60 NULL NULL NULL 2 50 NULL NULL NULL 3 NULL 30 NULL
I am trying to match IP addresses. The input IP address can be "5.1.82.1". So, I am matching like first part of input IP address with all the IP address in database that start with 5. My query is like following SELECT top 1 PARSENAME(ipaddress,
I need to put some chemical data into a table. But I realized that unicode hasn´t got subscript/superscript code for all characters in alphabet. For example I´m trying to type "org" ("C_org" - organic carbon) as subscript into column b
I have two tables TwitterStatus and twitterstatusDetails, I have data respectively in following manner. Here as given in twitterstatus table 4th record with the ts_StatusID "587573444633427968" is parent of twitterstatus_Details table 3rd record
I'm trying to get data for the rolling 13 weeks, but not sure how to do it correctly. I have tried this: DATEDIFF(week,Completed_date,GETDATE()) < 13 But I get 14 weeks instead of 13 and I think this might get me incorrect results as it goes 91 days
How can I write: SELECT TOP 1 x FROM y ORDER BY NEWID() using querydsl-sql? (See http://stackoverflow.com/a/4980733/14731 for an explanation of what the query does) --------------Solutions------------- I ended up doing the following: import com.mysem
Really long story short, I have two datetime fields in a table that I am loading into variables @DateFrom and @DateTo, and I need to "explain" what sort of range they cover in text for presentation on the screen. Although the fields are datetime
I have the following error when creating a new database in SQL Server 2012: because it is on a volume with sector size 2097152. SQL Server supports a maximum sector size of 4096 bytes. Move the file to a volume with a compatible sector size. CREATE D
Aim to write a statement to produce a table with a numeric column that contains contra values, e.g. Ref Value a 100 b 75 c 50 c -50 b -75 a -100 I am new to SQL but aware it works row by row, so the only way I could think of doing this is write an in
How could I get all the tables from one of databases I have in just one SQL instruction Thanks. --------------Solutions------------- To get a list of all tables in a database you can query the sys.Tables. Simply: SELECT * FROM sys.Tables;
I have created the following on which in can perform query with out where clause clause but when I use the following query: select * from teacherSub where teacher = "te123"; it generates an error: Msg 207, Level 16, State 1, Line 2 Full code: US
This question already has an answer here: Integer division in sql server 5 answers Can anyone tell me why this is not returning a decimal- only Zeroes. Set PercentComplete = (CSCCalled + HospCalled + NoCalls)/(TotalInventory) CSCCalled is an Integer
When I run a report in my Report Server, it will provide the results, but it is missing several rows and random cells of data. When I run this report in SSRS, it contains all the data. I did change the DataElementOutput on the report from "Auto"
I am trying to create a simple indexed view on the query below. But when I try to create a unique clustered index on it, I get the following error: Cannot create the clustered index '..' on view '..' because the select list of the view contains an ex
I noticed I can create login under sql server/security tree node. I can also create login under sql server/databases/database name/security tree node. My question is what's the difference between those two security logins? --------------Solutions----