Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• How to make a list of "OR" for query of unique IDs

  Hi, I am probably considered a beginner at SQL compared to most of you! Here is code that I have th…

  dmboyce1

  5 replies

  9 years, 10 months ago

  By: Phil Parkin

• SSIS move file task is erroring out.

  All, I've got a package that downloads Excel files from an FTP site then loads them to a table in S…

  craig.bobchin

  4 replies

  9 years, 10 months ago

  By: craig.bobchin

• Optimizing a table created at runtime

  Hi, I am optimizing the script below and have a question. As you will see they are creating the tab…

  krypto69

  6 replies

  9 years, 10 months ago

  By: krypto69

• Returning all rows from multiple partitions of a partitioned table

  I have a table that is partitioned into multiple filegroups and spread out over multiple tables b y…

  mqbk

  11 replies

  9 years, 10 months ago

  By: MadAdmin

• Problem Pivot : with multi fix columns

  Hi I have this table CREATE TABLE [dbo].[GroupS]( [Id] [int] NULL, [Title] [nvarchar](255) NULL,…

  MotivateMan1394

  5 replies

  9 years, 10 months ago

  By: MadAdmin

• Trouble with SUM

  Hi there, I have this query: SELECT filteredfs_franchise.fs_franchisenumber, dbo.Filteredfs_carvelg…

  vecerda

  6 replies

  9 years, 10 months ago

  By: Alan Burstein

• How to Get SQL to Change Date is Time Goes Past Midnight.

  Hi, How do I get the date to change if the time someone works goes past midnight. i.e if someone wo…

  hazeleyre_23

  7 replies

  9 years, 10 months ago

  By: Steve Jones - SSC Editor

• Post deploy script in VS 2013 Database project

  I have a couple of merge scripts that are run post deployment, one of which sets up a lookup table …

  Paul Giles-Randall

  3 replies

  9 years, 10 months ago

  By: Paul Giles-Randall

• Strange SSIS problem - could use a little help

  OK - I have a pretty straight forward SSIS package. Our environment is SQL 2014 Standard SP1 on bo…

  Brad Feaker-195979

  5 replies

  9 years, 10 months ago

  By: Aditya Daruka

• bizarre behaviour SSRS

  Hi, I have a really strange situation in SSRS 2014 whereby a single column group is repeating acros…

  DuncEduardo

  7 replies

  9 years, 10 months ago

  By: DuncEduardo

• Interesting non-error using WHERE with NOT IN

  I came across an interesting non-error in SQL Server 2014 EE with a where condition that uses a not…

  anthonymendozajr

  5 replies

  9 years, 10 months ago

  By: anthonymendozajr

• How to write Query that one filed have 2 Values

  This is My Table Create table T1 (GoodId int,LocNum int) Insert into T1(GoodId,LocNum) Values (1,5…

  MotivateMan1394

  6 replies

  9 years, 10 months ago

  By: serg-52

• String manipulation : Need to change the first and last letters to upper case

  I need to change the first and last letter to upper case . The below piece of the code works , just…

  himanshu.sinha

  2 replies

  9 years, 10 months ago

  By: serg-52

• Gale-Shapley algorithm

  Hi, I am looking around online and have seen implementations of the gale-shapley algorithm in C++, …

  vietdragon82

  1 replies

  9 years, 10 months ago

  By: Alan Burstein

• Incorrect syntax near 'masked'

  Hi friends, As currently we dont have any category to discuss SQL Server 2016 problems so I am post…

  kapil_kk

  1 replies

  9 years, 10 months ago

  By: kapil_kk