SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• Json import and unicode?

  Hey I am import json data into a MSSQL database, running on linux.In the json file, the special cha…

  tommy 41661

  2 replies

  5 years, 5 months ago

  By: tommy 41661

• VS 2017 SSIS ODBC Source no longer showing [ODBC Source].[SqlCommand] when viewing DFT properties

  We recently had to rebuild one of our sql servers with ssis due to an issue with upgrading SSDT to …

  jfreier

  2 replies

  5 years, 5 months ago

  By: jfreier

• how to get rows from two datetime fields with hours on morning time.

  I have this problem How can I get rows in this example. We are looking for crimes in our database o…

  marcelo salgado

  12 replies

  5 years, 5 months ago

  By: Jeff Moden

• Combine two tables based on FY year

  My sample data looks like below queries . mytable1 has data for all products for all quarters curre…

  Papil

  10 replies

  5 years, 5 months ago

  By: Lynn Pettis

• Using SUM() In CASE Statement / Best Practices

  All, I'm working on building a semantic layer within an ETL database so as to improve our end to en…

  mitzyturbo

  5 replies

  5 years, 5 months ago

  By: mitzyturbo

• Data Tools

  HelloWhich versions of data tools / visual studio can I install side by side to support SSIS p…

  kath taylor

  1 replies

  5 years, 5 months ago

  By: Thom A

• conversion of a varchar data type to a datetime data type resulted in an out-of-range value

  So my query looks like this below. When i put @month as 11 it works fine and gives 2019-01. but it …

  Papil

  13 replies

  5 years, 5 months ago

  By: Papil

• get qtr,month and year from start date

  I have start date column. how can i get rest of 4 columns of attached file. financial year begins f…

  Papil

  11 replies

  5 years, 5 months ago

  By: Papil

• Speed of SSIS execution much slower in package execution as step( "Execute Package Tasks") compare to single package execution

  Hi, I am creating  data migration scenario for SQL 2017 I need to load  160 GB …

  ebooklub

  8 replies

  5 years, 5 months ago

  By: ebooklub

• SQL Query help!

  Folks: I need help with a query. I have a column in which we store the stored procedures executed h…

  sqldba20

  2 replies

  5 years, 5 months ago

  By: Eirikur Eiriksson

• SSIS Lookup to OLE with error no column information was returned

  I have a data flow (in SSIS 2016) and in the Lookup I am matching on the first three columns. Howev…

  dwilliscp

  6 replies

  5 years, 5 months ago

  By: tim.ffitch 25252

• Sql 2017 upgrade from 2014 with sequential numbers

  Hi  One of my users ran the following code set nocount on ;with  R0 as(select 1 as …

  ebeng

  20 replies

  5 years, 5 months ago

  By: ebeng

• Data modelling: how do you handle child records when doing a soft-delete?

  I'm facing an dilemma in something similar to a sales database with parent-child relationships betw…

  Andrew P

  10 replies

  5 years, 5 months ago

  By: Sergiy

• How to build an app with GUI that works with SQL Server?

  I have to create a project which should have a GUI because people who gonna use it don't know TSQL.…

  elea.grig

  56 replies

  5 years, 5 months ago

  By: andycadley

• Computed Column Specification formula

  Hi,hopefully I'm @ the right place to ask; how and can I use the Computed Column Specification form…

  w.bartelink

  9 replies

  5 years, 5 months ago

  By: Jeff Moden