SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• 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, 10 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, 10 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, 10 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, 10 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, 10 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, 10 months ago

  By: Eric M Russell

• BCP Copy

  I am copying contents of 2 csv files to at third one. It works with this command: exec master..xp_…

  vujicikm

  2 replies

  8 years, 10 months ago

  By: Taranjit Singh-373811

• gethttp/open json not returning value

  Afternoon, Thanks for your help in advance. When I run the following nothing is returned, not just …

  olibbhq

  1 replies

  8 years, 10 months ago

  By: olibbhq

• Database Documentation

  Not quite sure this is the right place for this, forgive me if I have it wrong. :blush: To rapidly…

  HappyGeek

  12 replies

  8 years, 10 months ago

  By: higgim

• how to find number of days between successive visists?

  PatientId PatientNO Initials---- Patients Table 1 1 ABC 2 3 …

  SQL-Learner

  11 replies

  8 years, 10 months ago

  By: drew.allen