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.
Questions tagged [ssms-2017]
188 questions
0
votes
1 answer
How to flag if something doesn't appear in a list
I am not sure how to word this exactly in a title, but I have a list of people who have multiple records, each row is a record and one field lists which type of record it is. What I need to do is to be able to flag if somebody doesn't have a certain…
Becky Purland
- 89
- 10
0
votes
2 answers
SUMIF then restart count
How can I do a SUMIF function so that it adds up values when the value in another column is "False", but then when it hits a value that is "True", it restarts the count over again, but includes the value of the first "True" encounter in the SUM…
Empyz
- 59
- 2
- 11
0
votes
1 answer
Excel Pasting SQL Server Results Set Only Into Column A
I am experiencing issues trying to paste a SQL Server SSMS results set into Excel using Copy and Paste. When I try to paste into a spread sheet all of the values go into the first column.
Steve_Malcolm
- 53
- 1
- 9
0
votes
2 answers
What is the advantage of mapping relationships in Entity Framework without mapping in the table
I have seen that in some systems, relationships are mapped in Entity Framework without being mapped in the SQL tables. What is the point of using Entity Framework to map relationships over mapping them in SQL?
Chanuka Naveen Koswatta
- 75
- 10
0
votes
0 answers
SQL Server 2017 Remote access
I have tried every conceivable permutation for hours to try to connect to a remote SQL Server 2017 using SSMS. I keep getting:
Logging failed for user xxx. (Microsoft SQL Server Error 18456)
I know SQL Server is running on the remote machines…
Ivan
- 7,448
- 14
- 69
- 134
0
votes
1 answer
Setting up access to SSRS report requiring login to data source
I have a report that accesses sensitive data and I'm required to have the user log in to the SSRS portal and then again into the data source to make sure the data isn't viewed by the wrong staff.
I feel like I've tried everything at this point, but…
theeviininja
- 157
- 7
0
votes
2 answers
Need to resolve issue with complex where clause for multiple criteria
I have a project I am working on that I am combing several tables into one with left joins so that dbo.spi is the main. My problem comes from the where clause and pulling anything with a null.
There are several pieces of criteria that need to be met…
james k
- 29
- 4
0
votes
1 answer
Declare Scalar Variable error in SQL - SSMS
When I execute the below SQL statement, I get an error
Must declare the scalar variable "@AuditKey"
I feel like this is so simple and I am making a really dumb mistake. Thanks in advance!
ALTER PROCEDURE [ProjectSpecific].[spTarget]
--…
JShep
- 11
- 2
0
votes
4 answers
How can I make numerous calls to my stored procedure using the values of column?
I have developed a stored procedure in SQL to verify if a 13 digit national ID number is valid or not. At the moment the procedure works fine but I can only verify 1 number at a time. Procedure returns 1 if valid and 0 if not. Is the a way I can…
TMDBN
- 11
- 3
0
votes
1 answer
How to connect SQL Server by host IP Address
I'm trying to connect new host in SQL Server using IP address, but I got some trouble when I'm trying to log in SSMS 2017. I'm still relatively newbie about using SQL Server. Here's the error message:
when I'm trying to login:
And here when I…
Zaqi Salman Alexa
- 70
- 11
0
votes
1 answer
How to replace row value with previous saved row value in SQL SERVER 2017 SSMS
first of all my problem is so complicated and sorry for my bad english
So, I got some Table-Valued Function query in SQL to Automatically Generate 5 rows for every single day I select on VB
Here some Example how this Table-Valued Function works in 2…
Wayne
- 3
- 4
0
votes
0 answers
Insert Into: Returns inserted records
I'm trying to insert some new records into a table and return the inserted records.
DECLARE @newRecords TABLE
(
Id INT NULL,
Col1 VARCHAR(MAX) NOT NULL,
…
jwlford
- 58
- 8
0
votes
1 answer
Extracting Multiple Numerical Values from Text
048(70F-Y),045(DDI-Y),454(CMDE-Y)
I have the above data in a column field, I need to extract each number before the, so in the above example I would want to see 048, 045, 454.
Note the data in the field will change in each record in the above you…
James
- 23
- 5
0
votes
2 answers
How would you use string functions to separate data by individual terms
I am trying to split names into columns, for example, column 1 named "Name would contain in row 1 the varChar "Jesus Lopez" How could I split it up so that I can create a second column with row 1 to contain "Jesus" and a third column with row 1 to…
0
votes
1 answer
How to run python code directly with correct syntax within sequel server management studio 2017
I wrote a python script that takes data from sql via "import pyodbc" The data this scrip pulls is parsed into a text message gateway API to send text messages to customers accordingly. This works fine in python.
However, now I want to write a sql…
Magnifique Nsengimana
- 30
- 1
- 6