SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• Out of memory error when I try to export an SSIS project in SSMS to an ispac

  Hey guys, when I go into ssms and open the integration Services Catalog folder, navigate to a proje…

  dndaughtery

  4 replies

  5 years, 1 month ago

  By: Phil Parkin

• Convert in Ordering Failed

  I would like to bring the rows to column, create a pivot base on 12 months period. For example I wo…

  girl_bj

  2 replies

  5 years, 1 month ago

  By: Johan Bijnens

• View will not run from System Databases

  I'm planning an upgrade to SQL 2017 standard edition from 2008 workgroup Edition. On a new Server w…

  terry999

  4 replies

  5 years, 1 month ago

  By: Mike Good

• Separating a string

  Hi, I have a string that comes into one of my column and I need to create a column for each item. I…

  astrid 69000

  2 replies

  5 years, 1 month ago

  By: astrid 69000

• Trying to Make combinations in SQL

  I have a column in SSMS where I am looking to make different combinations. For example I have a col…

  riddhi10

  1 replies

  5 years, 2 months ago

  By: Jeff Moden

• Creating a Dimension with no Primary Key

  Hi all, I'm rebuilding some cubes in SQL Server 2017 using Visual Studio and SSAS.  The cubes were …

  daithiboy

  8 replies

  5 years, 2 months ago

  By: Phil Parkin

• Find the last occurrence of \ character and get the left of string.

  How to find the last occurrence of '\' in the following  string  and get left  part of it? DECLARE …

  sathwik.em91

  5 replies

  5 years, 2 months ago

  By: pietlinden

• Adding NOT NULL to column with existing rows causes page bloat

  Hi, I'd like to know why the page count is almost exactly doubled for a table with existing rows, h…

  timoq

  7 replies

  5 years, 2 months ago

  By: Jeff Moden

• Update table and then executeJob in loop

  I need to write a query which will first update the table, then execute the job and if the job is s…

  khushbu

  5 replies

  5 years, 2 months ago

  By: Jeffrey Williams

• Query taking more than 4 hrs. - Any recommendations/suggestions?

  One of our stored procs has been running for more than 4 hrs. and we have to finally kill it as it …

  Feivel

  11 replies

  5 years, 2 months ago

  By: Jeff Moden

• Expression expression runtime failure in SSIS

  Hi Team, I have the following expression in ssis and the value of  @[User::ExecutionId]=12dfg "##st…

  sathwik.em91

  1 replies

  5 years, 2 months ago

  By: Phil Parkin

• Get all information from within a trigger

  Hello from Portugal. I manage a database for a customer, and this database has been developed and u…

  hvse

  1 replies

  5 years, 2 months ago

  By: Thom A

• JOIN Causing Duplicate Values

  Dear Group: I am missing something and not sure what. Below, is the output and query when I do a si…

  AMCity

  5 replies

  5 years, 2 months ago

  By: AMCity

• Incorrect syntax near the keyword 'unique'.

  Hi All I am trying to create new table on sql server 2014 enterprise edition with constraint and un…

  Barcelona10

  3 replies

  5 years, 2 months ago

  By: Barcelona10

• Ignoring error and continue

  Hi, I am writing a Stored Procedure to update a table in multiple databases. In some on the databas…

  afreenraja

  25 replies

  5 years, 2 months ago

  By: Steve Collins