SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• T sql question

  How can I do this?I want to create a store proc which execute the result of: Select name from sysjo…

  dan_27

  1 replies

  7 years, 3 months ago

  By: drew.allen

• what value will be returned

  If I use the following sql and there are no numbers in the range, does the fetch still return a row…

  work 22803

  1 replies

  7 years, 3 months ago

  By: laurie-789651

• Last 12 months report

  Hi, I have been trying to get a report to display the top 10 categories by sales for the current mo…

  aevans1981

  4 replies

  7 years, 3 months ago

  By: sgmunson

• DELETE data from table, WHERE a field in JSON column

  Hi, I have data in table "FileTable" with a json field, in that field there are values:{ "File":"Da…

  sirkinghorse

  1 replies

  7 years, 3 months ago

  By: debasis.yours

• LEFT JOIN with CASE subquery ?

  I am joining several tables together to do get pricing (a column) based on a code value (a col…

  usererror

  17 replies

  7 years, 3 months ago

  By: sgmunson

• Can I pull DISTINCT customers with SQL based on most recent row record only?

  So, I have a table where data is being saved. My table (CustomerSourceDE) looks something like this…

  mikewill

  32 replies

  7 years, 3 months ago

  By: Jonathan AC Roberts

• Installed SQL Server 2016 SP2 now AS cubes are not updating

  I updated our test environment with SQL 2016 SP2 CU1 from RTM. One of my developers is now rep…

  csmotter

  2 replies

  7 years, 3 months ago

  By: csmotter

• Help on Self Join

  Hi Team,Firstly a Happy Tuesday to Everyone!!I just want to understand th code.I basically see a se…

  sathwik.em91

  3 replies

  7 years, 3 months ago

  By: Luis Cazares

• Recommended Implementation

  I have two tables. Table A and Table B. Table A is the main table with all my main data and Table …

  NikosV

  9 replies

  7 years, 3 months ago

  By: NikosV

• Upgrade to Compatibility Level 130 (from 120) Causing Parallel Plans to Become Slower Serial Plans

  Hi, we're testing an upgrade of our data warehouse to SQL Server 2016 Enterprise, V13.0.5026.0.&nbs…

  chris.o.smith

  8 replies

  7 years, 3 months ago

  By: Lynn Pettis

• Loading more than 1 billion records from CSV File

  Hi Guys Need help. I need to load a very big csv file into SQL Server 2016. The file contains more …

  learningsqlkid

  19 replies

  7 years, 3 months ago

  By: DennisR

• How to Split the Sting in SQl Server

  Hi Team, I have a input string like below.declare @country varchar(max) = 'china or india and us no…

  kbhanu15

  8 replies

  7 years, 3 months ago

  By: Jeff Moden

• Query XML and convert the data into column

  Hello, How can i convert below XML data in columns. <event name="QueryEnd" package="AS" timesta…

  akash_singh

  2 replies

  7 years, 4 months ago

  By: Eirikur Eiriksson

• Why is this column varchar length -1?

  Hello experts, Following the code sample at this link:https://stackoverflow.com/questions/8976414/g…

  webrunner

  4 replies

  7 years, 4 months ago

  By: webrunner

• Query Performance Impact due to FOR XML PATH and Large Data

  Hi Experts, i'm running the following query and it takes large amount of time to execute, the sourc…

  contact.lash

  7 replies

  7 years, 4 months ago

  By: Sergiy