SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• Release source file after operation is done (LinkedServer)

  Hi. I´m somwhat new to SQL. I haven´t been able to find a solution, maybe its a trivial question, b…

  Ronny_1

  1 replies

  6 years ago

  By: Ronny_1

• SQL job runs fine alone but fails when added to larger job

  I have a step in a large SQL Server job that has been running fine. Recently, it's now erroring out…

  Janet Barnett

  2 replies

  6 years ago

  By: Lowell

• String Manupulation

  Hello Everyone, How can i read the first 5 characters in a string by excluding spaces. Eg:  AAA LOG…

  kumar

  5 replies

  6 years ago

  By: sathwik.em91

• SSIS Excel Import w/ Variable File and SheetNames

  Using SSIS VS 2017 to import data from Excel to SQL.  I have set up a For Each Loop container with …

  Anonymous

  3 replies

  6 years ago

  By: Phil Parkin

• Generate a string format based on fixed length and numeric units on increment

  I had to write a SP to generate a string with the combination of Country(7 chars)+Province(1 char) …

  bplvid

  8 replies

  6 years ago

  By: jcelko212 32090

• 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

  6 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

  6 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

  6 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

  6 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

  6 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

  6 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

  6 years, 1 month 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

  6 years, 1 month 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

  6 years, 1 month 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

  6 years, 1 month ago

  By: drew.allen