SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• SSMS version 17.x Task List Window

  Hi All, I have version 17.4 at this writing.When I call up the task list window, I do not see …

  f_matthews

  2 replies

  5 years ago

  By: JediSQL

• Stored Procedure with Money Value

  hi everyone, I've a "problem" with a Stored Procedure and .net application because two values (mone…

  TheProof

  8 replies

  5 years ago

  By: TheProof

• Use a while loop or cursor for querying row by row and insert results into temp

  Hi, connectiondetails 1.SELECT * FROM OPENROWSET('MSDASQL','Driver={MySQL ODBC 5.3 ANSI Driver};ser…

  sathwik.em91

  19 replies

  5 years ago

  By: Lynn Pettis

• Unable to debug a sproc

  I'm trying to debug an SP in visual studio 2019 (what a palava! bring back this ability in SSMS ple…

  Jay@Work

  21 replies

  5 years, 1 month ago

  By: x

• CONNECT BY result

  Hi friends, How can we get multiple dates and days for the given number? In this example, 10 is giv…

  iniyavan

  2 replies

  5 years, 1 month ago

  By: iniyavan

• SQL View Question

  Hi everyone, I've a little problem with a SQL View that there's no way to resolve (from my side). I…

  TheProof

  18 replies

  5 years, 1 month ago

  By: Steve Jones - SSC Editor

• Time Difference in Minutes for the Given Dates

  Hi friends, We have a table as below: DAY_OF_WEEK: 0 - Monday, 1 - Tuesday,... 6 - Sunday TIME col…

  iniyavan

  4 replies

  5 years, 1 month ago

  By: iniyavan

• Open Datasource

  Hi  I am trying to create Open datasource query to connect to mysql from sqlserver 2017.Could some …

  sathwik.em91

  1 replies

  5 years, 1 month ago

  By: Mike01

• Transform Columns to Rows dynamically using T-SQL

  Hi All, I have the following table : tbl_Survey   My goal is to transform it into the followi…

  Hell-1934

  1 replies

  5 years, 1 month ago

  By: DesNorton

• Configuring Connection Managers For different DBs in different jobs

  My team has just learned that using one db for all clients will not work and all clients need their…

  dndaughtery

  6 replies

  5 years, 1 month ago

  By: dndaughtery

• Trying to Make combinations within a bracket in SSMS column

  I have a column in SSMS where I am looking to make different combinations. For example I have a col…

  riddhi10

  71 replies

  5 years, 1 month ago

  By: Jeff Moden

• A faster way to parse QueryPlan XML???

  Long story short, I'm in the process of doing some index cleanup. Getting rid of or merging redunda…

  Jason A. Long

  12 replies

  5 years, 1 month ago

  By: Jason A. Long

• SQL Query Help - CHARINDEX

  Need query help. create table #tblTest1 (ID int, SName varchar(50), Type varchar(10)) INSERT IN…

  SQL Server

  9 replies

  5 years, 1 month ago

  By: Jeff Moden

• How to performance tune ssis pkg when dev environment isnt as good as prod

  Hey everyone, my dev envoronnebt has 56 GB of memory and 4 virtual processors with a speed of 2.29 …

  dndaughtery

  2 replies

  5 years, 1 month ago

  By: Jeff Moden

• Loading 20% of an index in to memory to get a small % of the table's data

  We have a table as follows: CREATE TABLE [dbo].[TAudit_History]( [HistoryID] [int] IDENTITY(1,1) N…

  julian.fletcher

  12 replies

  5 years, 1 month ago

  By: julian.fletcher