SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Parent-Child records

  Goodmorning, Ihave a table that stores parent and child record in same column (key_txt).Table has …

  legeboka

  7 replies

  8 years, 3 months ago

  By: jcelko212 32090

• Custom weekly buckets for set fiscal year

  I'm trying to create logic that can accommodate the request below. The fiscal year starts on Jan 1s…

  ldeassis09

  2 replies

  8 years, 4 months ago

  By: ldeassis09

• Best way to handle a table-based queue?

  NOTE: This is NOT a Service Broker question.  The table defined below is accessed by concurren…

  Sam-263310

  30 replies

  8 years, 4 months ago

  By: Jeff Moden

• CASE statement in WHERE clause

  I'm trying to figure out how to use a case statement in a where clause (with !=), here is an idea o…

  dan.rowe0898

  5 replies

  8 years, 4 months ago

  By: Luis Cazares

• SQL Server2016: Merge Operation with json source

  I actually have to save some data (json) from an API call in a SQL Server 2016 database. The system…

  timocordes 14433

  8 replies

  8 years, 4 months ago

  By: timocordes 14433

• ROLLUP can be used here?

  Hello:Let's say I have a table with the following sales data. drop table #valuescreate table #value…

  ganeshmuthuvelu

  1 replies

  8 years, 4 months ago

  By: Jeff Moden

• Parse Data in SQL

  I have data into field (SS)(DD)(GG) i want parse that field into 3 different column. Is Substring w…

  sks_989

  9 replies

  8 years, 4 months ago

  By: Ed Wagner

• Refreshing Table Data while other transactions quering it

  Hello all together, I'm having some problems with a stored procedure which is called every hour fro…

  malu89

  4 replies

  8 years, 4 months ago

  By: malu89

• And/OR logic in SQL

  Guys, Maybe most of your guys it is Simple question and it is simple question but I am a little bi…

  rocky_498

  7 replies

  8 years, 4 months ago

  By: Ross McMicken

• what is good career Sql Developer or sql DBA ?

  Dear All,I am currently working as a database support engineer form last 5+ years but i am little b…

  Sequel_Lover

  13 replies

  8 years, 4 months ago

  By: Grant Fritchey

• Regex end of line in issue in SSIS search replace

  Coming from a Unix background in the 80s, I've grown to rely on regular expressions to write code. …

  dzanke

  1 replies

  8 years, 4 months ago

  By: sgmunson

• Temporal Tables - "Parameterise" extended SYSTEM_TIME syntax

  Hi guys!SELECT *FROM Spine    SCROSSAPPLY(    SELECT * …

  diamondgm

  2 replies

  8 years, 4 months ago

  By: diamondgm

• How to get date from JSON in correct format?

  Say, I have the following JSON and query: declare @json nvarchar(max) ='[  {   "JDa…

  sektor81

  5 replies

  8 years, 4 months ago

  By: Jeff Moden

• sp_Send_dbmail “Failed to initialize sqlcmd library with error number -2147467259” error

  When I run the query below I get the following error message:Msg 22050, Level 16, State 1, Line 0 …

  jwilder

  2 replies

  8 years, 4 months ago

  By: Ed Wagner

• Remove non-unicode characters from a column

  hi ,Here is the function i found in google. DROP Function [dbo].[RemoveNonAlphaCharacters]GOCreate…

  komal145

  12 replies

  8 years, 4 months ago

  By: Ed Wagner