SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Using CTE to update multiple columns in table and loop on all rows in table

  I'm a SQL newbie and am trying to use a CTE on all rows in a table, to update multiple columns in e…

  selene.platt

  8 replies

  8 years, 1 month ago

  By: ChrisM@Work

• 70-461 exam

  I bombed this exam and afterwards discovered the 70-461 Querying Microsoft sql server 2012 book has…

  fizzleme

  13 replies

  8 years, 1 month ago

  By: Eric M Russell

• SSRS report rendering error after SQL 2016 upgrade: ExecuteReader requires an open and available Connection

  Hello experts, We recently upgraded one of our database servers from SQL 2012 Enterprise Edition to…

  webrunner

  1 replies

  8 years, 1 month ago

  By: Sue_H

• Dynamic Like

  Hi all, I am trying to UPDATE the column SupplementaryInformation in the temp table #temptitle3, …

  ringovski

  4 replies

  8 years, 1 month ago

  By: anand08sharma

• Evaluating use of InMemory tables... Why is it slower than temp tables?

  I created a table like thisCREATE TABLE blahblahblah(  LeafLevelDatasetId  INT NOT NULL …

  Eric Mamet

  9 replies

  8 years, 2 months ago

  By: SilentOne

• Difference in row-size between what was expected and what was — can anyone explain please?

  Hi everybody, I am creating a table that will be the basis of a fact table for a cube. I have 3.1 …

  sean redmond

  17 replies

  8 years, 2 months ago

  By: sean redmond

• Record count difference

  I am trying to determine what I am doing wrong to get different record counts between the 2 below q…

  lucaskhall

  2 replies

  8 years, 2 months ago

  By: Ed Wagner

• Altering SSMS script templates

  Hi everyone,Quick question regarding SSMS default scripting templates. When browsing the object exp…

  jmann84

  1 replies

  8 years, 2 months ago

  By: Bill Talada

• INFORMATION_SCHEMA views

  Just curious, how many of you use the INFORMATION_SCHEMA views?  Personally I prefer to use th…

  Lynn Pettis

  9 replies

  8 years, 2 months ago

  By: Alan Burstein

• Evaluating use of InMemory (session) tables... How do I delete orphaned rows?

  If I create an In Memory table as a replacement for temp table (aka Session in memory table?). How …

  Eric Mamet

  2 replies

  8 years, 2 months ago

  By: Eric Mamet

• MERGE Output logging options

  I've created a SPROC to move a set of data spread over multiple tables from one database to another…

  planetmatt

  1 replies

  8 years, 2 months ago

  By: David Burrows

• Need Help in converting a ETL job to MYSQL Query - please help me

  Hi,I am pulling Data from MYSQL Server I need SQL Query for the logic (please see the attached file…

  barathkumar.vijayakumar

  1 replies

  8 years, 2 months ago

  By: Phil Parkin

• Need help in SQL table for updating NULLS

  Name Clinic Number1 Clinic Number2 Clinic Number3 Jeff 531-2531 622-7813 565-9901 Laura NULL 77…

  shwets47

  18 replies

  8 years, 2 months ago

  By: Phil Parkin

• Max Dates and Joins

  Hi Everyone,     I have a query like this: SELECT ORDERS.GFNo,   …

  meichmann

  4 replies

  8 years, 2 months ago

  By: drew.allen

• Always Encrypted Error in Sanbox Database

  Hi, So I finally got some time to try our some SQL 2016 functionality and I've run into a bit of an…

  NicHopper

  7 replies

  8 years, 2 months ago

  By: richardm-1037631