SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• filter values from multiple columns

    Hello All, I have a requirement to filter a set of values from two columns with out excludin…

  ssc_san

  3 replies

  6 years, 3 months ago

  By: ssc_san

• Different VARCHAR output under SQL2016

  Our application recently upgraded to SQL2016 from SQL2008.  We store text data that users have ente…

  souLTower

  2 replies

  6 years, 3 months ago

  By: Jeff Moden

• T-SQL Code Rows in single result format

  CREATE TABLE #TEMP ( ACCOUNT_NO decimal(13,0), RATE_PLAN_NO smallint, ACTIVESERVICES smallint, T…

  dallas13

  1 replies

  6 years, 3 months ago

  By: dallas13

• Does ERROR_LINE () ignore 'USE' etc.?

  Hello experts, I have tested this out a bit as follows: BEGIN TRY -- Generate a divide-by-zero err…

  webrunner

  4 replies

  6 years, 3 months ago

  By: ScottPletcher

• Track column changes

  Hello everyone. Could you please remember me how to catch the time when some table got updates in a…

  avpco

  2 replies

  6 years, 3 months ago

  By: Steve Jones - SSC Editor

• Running a query based on a field value (set field value as parameter?)?

  Greetings! In simple terms, I'm trying to take a field value from one dataset (in this case, a fiel…

  AlexMiddleton

  2 replies

  6 years, 3 months ago

  By: drew.allen

• Long name in TSQL is creating errors

  Hello, This will be a simple problem to solve for many of you! I am sure of it 😉 I have a script cr…

  jbeclapez

  10 replies

  6 years, 3 months ago

  By: Jeff Moden

• SSIS Derived Columns

  Hi I have an SSIS package which runs an insert/update   I need to check if 4 fields(Boolean) a…

  Raxso1

  3 replies

  6 years, 3 months ago

  By: Scott Coleman

• SQL PIVOT Multiple Column Pivoted on same values

  In the working sample below, I have the [Quantity] Column Successfully Pivotted for each value in t…

  planetmatt

  8 replies

  6 years, 3 months ago

  By: DesNorton

• Problem to Display Field With OPENXML

  Hello community, I am trying to Importing and Processing data from XML files into SQL Server tables…

  luissantos

  3 replies

  6 years, 3 months ago

  By: mohan.muralid

• Joining two tables using wild cards to populate a third

  Good day folks, I could use some help, please. I am trying to populate a user access table: User_na…

  Garth Zaleschuk

  2 replies

  6 years, 3 months ago

  By: ScottPletcher

• T-SQL versus Python with Pandas

  So, a new employee is promoting the idea of migrating from T-SQL to Python with Pandas.  The existi…

  rchantler

  7 replies

  6 years, 3 months ago

  By: rchantler

• full text search

  Trying to understand why when I search for numerics in full text, contains does not return, but con…

  Sailor

  5 replies

  6 years, 3 months ago

  By: David Burrows

• Select n records in table X from a field on table Y

  Hi, hope someone can help with this. I've the table gifts_to_give: Id_give      number_of_gifts    …

  luisalfonso70

  4 replies

  6 years, 3 months ago

  By: Jonathan AC Roberts

• Select n records in table X from a field on table Y table

  Hi, hope someone can help with this. I've the table gifts_to_give: Id_give      number_of_gifts    …

  luisalfonso70

  2 replies

  6 years, 4 months ago

  By: luisalfonso70