SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Using new GetIdentificationStringByID to get Column Name in SSIS

  I'm using SSIS to load tab-delimited text files into a SQL staging db. Naturally, I'm having to dea…

  lduvall

  16 replies

  8 years, 10 months ago

  By: frederico_fonseca

• explain composite index structure and work? How B Tree for composite index work internally?

  HI Champs, explain composite index structure and work in sql server ? How B Tree for composite inde…

  ravi@sql

  1 replies

  8 years, 10 months ago

  By: Gail Shaw

• TSQL and if it can be done in set

  Hey Experts, This recently came up at work and the solution to the problem was utilizing a loop. I…

  brad.mason5

  6 replies

  8 years, 10 months ago

  By: Umer Akram

• SQL 2016 OPENJSON Array

  Hi, I have a mix of data in a table as follows: person_id interests 1&nbsp&nbsp&…

  rka

  2 replies

  8 years, 10 months ago

  By: The Dixie Flatline

• TST 1700 If a food product

  TST 1700 If a food product is labeled as fat-free, be cautious about it. These foods may be high in…

  johnvasquez

  1 replies

  8 years, 10 months ago

  By: johnvasquez

• Ltrim not working, not able to remove prefixed "-" from a column.

  Hello, I have a problem, ltrim is not working. Here is the scenario I imported data to a table…

  sanjaydut26

  5 replies

  8 years, 10 months ago

  By: The Dixie Flatline

• Check for Columns in the table and then Execute next Tsql statements

  Hello Everyone, I have a problem, We have different client specific databases with all same Tables,…

  sanjaydut26

  3 replies

  8 years, 10 months ago

  By: Eirikur Eiriksson

• Simple Aggregate function.

  --input code : CREATE TABLE SumPositiveNegative ( ID INT ) GO INSERT INTO SumPositiveNegati…

  Anand BI Developer

  5 replies

  8 years, 10 months ago

  By: Anand BI Developer

• Upgrading SSIS 2008 to SSDT 2016: connection provider is not registered and cannot change Platform to x86

  I'm upgrading an SSIS package from SQL Server 2008 + BIDS to SQL Server 2016 + SSDT. The environm…

  David Data

  6 replies

  8 years, 10 months ago

  By: Phil Parkin

• sql query

  I have week codes like 201551 , 201552 I want the sql query to return firstday and last day for tho…

  sanjayasamantaray

  3 replies

  8 years, 11 months ago

  By: Luis Cazares

• STDistance with SPATIAL INDEX QUERY TO SLOW :)

  hi all, i have to following query : DECLARE @latitude float=31.24326 DECLARE @longitude floa…

  sharon-472085

  7 replies

  8 years, 11 months ago

  By: The Dixie Flatline

• Exclude zero till get first nonzero value.(use cte or select)

  Hi Friends , input code : CREATE TABLE #First_nonzero ( value int ) GO INSERT INTO #First_nonze…

  Anand BI Developer

  12 replies

  8 years, 11 months ago

  By: Luis Cazares

• Procedure returns incorrect result when permissions are not granted

  I have three users: admin, user2 and user3. User admin is db_owner while user2 and user3 are regula…

  sektor81

  2 replies

  8 years, 11 months ago

  By: lottie

• Update rows using values from another table

  I have master tblJob (jobid,jobdesc,jobno) Data ----- a212, Painting a213,Plastering a214,windows a…

  fafful

  2 replies

  8 years, 11 months ago

  By: Mark Cowne

• Creating a DBA Oncall list to email to group.

  I'm looking for suggestions on creating a table with a list of DBA's and then a Job that will weekl…

  randy.moodispaugh

  8 replies

  8 years, 11 months ago

  By: Eric M Russell