SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Merging row records where the end date of previous record is equal to start date of next record.

  Hi guys, I'm writing a script on SQL and my aim is to merge row records which have the same locatio…

  akinwandeb

  11 replies

  8 years, 12 months ago

  By: jcelko212 32090

• Unable to get proper counts using sql query

  Hi..I'm trying to fetch some details but the counts aren't coming properly,can someone pls help wit…

  hemanth329

  5 replies

  8 years, 12 months ago

  By: akinwandeb

• How to get the monday of every week

  example: today (6/20) tuesday Monday =6/19/2017last week monday : 6/12/2017Previous last week monda…

  komal145

  24 replies

  8 years, 12 months ago

  By: Thom A

• Extract String

  FilePath Structure:\\Servername\Temp\Foldername\ABCabcprices-20170621122040.txt From the given file…

  komal145

  10 replies

  8 years, 12 months ago

  By: Phil Parkin

• Missing months group by

  My data is like below currently- 7 columns below in first table.Date         &n…

  Papil

  24 replies

  8 years, 12 months ago

  By: ChrisM@Work

• calculate percentile

  I wanted to calculate the percentile Column from the given data in tsql.Here is the data , how can …

  komal145

  7 replies

  8 years, 12 months ago

  By: sgmunson

• Convert unicode escape sequence to nvarchar

  Hi all,I have string like this:DECLARE @m NVARCHAR(max)= N'\u0633\u0644\u0627\u0645'How can I conve…

  farax_x

  6 replies

  9 years ago

  By: Luis Cazares

• calculating count with different dates

  I'm trying to fetch count for two different criteria in one query i.e, need count based on open and…

  hemanth329

  5 replies

  9 years ago

  By: sgmunson

• date format needed: 06/15/2017 12:00:00 AM

  how to get it more directly than this?SELECT CONVERT(VARCHAR(25), getdate(), 101) + ' 12:00:00 AM' …

  polkadot

  5 replies

  9 years ago

  By: Vishal Vamja

• Need counts of orders by month and year

  Hello Everyone,     I'm hoping someone could help me out, so here's my scenario…

  meichmann

  11 replies

  9 years ago

  By: ScottPletcher

• Schema design , many-to-many M:N

  Basically trying to get my head around how to enforce primary / foreign key constraints on what is …

  bugg

  18 replies

  9 years ago

  By: bugg

• need counts of unique patients

  Friends,i am counting unique patients that were referred by a doctor.i simply used distinct count b…

  syam.tunuguntla

  7 replies

  9 years ago

  By: syam.tunuguntla

• sql logic issue, using OUTER APPLY, causing loss of data.

  I have a source that contains rows for applications that have experienced issues aka 'Alerts', thei…

  polkadot

  14 replies

  9 years ago

  By: Jacob Wilkins

• Parent-Child records

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

  legeboka

  7 replies

  9 years 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

  9 years ago

  By: ldeassis09