SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• dtexec error

  Hi, When i was trying to execute the SSIS package through command prompt below: C:\Users>dtexec …

  SQL-Learner

  11 replies

  8 years, 7 months ago

  By: whenriksen

• Any way of joining data on two unique records, trying to cancel out matches

  In MSSQL 2016 I am trying to find charges that cancel each other out. For example: if a group of da…

  douglas.t

  13 replies

  8 years, 7 months ago

  By: douglas.t

• Retrieve value from a string

  Hi, I want to retrieve the ID value from CustomFields and insert into CustomID and get the Value an…

  PSB

  5 replies

  8 years, 7 months ago

  By: sgmunson

• Is visual studio of 64 bit available?

  Hi, I searched all the blogs to find visual studio 64 bit version. Do we have 64 bit visual studio …

  SQL-Learner

  2 replies

  8 years, 7 months ago

  By: Phil Parkin

• SQL query which returns a single aggregate metric indicating how well actuals met forecast for a given week

  Table: UnitsSoldColumns:•    ProductID•    Quantity• &…

  jeswar

  2 replies

  8 years, 7 months ago

  By: Jeff Moden

• Windowing function puzzle

  I have a complex query that produces data for multiple sets.  I need to ensure that for each s…

  Aaron N. Cutshall

  14 replies

  8 years, 7 months ago

  By: Luis Cazares

• SSRS - Embed an external website into a SSRS report

  Hi All Does anyone have any code or even if its possible to embed a webpage into a SSRS report? Kno…

  Ant-Green

  4 replies

  8 years, 7 months ago

  By: sgmunson

• Performance of Temp table vs Variable Table in a Procedure

  I have a procedure which returns 5000+ records and has a code of 500+ lines with mixture of differe…

  devaji123

  13 replies

  8 years, 7 months ago

  By: Eirikur Eiriksson

• Calculating sales by stock during sales periods

  Hi everyone I have a very basic knowledge of SQL so apologies if what I am asking is simple to do! …

  oaucamp

  4 replies

  8 years, 7 months ago

  By: drew.allen

• Having query trouble

  q

  gtrman57

  4 replies

  8 years, 7 months ago

  By: Mr. Brian Gale

• Function works when passing in parameters, does not work with CROSS APPLY

  Hi, I have a function that looks to work fine when I pass in parameters, but when I pass in a sing…

  kyagi.jo

  15 replies

  8 years, 7 months ago

  By: kyagi.jo

• SQL Server 2016 Express with Service Pack 1 - SSIS

  Can we create, run and execute the SSIS packages from SQL server Express Edition 2016 ? Does it hav…

  Kavita-284259

  4 replies

  8 years, 7 months ago

  By: Phil Parkin

• SQL SERVER AGENT JOBS MSDB

  Hi all, I'm trying to see what the difference in duration of backup jobs in msdb is in relation to …

  mikeneilson83

  1 replies

  8 years, 7 months ago

  By: heb1014

• Insert into # Select without order by

  Hi, We upgraded the code base from SQL Server 2008 R2 to SQL Server 2014 and noticed that the piece…

  sqlguy80

  2 replies

  8 years, 7 months ago

  By: Gail Shaw

• Reports for procedures that are in memory.

  Sql 2016 offers Query store which shows all top resource consuming  sql queries and proce…

  ishaan99

  1 replies

  8 years, 7 months ago

  By: Gail Shaw