SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• CASE WHEN EXISTS UPDATE

  Hi All, I'm struggling a bit with some syntax for a CASE WHEN statement. I don't even know if it's …

  paul 69259

  4 replies

  5 years, 10 months ago

  By: paul 69259

• Convert European format values to US Format

  Hi: Is there a function or some code to convert a number that's European (4.100,00 - dots in place …

  SQL Server

  9 replies

  5 years, 10 months ago

  By: The Dixie Flatline

• How to generate a CSV listing of all objects in a database

  I have a database named "MyDB". The DB has hundreds of tables, views, functions, triggers, stored p…

  Mr. Wonderful

  4 replies

  5 years, 10 months ago

  By: Jeff Moden

• Replicating to a Temporal Table

  Hi, Just wondered if anyone has any experience of this? Our problem is that our ERP is ancient, the…

  richard.gardner87

  2 replies

  5 years, 10 months ago

  By: richard.gardner87

• Ordering of columns in GROUP BY effects sorting of result set

  In the attached two pictures, the only difference is the ordering of the columns in the GROUP BY cl…

  michael.leach2015

  4 replies

  5 years, 10 months ago

  By: Jonathan AC Roberts

• SSIS with Multiple Databases

  Ok, guys and gals, complete noob here trying to use SSIS. Here's the scenario; I have 4 databases t…

  SQLDude

  17 replies

  5 years, 10 months ago

  By: sgmunson

• Try/Catch Not Working

  I have a log table that gets an insert right at the beginning in order to show the process started.…

  Elddir

  2 replies

  5 years, 10 months ago

  By: Steve Collins

• Understanding with AND

  I have the following table which was taken from a practice problem for the Microsoft 98-364 exam. …

  michael.leach2015

  4 replies

  5 years, 10 months ago

  By: Jonathan AC Roberts

• Insert into OPENDATASOURCE with Microsoft.ACE.OLEDB.16.0 provider - failed

  Hi all, we export data into Excel file from SQL Server 2017 with a simple command (a part of a stor…

  jirpun

  4 replies

  5 years, 10 months ago

  By: jirpun

• Avoid Group by Multiple Columns - Aggregate some columns

  SELECT PR.PRID, PR.PRSName, PR.PRLName, T.PID, T.SID, T.MDate, T.RType, T.PRT, T…

  SQL Server

  4 replies

  5 years, 10 months ago

  By: David Burrows

• Log Shipping run time

  Hi All We have a situation where a provider will only send up backups via log shipping and only eve…

  nwood2009

  2 replies

  5 years, 10 months ago

  By: nwood2009

• Dynamic Partitions for Flight Data

  I am parsing 30+ meg binary files, as varbinary(max), containing parameter data from an aircraft. I…

  barclke

  2 replies

  5 years, 10 months ago

  By: Jeff Moden

• remove double quotes from file ssis- azure

  I have a csv file coming with column names and column values are in double quotes. The csv file res…

  dallas13

  15 replies

  5 years, 10 months ago

  By: dallas13

• How to update a record by checking a value in another record in same table

  I have a table: ID DATE RANGE STATUS --------------------------------------------…

  Saranabi

  6 replies

  5 years, 10 months ago

  By: drew.allen

• Alternate to temporary table in azure sql

  Hi , Currently am using temporary table to add id(identity(1,1)) value to all the records. any alte…

  Arjun

  3 replies

  5 years, 10 months ago

  By: Jeff Moden