SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Count Distinct Not Working in Case Select Oracle SQL

  Hello All,I have a Oracle SQL question in which the code fails to count RESV_NAME_ID's.  It do…

  phaenggi

  5 replies

  8 years, 3 months ago

  By: sgmunson

• Upgraded to sql 2016 but I am still able to query and create tables with "text" data types.

  I thought the text data type was deprecated in sql 2016?  Anybody know why this occurs?

  JP10

  10 replies

  8 years, 3 months ago

  By: Thom A

• 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, 3 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, 3 months ago

  By: John Mitchell-245523

• Deleted

  Deleted.

  chocthree

  4 replies

  8 years, 3 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, 3 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, 3 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, 3 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, 3 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, 3 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, 3 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, 3 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, 3 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, 3 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, 3 months ago

  By: sgmunson