sql server

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

I have a SQL agent job that I want to have kicking off 4 other SQL agent jobs using the following: EXEC msdb.dbo.sp_start_job 'My Other Job' Now each job is its own step, however, the job does not wait to see if the job finishes successfully, it just

I have a Lucene Index .FDT file that is about 5GB. I add records to it very often(1000 records per day) and none will be deleted. It has 5 fields and only one of them is text content of html page. I also run a query parser on this index to look for s

I have a stored procedure, uspUser_GetUserDetails, with several parameters. It gets called something like this: uspUser_GetUserDetails 'LastName','FirstName', 'UserId', 'dtDate', 'DistrictId' How do I run the stored procedure if the dtDate parameter

Here is what I am trying to do: SELECT iif(d.ItemType = 'INVOICE', 0, iif(d.ItemType = 'PACKING', 0, 1)) AS MissingDocuments FROM dbo.DocumentDetails AS D Unfortunately realized this is not compatible with MSSQL2008. So tried writing an IF ELSE but t