sql server

I need to allow multi select on a column where the values are all CSV. I had been using a LIKE statement and a single select parameter but I need the parameter to allow multiselect. An idea I had was to create columns for each of the parameter values

I'm trying to create a matrix with historical data for some parameters I have in a table. The matter is, when I try to pivot it, won't work. Using the following code SELECT concept, [1] '1993', <...>, [23] '2015' FROM (SELECT concept, YEAR(begin_dat

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

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