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
vote
4 answers

SQL Server query for multiple conditions on the same column

Here's the schema and data that i am working with CREATE TABLE tbl ( name varchar(20) not null, groups int NOT NULL ); insert into tbl values('a', 35); insert into tbl values('a', 36); insert into tbl values('b', 35); insert into tbl…
Kapil
  • 165
  • 1
  • 9
1
vote
1 answer

View query without sub selecting T-SQL

so I'm trying to build a view query but I keep failing using only joins so I ended up with this deformation.. Any tips on how I can write this query so I don't have to use 6 subselects? The FeeSum and PaymentSum can be null, so ideally I do not want…
robert-boettcher
  • 13
  • 3
1
vote
0 answers

Remove permission for Delete database object for a User in Azure SQL Server

I would like to know how can we restrict a user from deleting the database object which is in Azure SQL Database. I Created a new user with the below script -- Create a user for the server who has access for Read and Write in the Database -- Use…
Sreenivasan
  • 21
  • 3
1
vote
2 answers

How to run Sequential Jobs using job schedule in Sql server

I have a requirement that i need to run multiple jobs in a sequence. Let's say I have 20 jobs which already existed. These jobs are depending on each other. Right now i am running these jobs manually like below run Job1 --> run job2 upon Job1…
Chandana Puppy
  • 133
  • 1
  • 9
1
vote
4 answers

Is there a way to select last N columns in SQL Server Results Tab?

Shortly, I don't mean the last 5 rows. via SELECT TOP 5 * FROM Table Order By Key DESC But I mean last 5 columns in Results Tab. Why? because each time I add a new column and filling it outside SQL-Server, I need to see its result without moving…
deveton
  • 291
  • 4
  • 26
1
vote
0 answers

Add columns to query result

DECLARE @strPivotColumns NVARCHAR(MAX) SELECT @strPivotColumns = STUFF((SELECT DISTINCT ', ' + item FROM table WHERE id = '9972' FOR XML PATH('')), 1,…
Mr_gemini
  • 43
  • 1
  • 6
1
vote
1 answer

group by with multiple columns and with condition

My query used to be SELECT PROVIDER, LEFT([START_TIME],13) as [HOUR], DEVICE_ID as BIKEID FROM table1 GROUP BY PROVIDER_NAME, DEVICE_ID, LEFT([START_TIME],13) and it was working fine. Due to certain conditions I changed rule…
Mr_gemini
  • 43
  • 1
  • 6
1
vote
2 answers

Trying to a Select Count where it needs to count the difference between a certain date and current date

It's not quite working for me! My query is as follows: SELECT COUNT (*) as [generic] FROM [Log] Where value IN (Select ID, tsSendDocument, sysReceivedFrom WHERE sysReceivedFrom = 'generic' AND DATEDIFF(hour, tsSendDocument, GetDate()) > 2) So,…
Mads Clifford
  • 13
  • 3
1
vote
1 answer

ASP.NET cannot connect to SQL Server database on the same machine

I have a local SQL Server database setup on a Dell R720 running Windows Server 2012 R2 and I am developing an ASP.NET site. I am able to connect to the database and pull in objects and queries and everything EXCEPT when I try to pull in the login…
Truth is a person
  • 45
  • 5
1
vote
1 answer

How can I parse out unwanted text data from a field

I am using sequel server management studio 2014, and I am wondering how I can parse out what is extraneous data for a select query. I do not wish to modify the data, only to grab what I need from it for a SSRS data source, to automate a query. The…
Thomas
  • 105
  • 1
  • 6
1
vote
3 answers

How to retrieve data from SQL Server as required below?

I have a table like this : CustName Country RecordedTime --------------------------------------------- Alex Australia 2018-Jun-01 08:00 AM Alex China 2018-Jun-01 10:00 AM Alex Japan 2018-Jun-01 11:00…
Mar1009
  • 721
  • 1
  • 11
  • 27
1
vote
1 answer

Max and Decode convert in SQL Server

I want to convert this piece of the query to run in SQL Server its taken from an Oracle query: SELECT x.JudgmentMonth, MAX(DECODE(x.RecordType, '1', x.Volumes)) CONSUMER, MAX(DECODE(x.RecordType, '2', x.Volumes)) COMMERCIAL FROM …
Vinnie S
  • 13
  • 1
  • 9
1
vote
0 answers

InterSystems Cache Database and SSMS Integration Services Catalogs

I am trying to built a SSIS package thru BIDS VS 2013. My Datasource is a InterSystems Cache Database, I wanted to Import Tables records from the Datasource to MS SQL Server 2014. As a Sanity check. I only created one Package to import one Table to…
Maki
  • 201
  • 5
  • 11
1
vote
1 answer

Adding double quotes in SSMS 2014 Results (Response Needed from Original Post)

I have been reading over the answers to the question posed here: How to get export output in "real" CSV format in SQL Server Managment Studio? I find the post by Joel Coohoern most useful, but have a follow-up question. My rep is not sufficient to…
bortp
  • 13
  • 4
1
vote
1 answer

MS SSMS - Object reference not set to an instance of an object. (Microsoft.VisualStudio.Editor.Implementation)

I am facing an issue in MS- Sql Server Management studio 2014. Upon writing a query and executing it in SSMS, i get the following error. Object reference not set to an instance of an object. (Microsoft.VisualStudio.Editor.Implementation) I have…
Deepak
  • 85
  • 2
  • 11
1 2 3
…
13 14