SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Practice SQL querying with dates and aggregations

  Hello SSC! I am looking for some practice with advanced SQL querying. I have a face to face intervi…

  Lord Slaagh

  35 replies

  4 years, 9 months ago

  By: Lynn Pettis

• how togetparentchildstring in sql server

  hi i have one doubt in sql server. how to convert json format using multiple tables. emp_addr: empi…

  asrinu13

  2 replies

  4 years, 9 months ago

  By: Steve Collins

• IF IF IF versus IF Condition 1 and condition 2 and condition X

  I really hope this isn't a dumb question. Is there a reason other then style or preference as to wh…

  YSLGuru

  33 replies

  4 years, 9 months ago

  By: ScottPletcher

• VBA Equivalent for DoCMD.TransferText

  Please note:  I know this isn't a .Net forum, but just curious if there is something I call that ex…

  AMCity

  2 replies

  4 years, 9 months ago

  By: Jeff Moden

• SSRS Evaluating Rows using an expression

  I have a SSRS report that for a column, I need to calc the time different between the DateTime valu…

  csalerno

  7 replies

  4 years, 9 months ago

  By: csalerno

• sys.dm_db_index_physical_stats returning wrong object_ID in MSDB database

  I'm running an index maintenance script on the MSDB database that loops through a table of indexes …

  jackaroe

  3 replies

  4 years, 10 months ago

  By: jackaroe

• Ugly code fix

  CASE WHEN Phone IS NOT NULL OR MobilPhone IS NOT NULL THEN CONCAT(CONCAT(LEFT(COALESCE(Phone,MobilP…

  jharvey6 76850

  5 replies

  4 years, 10 months ago

  By: richardm-1037631

• Is Index Fragmentation Still Relevant in a Cloud Base/Virtual SQL Server Setup

  We moved our mission critical DB to the software vendors private cloud. This meant we (my company) …

  YSLGuru

  5 replies

  4 years, 10 months ago

  By: ScottPletcher

• Wildcard % % Performance

  Hi I have a legacy application that uses a like %searchvalue% condition. I have looked at using a c…

  alic

  2 replies

  4 years, 10 months ago

  By: Jeff Moden

• Executing Dynamic Sql in function

  Hi i am migrating a sybase function to sql server and have come up against a biggie. In sybase, the…

  FredNerks

  7 replies

  4 years, 10 months ago

  By: FredNerks

• Executing another stored proc inside of a stored proc

  Hello, Wondering if anyone has any insight into how I can do this:  I have a lengthy stored proc wh…

  tacy.highland

  15 replies

  4 years, 10 months ago

  By: tacy.highland

• Dividing data equally in 4 sessions

  Hi All I have a table which contains the transactions done by cards. Below is the table structure a…

  S_Kumar_S

  9 replies

  4 years, 10 months ago

  By: GaryV

• product version result

  SELECT SERVERPROPERTY ('ProductVersion') Output: 13.0.4001.0 What does each of those numbers mean.I…

  mtz676

  3 replies

  4 years, 10 months ago

  By: Jonathan AC Roberts

• table variable

  deleted code resolved issue   This topic was modified 4 years, 10 months ago by mtz676.

  mtz676

  1 replies

  4 years, 10 months ago

  By: Grant Fritchey

• Unique value constraint among active records

  I have a lookup table that implements a system-generated Id for DRI purposes.  The lookup table has…

  CanuckBuck

  12 replies

  4 years, 10 months ago

  By: Sergiy