Stack Overflow
Stack Overflow

Questions tagged [ssms-2014]

Microsoft SQL Server Management Studio 2014 is a graphical tool for configuring, managing, and administering all components within Microsoft SQL Server. Use this tag specifically for questions related to Microsoft SQL Server Management Studio 2014.

SQL Server Management Studio 2014 is a tool included with Microsoft SQL Server 2014 for accessing, configuring, managing, administering and developing all components within Microsoft SQL Server. The tool includes both script editors and graphical tools which work with objects and features of the server.

SSMS combines the features of Enterprise Manager, Query Analyzer, and Analysis Manager, included in previous releases of SQL Server, into a single environment. In addition, SSMS works with all components of SQL Server such as Reporting Services and Integration Services. Developers get a familiar experience, and database administrators get a single comprehensive utility that combines easy-to-use graphical tools with rich scripting capabilities.

On Wikipedia: SQL Server Management Studio

206 questions
-1
votes
1 answer

Migrating data from one table to another in SQL Server

Above is the sample table I am working on. I imported tables "All Fruits", "Fruit A", "Fruit B", "Fruit C", and "Fruit D" from access database to SQL database (for brevity I didn't include all table data). I have created new empty table…
PhatLee
  • 37
  • 9
-1
votes
1 answer

How to automate exec stored procedure without SQL Agent

I have a stored procedure in SSMS 2014 that I want to automate to run daily, but I don't have SQL Agent at my new company. Is there a way to schedule this so I don't have to manually run the "exec spWhatever" in SQL each day? Someone suggested a…
TWaller
  • 81
  • 1
  • 7
-1
votes
1 answer

Conditional formatting if then statements

I am trying to get what would be considered a 'nested if' function in excel to formulate in a query. The goal of the query is to create a view so that I can compare two sets of data. If in excel the formula would look like this:…
user2243
  • 23
  • 3
-2
votes
1 answer

Split brackets into columns - SSMS

I have a string value [a1.1]+[a2.1]+[a3.1]+[a4.1] I need the string value within each bracket to show in a single column but have no idea how to approach this. Any help would be appreciated An example of the output that i need is…
Humza Yusuf
  • 33
  • 7
-2
votes
2 answers

Convert rows to columns in SQL Server Management Studio

I'm posting the query below which I used to retrieve the data and output how it shows and how do I need also .. please let me know how can I convert rows to columns data
Santhosh kumar
  • 23
  • 2
  • 8
-2
votes
2 answers

How to CAST an INT data type as a BIGINT data type?

Someone suggested that the reason I get an error Arithmetic overflow error converting nvarchar to data type numeric when running some code is because I need to convert the INT data type of one of my variables to a BIGINT data type. Does anyone…
Mr 2017
  • 103
  • 2
  • 6
  • 15
-2
votes
1 answer

I just installed SSMS 2016 and it has an odd low-resolution feel to it. SSMS 2012, on my PC, still looks normal. Any ideas?

I just installed SQL Server Management Studio (SSMS) 2016, started it, and it has an odd low-resolution feel to it. Dialog heading are slightly blurry, and things just don't look like previous versions of SSMS. For example, SSMS 2012 still looks…
user7050575
  • 51
  • 1
  • 8
-2
votes
2 answers

grouping when column contains NULL

I have the below query: SELECT VoucherId, PosDateEntered, SUM(VoucherFaceValue) AS ValueIssued, SUM(AmountUsed) AS ValueReedeemed, RVtransactionAmount FROM [dbo].[LoyaltyVoucherTransactionDetails] WHERE …
PIPRON79
  • 131
  • 1
  • 1
  • 11
-3
votes
3 answers

sql multiple column concatenation using stuff

i have two columns invoice status and vendor number.i want to concatenate invoice status into one row based on vendor number using stuff vendor num invoice status 70000141 V-Parked Items 70000141 V-Parked Items 70000141 not…
cherrycharitha
  • 35
  • 2
  • 9
-3
votes
4 answers

SQL Server query to get the total for each row

I have two tables InvoiceLine and Discount: I need to get a result set which includes invoice Line items with the total (SUM) of discounts in the discount table like below: How can I achieve this using only one query?
Chathuranga Ranasinghe
  • 529
  • 1
  • 4
  • 21
-5
votes
1 answer

Grouping and sum in sql

I am trying to extract the following columns from a sql table called Vouchers: Date, VoucherID, ValueIssued, ValueRedeemed, Valueexpired That bit is straight forwards and returns the below data: However I would like to show them by day, by…
PIPRON79
  • 131
  • 1
  • 1
  • 11
1 2 3
…
13
14