SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• T-SQL Code works fine on SQL server 2008R2 and errors on SQL 2014

  The below T-SQL Code works good on SQL server 2008R2 server and it fails on SQL 2014 with below err…

  anzz

  3 replies

  9 years, 10 months ago

  By: Eirikur Eiriksson

• Date DImension Query

  Hi guys, I'm working on modifying the fiscal date script from here. I'm trying to figure out how to…

  o103452@rtrtr.com

  11 replies

  9 years, 10 months ago

  By: drew.allen

• Dynamically growing/shrinking code in an SP

  Hi, I have a requirement where a portion of code either grows or shrinks depending on situation, ev…

  etl2016

  7 replies

  9 years, 10 months ago

  By: Eirikur Eiriksson

• Sessions and members with data gaps and pivoting

  Hi all, I have session data with members belonging to sessions. Members can belong to one, some or …

  kangarolf

  4 replies

  9 years, 10 months ago

  By: J Livingston SQL

• Table Partitioning: Partition Function (RANGE RIGHT or RANGE LEFT)

  This is for a discussion I have been unable to locate from out here. It has been a few years since …

  SQL_ME_RICH

  5 replies

  9 years, 10 months ago

  By: SQL_ME_RICH

• Simple Query Running long in PROD

  Hi I am trying to run the simple select query to retrieve records from my PROD server. Till last F…

  vijay_uitrgpv

  3 replies

  9 years, 10 months ago

  By: TheSQLGuru

• Header and Detail Data

  We have a Header table and a Detail Line table, which join on the Primary Key . However, we are try…

  bpowers

  44 replies

  9 years, 10 months ago

  By: Orlando Colamatteo

• Set output value to variable using 'execute' with a linked server in t-sql?

  Hi, I wonder if anyone can help? I am trying to set an output value to variable using 'execute' wit…

  lassell

  1 replies

  9 years, 10 months ago

  By: lassell

• T-SQL for Sync SQL Agent Jobs between Instances

  Hi everyone!... Anyone have a T-SQL for sync Jobs and his steps and schedules between instances... …

  juanc.aguirre

  4 replies

  9 years, 10 months ago

  By: Lowell

• How to generate new Int ID for multiple columns

  I am working on staging data for loading a tabular model and I have to merge transactions and the p…

  Phillip.Putzback

  11 replies

  9 years, 10 months ago

  By: Phillip.Putzback

• The problem with transactional replication using articles filters and delete operations

  I have a problem with my transactional replication when I use articles filters and delete operation…

  vaidas13bs

  1 replies

  9 years, 10 months ago

  By: vaidas13bs

• TSQL to create multiple lines in result set

  I have a need to create 49 points for a Viz. What i'm needed is this t = a value between -6 and 6 …

  Stephen crocker

  2 replies

  9 years, 10 months ago

  By: Alan Burstein

• Split single column into multiple sql

  Hello, i have one column having data like 777777777777777777 0 0 …

  Nallya

  4 replies

  9 years, 10 months ago

  By: Luis Cazares

• Dynamic incremental load in SSIS

  Hi All, I have an urgent requirement in SSIS Package , I want to get the table list from a…

  mitra.itha

  11 replies

  9 years, 10 months ago

  By: mitra.itha

• Empty string field becomes a single space in text file after BCP

  SET @sqlCommand = 'BCP [database].[dbo].[stored_proc] queryout ' + @filePath + @fileName + ' -c …

  yaakov.kravitz

  2 replies

  9 years, 10 months ago

  By: Sergiy