SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Can't convert minutes to hours after 24 hours

  I am calculating time worked based on minutes worked. A resident will work more that 24 hours. When…

  gailcole

  6 replies

  8 years, 11 months ago

  By: Jason A. Long

• [Help]Running balance

  Hi guys, I need some help on running balance. I already got the ending balance. But I want also to …

  BTG

  5 replies

  8 years, 11 months ago

  By: John Mitchell-245523

• Deleted

  Deleted.

  chocthree

  4 replies

  8 years, 11 months ago

  By: chocthree

• Please let me if this query is correct

  I have update query which I have modified to insert and update.Please let me know if this query is …

  savibp3

  2 replies

  8 years, 11 months ago

  By: Jeff Moden

• SUBSTRING and CHARINDEX query.... please help.

  Hi,I have this table, column, and string:Table = audit_log Column named = request_uExample col…

  chocthree

  34 replies

  8 years, 11 months ago

  By: Jeff Moden

• Datetime query

  Good evening Forum members,I am a total novice/beginner, so please bear with me in case I miss out …

  jp.ostrayla

  13 replies

  8 years, 11 months ago

  By: jp.ostrayla

• Default Schema not being honored.

  Hi, I've got a Windows Authenticated User logging into a Database but when they attempt to execute …

  giles.clapham

  1 replies

  8 years, 11 months ago

  By: giles.clapham

• SQL Streaks

  Hi I wish to calculate several flags for the streaks in SQL I have added the tables and the desired…

  TrooperMichelleM

  15 replies

  8 years, 11 months ago

  By: TrooperMichelleM

• Pivot shows single record field value that doesn't agree to tabualr data model value (source data) - misaligned?

  Hi All I have found something I'm a little concerned about.  Was trying to get a measure worki…

  stuartbisset

  2 replies

  8 years, 11 months ago

  By: stuartbisset

• query table with child-parent hierarchy with history

  I have different tables that work with child-parent hierarchy, this is easy with just a "parent" co…

  marc.corbeel

  7 replies

  8 years, 11 months ago

  By: marc.corbeel

• De-Identification of PHI Data

  The company that I work for deal with PHI Data and wanted to get other opinions on De-Indentifying …

  ericwenger1

  9 replies

  8 years, 11 months ago

  By: Ed Wagner

• SSIS Error When Executing Package in SSMS

  Hi,I have a system that previously ran on SQL Server 2008. However, with our latest version upgrade…

  Tiaan Clarke

  11 replies

  8 years, 11 months ago

  By: Tiaan Clarke

• PowerBI Parameterize Connection Variables in Power Query

  I'm trying to get used to Power BI Desktop, and seem to need a little boost either getting started,…

  Lowell

  1 replies

  8 years, 11 months ago

  By: sgmunson

• Running total for previous 7 values where there is a 1

  Hi I need a flag to tell me there is 7 1s in a row per site This would class as a long run Anyone …

  TrooperMichelleM

  12 replies

  8 years, 11 months ago

  By: Steve Jones - SSC Editor

• SQL: HOW to concatenate two fields using trigger,

  Hi All, I have SQL database called “S1”, and a table called “WORKORDER”, inside the table, I have t…

  m.awadallah92

  23 replies

  8 years, 11 months ago

  By: sgmunson