Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Remove first 2 digit and change phonenumber format SQL

  hi, I have a tableA in which PhoneNumber column have values like 911234567891. i want to remove the…

  hussain_ahmad73

  2 replies

  9 years, 8 months ago

  By: kreuzer

• Exclude weekend hours from datediff() function

  Hello, I want to get a total amount of hours for a date range, but I want to exclude any weekend ho…

  JP10

  2 replies

  9 years, 8 months ago

  By: Luis Cazares

• XML Parsing

  I'm stuck on what I think should be an easy solution. I am trying to read the project.params file …

  Mike01

  1 replies

  9 years, 8 months ago

  By: Eirikur Eiriksson

• Date field case statement

  Hello, I'm trying to write a case statement for a datetime field to use the logdate as the datestam…

  dk13

  1 replies

  9 years, 8 months ago

  By: Phil Parkin

• WildCard vs all Columns listing - Performance difference

  1. If you need all the rows in a table, which provides a lower execution cost? Selecting * from a p…

  Firemander

  4 replies

  9 years, 8 months ago

  By: Firemander

• sp_executesql : Trying to make sense of OUTPUT param

  Good day, I am having difficulty understanding how to make available a parameter set with dynamic T…

  j-1064772

  7 replies

  9 years, 8 months ago

  By: Sean Lange

• Limit CSV file to actual data length rather than field length

  I have a nightly job that sends out a csv file to our supplier. They then upload the data from ther…

  jcobb 20350

  7 replies

  9 years, 9 months ago

  By: jcobb 20350

• Sum of amount per field O.S.s

  Good afternoon, I have a SQL code where I can score with 1,2 and 3 the amount of time between the O…

  pinheiroinfo

  1 replies

  9 years, 9 months ago

  By: Luis Cazares

• Execute Oracle packages (control-M) using SQL Agent and Powershell

  Hello, I need to execute a bunch of Control-M Oracle jobs and packages using POWERSHELL. These jobs…

  Lord Slaagh

  6 replies

  9 years, 9 months ago

  By: Lord Slaagh

• Make delete statement with 30 equalities more efficient

  I am working on a statement that deletes records from one table where 30 fields match in value with…

  jonathanmarenus

  6 replies

  9 years, 9 months ago

  By: Eric M Russell

• Calculate time difference based on Status field

  Dear Team, My requirement is to calculate the failure time, I just want to know the difference in h…

  shagil.a.gopinath

  12 replies

  9 years, 9 months ago

  By: shagil.a.gopinath

• Video File Duration

  I have some files stored in Folder and the paths of this files stored in sql server: File path : E:…

  ikrami2000

  7 replies

  9 years, 9 months ago

  By: ikrami2000

• select * from Exceptions$

  Hi, I have inherited a sproc that writes out error messages to an excel file. It build up a dynami…

  jellybean

  4 replies

  9 years, 9 months ago

  By: jellybean

• Generate SQL Scripts - Schema and Trigger

  Hi ALL, Generating scripts for all the tables (Schema only) and triggers with single file per objec…

  Minnu

  1 replies

  9 years, 9 months ago

  By: Grant Fritchey

• Time out to run a procedure on Sql 2014

  We migrated one DB SQL 2005 to SQL 2014 with all objects. Compatibility mode was changed to 120. Th…

  javirsantos

  1 replies

  9 years, 9 months ago

  By: Grant Fritchey