SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• 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

  6 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

  6 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

  6 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

  6 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

  6 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

  6 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

  6 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

  6 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

  6 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

  6 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

  6 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

  6 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

  6 years, 5 months ago

  By: Jeff Moden

• Creating Columns from multiple values in rows

  One of the tables I am working with contains a column with string values like this: 3,4,6,9,12,241,…

  sqlstar2011

  6 replies

  6 years, 5 months ago

  By: sqlstar2011

• SP with dynamic sql parameters

  Hello, I have one SP CREATE PROCEDURE [dbo].[usp_test] @year char(4), @criteria varchar(50) = NUL…

  dallas13

  18 replies

  6 years, 5 months ago

  By: drew.allen