sql server

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'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----

I have a web application (Spring framework) having SOAP Web services (Hibernate for Persistence) that are called from external systems. When the call volume is high it is throwing alot of DeadLock exceptions. Transaction (Process ID xx) was deadlocke

I am currently looking at setting up a number of SSRS data sources to a warehouse but one issue I can not get around is how to define which views are available to each data source. Can someone share how to limit these down so that I can have multiple

I have two table: Orders, and ODetail. I want to create a table that shows the sum of sales of year 2012 grouped by year, quarter and productline (which is a case). Here is my SQL code: SELECT * FROM (SELECT YEAR(o.OrderDate) 'Year', DATEPART(Quarter

I am using this sp which gives me Information based on two chosen months. I now need a syntax within this store procedure which tells me whether a product in month 1 unchanged in month 2 or was new in month 2 etc. My store procedure: CREATE PROC [dbo