SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• ORALCE TO SQL SERVER MIGRATION Query performance Tuning

  Hi Experts,We are migrated Oracle to SQL Server 13.0using the Cognos Reporting When we run the the …

  sreesree.96

  11 replies

  8 years, 5 months ago

  By: AlexSQLForums

• basic SSIS 2016 import fails - ACE OLEDB driver errors

  I was trying (in vain) to get my head around SSIS the other day, and tried running the Import Wizar…

  pietlinden

  13 replies

  8 years, 5 months ago

  By: pietlinden

• SSDT with Express Edition

  Hello Community! A customer has an SQL Server Express Edition running in his company. Now I sh…

  Alex-489474

  10 replies

  8 years, 5 months ago

  By: Phil Parkin

• expensive key lookup

  have the below code from 3rd party app trying to get rid of expensive key lookup. Output from ther…

  tcronin 95651

  6 replies

  8 years, 5 months ago

  By: tcronin 95651

• How Do I go thru the DATA for post processing

  SQL newbee: How do I loop thru the return data (HRORGANIZATIONUNIT.PARENTUNIT) so I can do som…

  patrick.domond

  3 replies

  8 years, 5 months ago

  By: DesNorton

• How can I pull unique rows from table

  Hi Guys,I am new here, Below is sample code. As an example from below, I want one unique records (i…

  mikesql710

  14 replies

  8 years, 5 months ago

  By: dogramone

• MIN of NULL while pivoting

  Hi , here is the statement ; with cte as (select 1 as pk, 'xxx' as col1, 'x' as flag union allselec…

  btio_3000

  8 replies

  8 years, 5 months ago

  By: btio_3000

• create procedure of automatic backup plan with delete old backup with check condition

  Hi All, we need help regarding the backup plan strategy. we want to create a procedure where in sch…

  wasim.ahmad780

  4 replies

  8 years, 5 months ago

  By: Grant Fritchey

• Displaying correct $Amount

  Hey there folks. Was wondering if I could get a little help on this one. Based on the last query, o…

  netguykb

  8 replies

  8 years, 5 months ago

  By: Jason A. Long

• SSIS w/Identity column

  Hi, If I have to load file(s) nightly via SSIS scripts how does this impact an identity(1,1) field?…

  mcampoam

  2 replies

  8 years, 5 months ago

  By: mcampoam

• SQL80001 Error in database project but not in SSMS 2016

  I have a vs2015 database project set to Microsoft Azure SQLDatabase V12.  It builds but everyt…

  Coriolan

  2 replies

  8 years, 5 months ago

  By: Coriolan

• The infamous double quote and semicolon error for CSV-files. Not experiencing the issue in 2008R2, but in 2016.

  Hey guys, We're currently working on a customers project where we're upgrading from SQL Server 2008…

  Shatter

  22 replies

  8 years, 5 months ago

  By: frederico_fonseca

• SSIS Transaction Error

  I have a Zip File which contains .CSV files .Each .CSV will be mapped to respective Sql Server Tabl…

  greeshatu

  1 replies

  8 years, 5 months ago

  By: Thom A

• Trying to a Restrict Query by Max Value on Max Date

  I already have most of the query I am working with correct Select Clients.rid, Clients.r_fname, Cli…

  kellycarmody

  8 replies

  8 years, 5 months ago

  By: kellycarmody

• Disable Query Designer in SSMS?

  Is there a r way to disable the Query Designer in SSMS?  We want the developers to always writ…

  Clint-525719

  1 replies

  8 years, 5 months ago

  By: sgmunson