SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Rownumber()

  I need to get a rolling count only of rows matching a particular criteria and to use the result in …

  GED.Burnett 71559

  9 replies

  6 years ago

  By: jcelko212 32090

• Help with query

  Hi, I have the following table: CREATE TABLE [dbo].[test]( [ID] [varchar](10) NOT NULL, [RN] [dec…

  Mike Scalise

  3 replies

  6 years ago

  By: MVDBA (Mike Vessey)

• wierd type conversion error

  Hi I've been tracking through some code that has a type conversion error from varchar to uniqueiden…

  MVDBA (Mike Vessey)

  5 replies

  6 years ago

  By: MVDBA (Mike Vessey)

• Update query with historic accumulative SUM in fields by date range

  Hello there, I am trying to complete a table I have with an accumulated value but not sure how to m…

  MatiOli

  11 replies

  6 years ago

  By: Jeff Moden

• SSIS Package Crashing

  Dear All, I am migrating SSIS from 2008 to 2016. One of the SSIS package is very large, with about …

  GonnaCatchIT

  7 replies

  6 years ago

  By: tim.ffitch 25252

• Changing from drop table to truncate

  Thanks for the help and assistance.  I am trying to make some changes but my error is that these ca…

  DHeath

  4 replies

  6 years ago

  By: DHeath

• Linked Server from SQL 2016 to SQL 2005

  Hello, I have created this new linked server on SQL 2016 to connect to SQL 2005 and the openQuery s…

  datsun

  2 replies

  6 years ago

  By: datsun

• joining 4 tables in adventureworks2016

  Hi can anyone please help me to know that what is the issue with this query   select Person.Pe…

  sql_DB_exprt

  5 replies

  6 years ago

  By: sql_DB_exprt

• Using Timestamp Column To Determine Date/Time Of Change

  I understand that the timestamp type is not for storing a date or time but a number and that the nu…

  YSLGuru

  5 replies

  6 years ago

  By: YSLGuru

• ADO faster than OLE!?

  I am running an SSIS job extracting data from an Oracle database and loading it into a SQL 2016 dat…

  Jeremy

  3 replies

  6 years ago

  By: Jeremy

• SSIS SQL 2016 failing to import date value into a timestamp column!

  Hello, Why am I getting this error? I have a  CSV file with a date field in yyyy-mm-dd hh:mm:ss Imp…

  datsun

  14 replies

  6 years ago

  By: Jeff Moden

• Could there be some sort of permissions issues with EF and INFORMATION_SCHEMA?

  I'm working on a new application that runs against a SQL Server 2016 SP2 database. We're using Enti…

  Rod at work

  4 replies

  6 years ago

  By: Rod at work

• MERGE - Comparing NULL values for Update

  Hi guys Came across an odd one today. I'm running a MERGE to do an INSERT and UPDATE between a sour…

  mitzyturbo

  3 replies

  6 years ago

  By: ScottPletcher

• Help with Query Results and Collation

  I should know the answer to these questions, but I'm having trouble with a couple of my queries. Fi…

  Mike Scalise

  6 replies

  6 years ago

  By: Steve Collins

• Create A Stored Proc Across All DBs Where That DB Exists in An Avail Group

  I have written some dynamic SQL that executes a stored procedure in all databases it exists in. I n…

  gs1975

  3 replies

  6 years ago

  By: Steve Jones - SSC Editor