Stack Overflow
Stack Overflow

Questions tagged [ssms-2016]

Microsoft SQL Server Management Studio for SQL Server 2016 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 for SQL Server 2016.

172 questions
-1
votes
1 answer

Data Pivoting in SQL using columns of SQL

Following is the Table Structure and below to that is desired output. Please press Run Code Snippet to see the table structure. Existing Structure

…
Utkarsh Agrawal
  • 29
  • 1
  • 6
-1
votes
1 answer

How to reenable missing Context Menus on SSMS July 2016

I installed latest SSMS (July 1, 2016 Edition) and for some reason some of my context menus are gone. For ex: Edit Top 200 Rows Rebuild Index It is only specific to certain SQL server. But, I found that my other machine with same SSMS edition…
kurakura88
  • 2,185
  • 2
  • 12
  • 18
-2
votes
2 answers

Subquery returning more than one result?

I run this query: SELECT CAST(PolicyNumber AS varchar(50)) POLICYNUMBER, CAST(EFFECTIVEDATE AS DATE) EFFECTIVEDATE , MAX(CAST(EXPIRATIONDATE AS DATE)) EXPIRATIONDATE, CAST(ISSUINGCOMPANY AS varchar(4)) AS INSURER, …
ETL - BI
  • 59
  • 9
-2
votes
1 answer

How to create a template in SQL Server Management Studio for retrieving the data and segregate the data according to the requirement?

I need to build a template by using SSMS for extracting data from server and the same data should display according to the requirement. For example I have data pertaining to 5 different Sizes. Each size have 4 variables which I need to extract from…
Rahul
  • 17
  • 2
-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
-3
votes
1 answer

Loop through current table to find if column is a primary key?

I have a temp table called #ColumnList that holds a list of column names. I need to loop through each row in this table and look to see if the column is a primary key. If it is a key then I need to add that column name to a column called…
Terrance Jackson
  • 606
  • 3
  • 13
  • 40
-4
votes
1 answer

how to pass multiple rows with a single column in a stored procedure in SQL

how to pass multiple rows using a single column in a stored procedure in SQL (SSMS)? or how to pass single column values in a procedure. CREATE TYPE tblAge_Type as TABLE ( ID int, Age…
Babita
  • 1
  • 1
1 2 3
…
11
12