SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Setting up CDC

  I'm trying to set up CDC and I get the following error when running the following script exec sys.s…

  Kris-155042

  3 replies

  7 years, 7 months ago

  By: Phil Parkin

• OPENROWSET and "Could not find installable ISAM"

  Hi Folks, I have a problem with regards to querying an Excel Spreadsheet using not only OPENROWSET …

  kevaburg

  11 replies

  7 years, 7 months ago

  By: kevaburg

• SELECT inside job Command

  Hello, I have a job that consists of two very simple steps:Step 1:INSERT INTO MyTableSELECT * …

  lukaszpiech

  3 replies

  7 years, 7 months ago

  By: lukaszpiech

• TempDB Contetion when creating large # of temporary tables

  I went to "Eddie Wuerch presents: Performance Tuning with Waits and Queues: a Full Day of Waits" la…

  Ncage

  2 replies

  7 years, 7 months ago

  By: Ncage

• Using Bulk Insert or OPENROWSET to Import a CSV File

  Morning Guys, I have a CSV file that is not playing fair. Which I have attached (the database has b…

  alex.sqldba

  18 replies

  7 years, 7 months ago

  By: Jeff Moden

• RAISERROR in Instead of Delete Trigger.

  I'm trying to enforce business logic by preventing data modifications on certain tables other than …

  five_ten_fiftyfold

  5 replies

  7 years, 7 months ago

  By: Jason A. Long

• Grouping a list of dates into date ranges

  Hi I would like to process a list of dates to produce a list of date ranges. I've searched extensi…

  David Wilkinson-379891

  2 replies

  7 years, 7 months ago

  By: David Wilkinson-379891

• Data schema or technology change?

  I have a data structure like this: CREATE TABLE table(    ID varchar(20) not nu…

  salliven

  2 replies

  7 years, 7 months ago

  By: ScottPletcher

• Inserting data into a SQL table using powershell

  Hi AllI'm very new to Powershell and I need some help with the next step in this 'thing' I have tak…

  StillaLearner

  4 replies

  7 years, 7 months ago

  By: StillaLearner

• SSIS - Renaming a file using recordset value

  I've got a SQL task that sends values into a Foreach Loop container.  I've got a Data Flow tas…

  J M-314995

  4 replies

  7 years, 7 months ago

  By: J M-314995

• SSIS error - Invalid character value for cast specification

  I'm on day 3 of trying to address an error and Google isn't helping. While I've found forum/blog po…

  J M-314995

  3 replies

  7 years, 7 months ago

  By: J M-314995

• Avoid subselects for single condition with max()

  Hello,Personally I feel bad about to use subselects in queries, it the condition is only one simple…

  adiedler

  7 replies

  7 years, 7 months ago

  By: drew.allen

• Combine 2 numeric fields to a DATETIME field

  Hi,What's the easiest way to take 2 numeric fields and display them as a DATETIME field.  I ha…

  Isabelle2378

  8 replies

  7 years, 7 months ago

  By: Isabelle2378

• Where do I get useful datasets?

  I remember that Steve Jones posted an article, maybe 2 years ago, in SSC about getting some data to…

  Rod at work

  6 replies

  7 years, 7 months ago

  By: Rod at work

• dynamic sql with column value in where clause

  Hi All,i have a table in databaseCode     signfrompack  frompack  signtopa…

  roman.goldenberg

  6 replies

  7 years, 7 months ago

  By: Sean Lange