SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• Alert me Export table data to .MSG file using Stored Procedures or any plugin ?

  Is it possible with a stored procedure to write/export/output the data as .msg outlook file using e…

  kpari

  4 replies

  7 years ago

  By: frederico_fonseca

• sqlcmd sql agent job

  I have a sqlcmd script, it runs fine if I open the command line to run it. sqlcmd -S (local)  -d my…

  sqlfriend

  4 replies

  7 years ago

  By: Ricky Lively

• Convert Seconds to Minutes

  Guys, is there a way to add a new column to show HH-MM-SS ( as per below example).  In excel for ex…

  craig.jenkins

  4 replies

  7 years ago

  By: drew.allen

• Convert Seconds to Minutes

  Guys, is there a way to add a new column to show HH-MM-SS ( as per below example).  In excel for ex…

  craig.jenkins

  2 replies

  7 years ago

  By: Steve Jones - SSC Editor

• CAST FOR XML - Illegal Name Character

  I am trying to write a query that generates an html report to be emailed and one of the columns is …

  jamie_collins

  2 replies

  7 years ago

  By: jamie_collins

• Sampled Statistics Question

  Hello all I'm researching how the Query Optimizer uses statistics to come up with row count estimat…

  Sporidium

  2 replies

  7 years ago

  By: Sporidium

• Left join with same tables multiple times displaying the data into multiple rows

  my requirements is to display the single record by for all the cases associated with patient i try …

  sunitha 20026

  6 replies

  7 years ago

  By: drew.allen

• Generate sequence of stations

  The solution would be compatible with sql 2000 edition below are my tables create table dates( Date…

  ramrajan

  1 replies

  7 years ago

  By: Steve Collins

• SQL equivalent to NORM.DIST Excell function?

  Hi,   I was wondering how I would go about calculating the normal distribution for a number of…

  mharbuz

  18 replies

  7 years ago

  By: Jonathan AC Roberts

• T SQL Advance Report Month Range on the 16th - Looking For More Effect. approach

  Greetings All, I'm looking for suggestions on how to improve the script below. Requirements: From t…

  rdsb_2170

  3 replies

  7 years, 1 months ago

  By: drew.allen

• How does SQL determine which column a table level check constraint is applied to

  Here is my code:   CREATE SCHEMA Costpoint AUTHORIZATION iDrago; GO CREATE TABLE Costpoint.P…

  michael.leach2015

  26 replies

  7 years, 1 months ago

  By: Jeff Moden

• sys.system_objects, objects and all_objects

  I ran the sys.system_objects, sys.objects and sys.all_objects views in the same database.  The resu…

  michael.leach2015

  4 replies

  7 years, 1 months ago

  By: Jason A. Long

• Count between 2 dates, nested queries

  Hello, I am having an issue getting an accurate count of records between two dates, actually start …

  Matt Niem

  1 replies

  7 years, 1 months ago

  By: pietlinden

• What are the most common system tables, views, stored procedures, functions, etc

  What are the most commonly used database objects that I should become familiar with?  I'm trying to…

  michael.leach2015

  5 replies

  7 years, 1 months ago

  By: michael.leach2015

• Value to Row

  Following is Table +--------------+---------+--------------+ | Col1        | Col2  | Col3       | +…

  sanketgroup

  4 replies

  7 years, 1 months ago

  By: pietlinden