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
0
votes
1 answer

Return a 0 when no data present

I have looked at a few questions similar and tried to apply my own knowledge to get the query to work correctly but still cant get the outcome i desire. I have 5 Call lines i need to report on from our DB. The problem is some of them can go a full…
Heislegend31
  • 41
  • 2
  • 9
0
votes
1 answer

creating a total field in SqL

The issue is that I can't figure out how to sum up a column. Sounds rudimentary but that is the issue. The field in question, area, has no aggregate value. There are 17 distinct areas. I know how to produce the report for the 17 existing area…
Tim Wilcox
  • 1,275
  • 2
  • 19
  • 43
0
votes
1 answer

Optimize a Repeating Union All SSMS Query

I'm creating a report that will get uploaded to QuickBooks. I have to UNION ALL 7 queries due to a single calculation change in each one. Below is an example of the first two queries: SELECT Clients.Id ,@CNumber as 'Check Number' ,@TDate…
Nahuatl_C137
  • 132
  • 1
  • 13
0
votes
1 answer

Add new database to SSMS

Trying to add Progress Open Edge database into ACCESS 2016 that is already connected to SQL Server Express. Spoke with the folks at Progress and they sent me a paper on how to do it via SSMS. I have the Progress ODBC driver installed and the test…
jpl458
  • 595
  • 3
  • 9
  • 17
0
votes
1 answer

Find a way to create multiple columns that average data by different groupings within the same SQL query

This query provides us with the time of various operations. Right now it breaks it down the time for each event by name, date, and the shovel model. However, I'm looking to somehow join the average of all the names in one crew into a new column.…
Fishingwest
  • 13
  • 4
0
votes
1 answer

Is SQL Server Management Studio 17.1 compatible with SQL Server 2016 (Developer Edition)?

I've installed SQL Server 2016 Developer Edition, because Microsoft states: SSDT database projects in Visual Studio 2017 currently support up to SQL Server 2016. Support for SQL Server 2017 will be coming soon in a Visual Studio 2017 update. My…
AlexMelw
  • 2,406
  • 26
  • 35
0
votes
2 answers

A Column to count number of distinct values in column X based on column Y?

In SSMS 2016, I have a select statement with various joins which gives me the following data: | box_barcode | order_number | order_shipment_id | item | qty | |-------------|--------------|-------------------|----------|-----| | 3330000001 |…
Smeghead
  • 185
  • 3
  • 12
0
votes
1 answer

SQL Server Management Studio executable deleted

One of my colleague has accidentally deleted SQL Server Management Studio 2016 executable (ssms.exe) from C:\Program Files\Microsoft SQL Server\130\Tools\Binn\ManagementStudio. Can it be restored ?
izengod
  • 1,116
  • 5
  • 17
  • 41
0
votes
1 answer

Error Validating SSIS Package When Attempting to Run in 32 Bit Mode Within SSMS

I have a SSIS package that is currently deployed to my SSISDB. This package is required to run in 32Bit mode and does fine when I change the '64BitRuntime' setting to false within SSDT. My issue comes about when I try to run it in 32 bit mode after…
user3708795
  • 23
  • 1
  • 5
0
votes
1 answer

SQL Server DBCC Check Fail

If I set DBCC CHECK to run as part of a job; will the job fail (and subsequently alert me) if an allocation error/consistency error is found? USE [mydb] GO DBCC CHECKDB(N'mydb') WITH NO_INFOMSGS
glass_kites
  • 401
  • 4
  • 18
0
votes
0 answers

SSMS System Functions not right color

I recently installed SSMS 2016 and when I opened some code I have saved it looked a little strange. Then I noticed that a lot of keywords were not the right color. I figured out that all System Functions were not being colored correctly in the text…
BilliD
  • 577
  • 2
  • 7
  • 17
0
votes
1 answer

difference between release number and build number in SQl Server Management Studio

From this link I downloaded Microsoft SQL Server Management Studio and it was written (16.5.3) but I think it is actually version 13.0.16106.4. When I read the page more carefully I saw the build number for this release: 13.0.16106.4 I took a…
Omid Sadeghi
  • 675
  • 7
  • 16
0
votes
2 answers

How to Uninstall SQL Server Management Studio 2016?

I have problem with SSMS 16.5.2 in this quetion, (Subquery returned more than 1 value in SSMS 2016). I already uninstall Microsoft SQL Server Management Studio from control panel. But after uninstall, the shortcut program in start menu already…
Liudi Wijaya
  • 898
  • 2
  • 8
  • 24
0
votes
1 answer

How to use sp_helptext with schema without quotes (for query shortcuts)

All my procedures, views are in schema xx. I know I have to use quotes in this case and when I run exec sp_helptext 'xx.my_procedure' it works fine. However I would love to use query shortcuts (I am using SSMS 16) for sp_helptext. When I select…
Daniel Fendek
  • 3
  • 1
  • 3
0
votes
0 answers

Query window remains connected even after Object explorer is disconnected

Recently I have updated to SQL Server Management Studio 2016. After this update, query windows remain connected to the SQL instance even after we disconnect from that instance in the object explorer - queries can still be run without providing…
Raj
  • 1
1 2 3
…
11 12