SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• Get first date and last date of the current month base on Work Week

  Hello all, Thanks in advance for any assistance you can give me.  What I am trying to get is t…

  James Bosco

  12 replies

  6 years, 5 months ago

  By: Jeff Moden

• Issue with accessing and modifying unbound controllers in subform details

  In the figure above I have highlighted in red as an unbound controller and green as bounded control…

  xboxown

  1 replies

  6 years, 5 months ago

  By: sgmunson

• Issue with write conflict in access and SQL

  Hey guys, I have this annoying with Microsoft Access and Microsoft SQL when it comes to constantly …

  xboxown

  5 replies

  6 years, 5 months ago

  By: sgmunson

• Seperate values in one column

  Hi I am new to sql server I want to seperate one column which has multiple data seperated by column…

  bharat.radhakrishnen

  6 replies

  6 years, 5 months ago

  By: sgmunson

• SUM(CASE(CASE(SUM()))) ?

  Hi, not sure if this is possible but i am trying to build a query that can gives me a total for a g…

  ste.cox

  8 replies

  6 years, 5 months ago

  By: sgmunson

• calculate dates

  I need to compare dates example declare @date date = '6/18/2018' I need to compare @date should be …

  komal145

  2 replies

  6 years, 5 months ago

  By: below86

• Error Processing Cube from SSIS package run as a SQL Job

  Hi,I am trying to upgrade a SQL server with Analysis Services to SQL 2017 cu5, 14.0.3023.8, (I trie…

  Brian Shaw

  27 replies

  6 years, 5 months ago

  By: ListerD

• Conversion failed when converting the nvarchar value '/' to data type int.

  I have SQL query as following : SELECT   TOP (99.9999999) PERCENT CAST(CAST(LEFT(Special…

  ahmed_elbarbary.2010

  5 replies

  6 years, 5 months ago

  By: Luis Cazares

• Selecting some text in the editor is difficult

  Hello,I just started using SQL2017 with SQL Server Management Studio v17.7. When I write queries in…

  Raymond van Laake

  3 replies

  6 years, 5 months ago

  By: Raymond van Laake

• Foreign Key Constraints

  Hello all,I am using SQL Server Express 2017, and I have a table with two foreign keys I am attempt…

  mjdemaris

  4 replies

  6 years, 5 months ago

  By: Joe Torre

• use UPDATE with OPENQUERY on mutiple columns

  I'm trying to update a table in mysql from SQL SERVER: UPDATE OPENQUERY(SRVLINK,'Select COLA, COLB,…

  kaplan.dani

  1 replies

  6 years, 5 months ago

  By: sgmunson

• Count of values in column

  Hi Friends, I'm a newbie. But I was wondering if i had an employee table joined with a departm…

  Data Rat

  8 replies

  6 years, 5 months ago

  By: Ed Wagner

• SQL Server on Azure: “Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.”

  I'm running a script locally in Powershell that loops bcp, copying hundreds of excel files to a dat…

  jared429

  1 replies

  6 years, 5 months ago

  By: Sue_H

• store a query instead of repeating it

  If I have a complicated SQL query with joins and unions and with statement, and I would like to use…

  sqlfriend

  7 replies

  6 years, 5 months ago

  By: Joe Torre

• Query a Field and Ignore Commas and Periods in DB Value

  Hi, I'm not sure how to query a field that contains commas and periods with like. Value in db: "Acm…

  mcromarty

  7 replies

  6 years, 5 months ago

  By: Jeff Moden