Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Is there a way to extract only credit card numbers from text

  i have below sample data, i try to extract valid credit card data. But i was not able to do so ,sin…

  mxy

  30 replies

  9 years ago

  By: TheSQLGuru

• Script task not able to find file on the network drive

  I have created the Integration Services package , one of the task I use is script task. This Task c…

  mandavli

  7 replies

  9 years ago

  By: mandavli

• SSIS Execution Annonymous Login Error

  I created a package in visual studio data tools , SQL connection works fine. and Package ran fine. …

  mandavli

  5 replies

  9 years ago

  By: mandavli

• Split a number in close equal number in sql

  Hello All, I am facing problem while spliting a number in closest equality. say i want to divide 11…

  snsingh

  11 replies

  9 years ago

  By: Luis Cazares

• Long running Insert stored proc

  Hi all, I was wondering if someone could help me figure out why this Insert statement is taking 9 m…

  Matt.Altman

  12 replies

  9 years ago

  By: kaj

• Splitt values from one column in two rows

  Dear NG I have following issue: 2 Tables (Zusatzfeld, Vorschuss) dbo.Zusatzfeld Bold_ID (PK) WertDa…

  csyz

  5 replies

  9 years ago

  By: drew.allen

• Report Builder - Creating an Invoice Report

  Hi, I am creating an invoice report from scratch in report builder, all the report data is correct …

  bradwilliams51

  1 replies

  9 years ago

  By: sgmunson

• How to get value based on position of special character string in a column

  I have a table like this Col1Col2 Adam1 Barbara, Catherina1 Barbara, Catherina2 Adam, Catheri…

  vikram_patro

  7 replies

  9 years ago

  By: John Mitchell-245523

• Converting date and/or time from character string.

  Hi all, I have a basic problem (I hope) whereas I'm trying to insert 4m rows from one table to anot…

  hb21l6

  10 replies

  9 years ago

  By: hb21l6

• Replace multiple row with sequence value

  Hi Folks, I am new to SQL and i have table which has column FULLNAME (Last name, firstname) & …

  pankaj 43245

  7 replies

  9 years ago

  By: Thom A

• Query runs MUCH slower when using sp_prepexec

  Hi, The following query runs in <1s when running straight: SELECT zpsinvoice1_.ClientId …

  gilbert 51520

  1 replies

  9 years ago

  By: TheSQLGuru

• Restoring DB from SQL server 2005 to SQL Server 2014

  hello there, I have noticed that when i tried to restore a sql server 2005 database to sql server 2…

  zouzou

  2 replies

  9 years ago

  By: Eirikur Eiriksson

• Zero down time database migration into production

  Hello All, We are working into database migration project. There is requirement to migration sub-se…

  getalok_akg

  5 replies

  9 years ago

  By: Eric M Russell

• Continue on error

  Hi I'm running a stored procedure that executes other stored procedure based on what's needed. My i…

  davidvarga086

  5 replies

  9 years ago

  By: whenriksen

• Output on conditional date logic

  Hi All, I am working on a query where i had to find the output based on the conditional date logi…

  adhikari707

  6 replies

  9 years ago

  By: TheSQLGuru