Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• sp_send_dbmail : Problem with Cyrillic

  Hello, We are sending some csv file to a third party using sp_send_dbmail. This is working fine but…

  Scaramouche

  6 replies

  10 years, 3 months ago

  By: Scaramouche

• need to understand the bulk insert

  Hi all, I'm testing a procedure on a combination of different Operating Systems with different ver…

  JohnG69

  2 replies

  10 years, 3 months ago

  By: JohnG69

• BCP and Bulk insert of special characters

  Hi all, I'm testing, with SQL 2014 on the same DB, a procedure that extracts data from a table in…

  JohnG69

  6 replies

  10 years, 3 months ago

  By: JohnG69

• Getting error message in sql server

  Hi All, I need to pass the messages coming from sql server to the asp.net application so I have the…

  anjaliagarwal5

  3 replies

  10 years, 3 months ago

  By: mister.magoo

• Synchronise table on remote server via update trigger failing

  Hi all, I have the following scenario. We have a database on a 2005 box, which we n…

  andrew gothard

  3 replies

  10 years, 3 months ago

  By: Sean Lange

• SSIS - excel file manipulation

  Hello everybody, I have a task where I need to process roughly 60000 excel spreadsheets and bring t…

  vecerda

  6 replies

  10 years, 3 months ago

  By: Alvin Ramard

• T-Sql calling an .exe is working but problem with space in the path

  H everyone, I'm testing calling an .exe from T-Sql. Here is the code (whic his working btw: DECL…

  jellybean

  4 replies

  10 years, 3 months ago

  By: jellybean

• Not able to create temporal table

  HI friends, I was trying to create temporal table feature which gets introduced in SQL Server 2016 …

  kapil_kk

  3 replies

  10 years, 3 months ago

  By: Eirikur Eiriksson

• In-Memory OLTP vs. streamInsight

  New to "current data" processing and just trying to get my head around the two technologies: I unde…

  izzah100

  1 replies

  10 years, 3 months ago

  By: Orlando Colamatteo

• Find Common Link Between Two Tables in Database without Key Constraints

  Does anyone know of a tool, script, procedure, or otherwise that will solve this problem? CREATE TA…

  JimK 28184

  7 replies

  10 years, 3 months ago

  By: Matt Miller (4)

• how to split phone number based on - symbol dynamically

  Hi Sql Experts, I would like to know how to split the phone number into two columns based on - symb…

  vijay.sap1255

  1 replies

  10 years, 3 months ago

  By: pietlinden

• incrementing the number in table and then resetting the column

  Hi All, I have four columns in my table, the first one is the identity column col1 Col1 …

  anjaliagarwal5

  8 replies

  10 years, 3 months ago

  By: Jack Corbett

• How to do "Excel PERCENTRANK.INC Function" type of calculations with SQL Server Queries

  Hi I have an excel sheet that makes use of the Excel PERCENTRANK.INC Function for doing the relativ…

  tlp6327

  2 replies

  10 years, 3 months ago

  By: tlp6327

• Debugging SP Issues with Dynamic SQL

  I've been tasked with using a new stored procedure in one of our third-party provided databases. It…

  joshdbguy

  1 replies

  10 years, 3 months ago

  By: joshdbguy

• Anyway to SUM(Sum(ColA)) + (SUM(ColB)) + (SUM(ColC))) when there are NULLS in all of them?

  Basically I need to get the SUM of the sum of three columns and all three columns have nulls. To ma…

  BG101

  2 replies

  10 years, 3 months ago

  By: Eirikur Eiriksson