SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• Using a CTE in a subquery

  I have been tasked with identifying a set of users in one of our databases.  The following code sho…

  edwardwill

  6 replies

  5 years, 12 months ago

  By: Thom A

• How do append to date value?

  Greetings experts, I have a stored proc that uses table pivot to dynamically create  the value for …

  ciss1

  19 replies

  5 years, 12 months ago

  By: ciss1

• Getting a result set from temp tables

  So I have 5 queries . Each query fills a different temp table.  For each table the first two column…

  jasonlivengood

  3 replies

  5 years, 12 months ago

  By: drew.allen

• Solve HASH MATCH in query plan

  Hi, This is SQL Server 2016, by the way. I'm trying to optimize a query plan, especially attacking …

  Mauricio_

  1 replies

  5 years, 12 months ago

  By: Mauricio_

• SQL Query Help

  Hi: I have some values in Amount column as 0.00 1619.70 -62.20 34.40 0.00 0.00 23.00 -345.23 Where …

  SQL Server

  2 replies

  6 years ago

  By: jcelko212 32090

• Azcopy usinf sql sp

  Hello Experts, I am working on SP that sends my csv file from on prem machine to Azure blob contain…

  dallas13

  7 replies

  6 years ago

  By: dallas13

• Getting Error message while deploying

  System.ComponentModel.Win32Exception: A required privilege is not held by the client. Getting this …

  VSSGeorge

  1 replies

  6 years ago

  By: DinoRS

• Problem with simple stored procedure

  CREATE PROCEDURE sp_area @length int, @width int, @area int OUTPUT AS -- BEGIN is optional …

  michael.leach2015

  15 replies

  6 years ago

  By: Steve Collins

• SSRS Interview

  I am attending the interviews as a SSRS Report developer I put 3 years(2 Years Banking and 1 year i…

  shiva996

  7 replies

  6 years ago

  By: Alan Burstein

• using different databases / schema with stored procedure

  We set up a server with different databases. One for more financial data (ASAP_be), one for hr data…

  christoph.kauflin

  5 replies

  6 years ago

  By: Thom A

• How to pass output parameter as input to another stored procedure

  I have two  sprocs: I want the output char(1) value of first to pass to the second.  When I run the…

  polkadot

  8 replies

  6 years ago

  By: Steve Collins

• SSAS - Aggregation issue: “N/A” members be excluded from Excel “Grand Total "

  We’ve build a Finance OLAP Cube in SSAS which is mostly used/browsed by Accountants. Due to a “self…

  louw73

  2 replies

  6 years ago

  By: RonKyle

• StoredProc vs Function

  when we compare the sql server SP vs Functions SP may or may not return the value. where as functio…

  shiva996

  2 replies

  6 years ago

  By: shiva996

• execute T-SQL time different

  Hi everyone, I have a T-SQL procedure that runs on 2 different servers, on the same db, has differe…

  emanuele 8962

  7 replies

  6 years ago

  By: emanuele 8962

• Writing SQL in SSMS vs. Microsoft Visual Studio

  I am using SSMS to practice SQL.  I have seen several videos on YouTube where people are actually w…

  michael.leach2015

  6 replies

  6 years ago

  By: Grant Fritchey