SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• PIVOT operator is not allowed in the recursive part of a recursive common table expression

  Hello, i have a little problem.I create an  in lined table function  and with SQL Server …

  msimone

  5 replies

  5 years, 4 months ago

  By: msimone

• T sql help

  Hi experts,I got below query but how to get more columns such as Text and query plan etc other good…

  Tac11

  3 replies

  5 years, 4 months ago

  By: Grant Fritchey

• SQL HTML DBMail with multiple queries

  Having trouble getting my syntax just right - a little help appreciated.  If you scroll to the…

  Janet Barnett

  2 replies

  5 years, 4 months ago

  By: Janet Barnett

• Text data type

  Is it still supported by SS 2016?Thanks

  valeryk2000

  14 replies

  5 years, 4 months ago

  By: sgmunson

• PERCENTILE_DISC for median calculation

  Question: is PERCENTILE_DISC for median calculation works for both odd and even number of records? …

  valeryk2000

  5 replies

  5 years, 4 months ago

  By: Jeff Moden

• Find Next payment Date

  I have below table with columns date and Number of Payments and Next Payment Date column is what i …

  ramrajan

  3 replies

  5 years, 4 months ago

  By: Jeff Moden

• Select IIF((Table.Column = "" or "" or "" or ""), (Table.Column + "TEXT"), (Table.Column))

  Hey guys, I'm having a bit of trouble locating an operator that will set a condition if multiple va…

  gQuery

  3 replies

  5 years, 4 months ago

  By: gQuery

• Environment variables starting with "CM."

  We have a set of environment variables that are not created by our scripts that start out with "CM.…

  andre.quitta

  2 replies

  5 years, 4 months ago

  By: andre.quitta

• Stumped trying to shred XML data into table rows

  Hello experts, I have the following table:MyTable (MyKey  varchar(100) not null primary key,Co…

  webrunner

  21 replies

  5 years, 4 months ago

  By: Eirikur Eiriksson

• Subquery - another way to achieve the same result?

  All, I have the following DDL/DML: /****** Object: Table [dbo].[tabusrVoucher] Script Date: 13…

  as_1234

  6 replies

  5 years, 4 months ago

  By: as_1234

• data

  I have a column defined as col1  datetime2 default current_timestamp NULLDon't ask why. …

  fizzleme

  4 replies

  5 years, 4 months ago

  By: Joe Torre

• adding each row incremental

  Hello, sadly i am at my witts end with this complicated problem, and i know you guys are smart than…

  Siten0308

  7 replies

  5 years, 4 months ago

  By: autoexcrement

• Missing Data

  Hi, I need to compare tasks from template and real plans and list the actual plans names with those…

  PSB

  1 replies

  5 years, 4 months ago

  By: fahey.jonathan

• Request code review for UDF: ContainsControlChar and CleanString

  Hi, I have a lot of dirty data in my upstream data sources.  I've written two UDFs to assist i…

  Scott In Sydney

  15 replies

  5 years, 4 months ago

  By: Scott In Sydney

• SQL Query Optimisation/Rewriting Ideas/Cursor Replacement

  Need some advice on improving/rewriting the below query. In summary, I have got a table which I am …

  vivkris25

  3 replies

  5 years, 4 months ago

  By: vivkris25