SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• How to map out multi-level Supervisor/Employee relationship

  No doubt this has already been answered and probably detailed many ways so I just need to know the …

  YSLGuru

  1 replies

  4 years, 11 months ago

  By: Mark Cowne

• How to use HASHBYTES function in sql server for multiple columns

  I have a requirement wherein I have to create hashvalue which consist of all columns of a table. Wi…

  vikasjagadale8

  30 replies

  4 years, 12 months ago

  By: TRACEY-320982

• COUNT(ID COLUMN) not using Clustered Index

  Hello SSC, Ok, so I have a table that has a 1 Clustered and 1 Non-Clustered Index. PK Clustered Ind…

  Lord Slaagh

  8 replies

  4 years, 12 months ago

  By: Lord Slaagh

• How do I JOIN these records?

  Hi, possible to give me a tip on how do I join these 2 tables? TABLE_A record must have the first …

  ARPRINCE

  6 replies

  4 years, 12 months ago

  By: ARPRINCE

• Rounding to 0

  How do I preserve the value (and not result to 0). In the below calculation, how do I preserve the …

  SQL_Surfer

  2 replies

  5 years ago

  By: Mike01

• DATEDIFF() for times over a day long

  I've got a T-SQL statement which I use for comparing the duration of an SSIS package against previo…

  Pete Bishop

  22 replies

  5 years ago

  By: Jeff Moden

• 'R' script to remove non-matching characters

  I'm trying to produce an 'R' script to remove non-matching characters from the input: CREATE TABLE …

  Pete Bishop

  1 replies

  5 years ago

  By: Pete Bishop

• Upgraded to SQL Server 2016. Can I change compatibility levels of the master db?

  Hi, I upgraded a few SQL Server instances from 2014 to 2016 a while back and I've recently noticed …

  Mike Scalise

  2 replies

  5 years ago

  By: Mike Scalise

• Validating Loaded Data in an SSIS Package

  Hi Forum, I want to prove that all the records I've Extracted from a source into an SSIS Package ar…

  Oscar_Boots

  5 replies

  5 years ago

  By: Phil Parkin

• Len

  Hi, current table result is below. select FirstName,LastName,DOB,ID from emptable. Example sample r…

  adisql

  4 replies

  5 years ago

  By: The Dixie Flatline

• SSIS - Filter rows *and* add columns in script component

  Is it possible to have a transformation script component which filters rows as well as adding new o…

  Pete Bishop

  1 replies

  5 years ago

  By: Phil Parkin

• FreeTDS connection error

  Hello experts, Does anyone know what might cause this issue? The host my_linux_server has a FreeTDS…

  webrunner

  1 replies

  5 years ago

  By: webrunner

• Len

  Hi, current table result is below. select FirstName,LastName,ID from emptable. FirstName LastName  …

  adisql

  9 replies

  5 years ago

  By: adisql

• Does SQL 2016 allow for column encryption?

  I have a feeling I've asked this question before, but I can't find my having asked it previously. I…

  Rod at work

  2 replies

  5 years ago

  By: Roebuck247

• Copy data from Source Sql Server to another destination Sql Server DB Table

  Hi, I want to copy from source sql server table to destination sql server table. Requirement: Sourc…

  RCRock

  6 replies

  5 years ago

  By: Jonathan AC Roberts