Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Still driving me nuts: selecting several timelines from several lines from multibale tables

  So, I called in your help a week ago on this post: https://www.sqlservercentral.com/Forums/186…

  Boemstein

  4 replies

  8 years, 9 months ago

  By: Jason A. Long

• Split out a field of comma separated values based on a unique code in the same row.

  Hi I have a comma separated field containing numerous 2 digit numbers that I would like splitting o…

  Trawler

  10 replies

  8 years, 9 months ago

  By: Trawler

• Remove duplicates records and add unique key to the column

  I have to  delete  duplicates records  which having  same date and same ID with…

  Bharat21

  2 replies

  8 years, 9 months ago

  By: Bharat21

• Slow insert

  I have insert...select query. Select part is fairly fast, it joins 2 tables and has ...where not e…

  SQL Guy 1

  9 replies

  8 years, 9 months ago

  By: TheSQLGuru

• Delete statement

  Can someone help me in writing this query. Doing some silly mistake but not able to recognize. for …

  khushbu

  3 replies

  8 years, 9 months ago

  By: TheSQLGuru

• Help SQL query, count and group by day on multiple fields

  Hi All,I have a table with records, which are determined by transaction_type.I would therefore like…

  shani19831

  10 replies

  8 years, 9 months ago

  By: sgmunson

• Images With Full-Text Search

  Hello,I want to know how i  can search a text  that is inside an image, but not have a pd…

  fernando2197

  2 replies

  8 years, 9 months ago

  By: Sean Lange

• Estimated v Actual rows in query plan

  Hi Guys, This is general question initially without any DDL or query plan (my company won't allow i…

  Jim-S

  14 replies

  8 years, 9 months ago

  By: Jim-S

• SSIS 2014 edits to DTSX file do not seem to take effect

  I have a DTSX file that contains a query that calls an SQL CLR function.  That function change…

  Byron

  7 replies

  8 years, 9 months ago

  By: sgmunson

• SSIS - soliciting suggestions on design patterns for handling dependencies

  Once upon a time, 10+ years ago, someone from my organization decided they were going to use SSIS t…

  The Dutchman

  3 replies

  8 years, 9 months ago

  By: The Dutchman

• SQL 2008R2 to SQL 2014 Upgrade

  Hi guys,I am planning to upgrade my SQL Server 2008r2 to SQL 2014. As a developer I want to know ho…

  sqlenthu 89358

  8 replies

  8 years, 9 months ago

  By: sqlenthu 89358

• SQL Query Help

  Hey all, I need a little help with a SQL query.  I have a table that has a uniqueidentifier co…

  woody_rd

  14 replies

  8 years, 9 months ago

  By: drew.allen

• SQL Server | Architecture design -

  Hi Experts, I have couple of basic queries regarding the way SQL Server is designed/works:1) Schema…

  ranitb

  19 replies

  8 years, 9 months ago

  By: Chris Harshman

• set xact_abort on required if entire proc in explicit transaction?

  I have an entire procedure wrapped in an try/catch statement.  commit tran is placed at the en…

  isaac_654135

  5 replies

  8 years, 9 months ago

  By: Gail Shaw

• INSERT into OPENQUERY with matching Sequence Objects

  OK SQL Gurus, riddle me this.  I have two SQL Servers, ServerA and ServerB.  ServerB has …

  T Tschan

  5 replies

  8 years, 9 months ago

  By: sgmunson