Stack Overflow
Stack Overflow

Questions tagged [ssms-2017]

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

188 questions
0
votes
4 answers

How to get dates based on months that appear more than once?

I'm trying to get months of Employees' birthdays that are found in at least 2 rows I've tried to unite birthday information table with itself supposing that I could iterate through them abd get months that appear multiple times There's the question:…
Vitaliy ehh
  • 7
  • 3
0
votes
1 answer

Arithmetic overflow error converting expression to data type int message in T-SQL code

I have the following code: SELECT ehrprg.ReportName ,ehrprg.AnnualGoalServiceMinutes ,COUNT(DISTINCT ct.[ClientFK]) AS [UnduplicatedClients] FROM [WH].[Fact].[EHRClinicalTransaction] ct …
Hell-1931
  • 489
  • 1
  • 6
  • 24
0
votes
3 answers

Unable to update sql table via php

This is the code I am using to try and update the record. I do not see any issues but it does not throw an error and states it has run successful. I have tried a couple of other methods that do the same, it just does not update the row in the…
ocdrew1503
  • 1
0
votes
1 answer

Invalid Column Name for computed column?

I have the following query, that works just fine if I comment out the part that is the reason for my question (as I've already done below). Declare @mPoint As varchar(50) = 'POINT (-107.657141 41.033581)' Declare @iRadius As int = 5000 --5km for…
Diamundo
  • 148
  • 11
0
votes
1 answer

SQL Server Management Studio 17.9 installation fails on Windows Server2016

I am trying to install SSMS 17.9 on a Windows 2016 server remotely. But after installation, while trying to open the Management Studio, its showing an error: The application was unable to start correctly (0xc000007b). SSMS-Setup-ENU.exe /install…
avk
  • 61
  • 5
0
votes
0 answers

Need a query to join 2 columns of the same table with max(column_name) condition

[![enter image description here][1]][1] SELECT POLICY_NO, FORMATTED_POLICY_NUMBER, POLICY_EFFECTIVE_DATE AS Effectivedt, POLICY_REWRITTEN_FROM Frompolicy, POLICY_EXPIRATION_DATE FromExpirationDate FROM…
Sam
  • 103
  • 1
  • 1
  • 10
0
votes
0 answers

I can't install SSMS 2017

I had installed the application but once I opened it it says that: Cannot find one or more components. Please reinstall the application. I had uninstalled the application for a lot of times but the error still exists. I tried to download VS2015…
Jimbo Delfin
  • 21
  • 1
  • 3
0
votes
0 answers

Login Failed for user 'reader' (SSMS)

I created a login called reader in my SQL Server and granted SELECT permissions to it for my database schema. After I logged in with the SQL Server authentication using the reader credentials, I tried executing a SELECT statement on a table and it…
Znigii
  • 1
  • 1
0
votes
0 answers

Issue while connecting to SQL Server from SQL Server Management Studio

We are facing a strange issue while trying to Connect to any SQL Server from the SSMS tool. We tried using version 17.9.1 and v18 Preview 7. Both are having the same issue. We are getting the below error while trying to connect to the database…
Silly John
  • 1,584
  • 2
  • 16
  • 34
0
votes
1 answer

Creating parent child label columns in SSRS

I have a stored procedure and an ssrs report that takes work orders of a certain category (user entered parameter, ex. A,B) and then selects other work orders of the unselected categories (C,D) that are within a user entered buffer distance…
Kurt Cederholm
  • 29
  • 7
0
votes
1 answer

How to set custom text in titlebar of SSMS(SQL Server Management Studio) 17 using c#

Trying to overwrite default title of ssms(sql server management studio) 17. Tried using below code for setting custom text. This code works fine on ssms 12 but in ssms 17 new title can be seen by hovering ssms icon in taskbar but when ssms 17 window…
Saurabh Koli
  • 1
  • 1
  • 1
0
votes
2 answers

Not able to order column in mysql

I am using this table from the Northwind dataset (can be generated from query below) +-----------+-----------+ | NumOrders | CustCount | +-----------+-----------+ | 1 | 1 | | 2 | 2 | | 3 | 7 | | …
NMB
  • 35
  • 1
  • 4
0
votes
1 answer

How to resolve an error converting data type varchar to float

I'm modifying a stored procedure and then executing it. Basically it's about inserting monthly claim table (which I have imported and all variables are VARCHAR(MAX)) into existing big table with previous historical data. Primarily what the stored…
Dev
  • 1
  • 1
  • 1
0
votes
1 answer

SQL Server Management Studio 2017 didn't show server name

I installed SSMS 2017 first then I installed SQL Server 2017. But it doesn't show any server names. Any one knows why its happens?
Dhanil Dinesan
  • 575
  • 9
  • 27
0
votes
1 answer

SSMS expand specific database

I have 1 database on a server that is hosting hundreds of databases, is there a way to connect to and expand only my database rather than expanding databases and seeing all of them? Please note that this is on a server at GoDaddy, that I don't have…
dmoore1181
  • 1,793
  • 1
  • 25
  • 57
1 2 3
…
12 13