SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Odd behavior with views

  Hi all, My coworker recently told me about an odd situation he encountered with views. He found tha…

  Mike Scalise

  5 replies

  7 years, 11 months ago

  By: Mike Scalise

• Does Anyone know how you can copy values from a previous row into a null column in SSIS

  I have been tasked with creating an upload of data from a report usingSSIS.Loading the data is fine…

  Andrew.Murdoch

  20 replies

  7 years, 11 months ago

  By: Jeff Moden

• INSERT/SELECT Adds then Removes Rows

  First, my code is on a separated network so I cannot copy it to here.I've been running this same Pe…

  ncforums

  3 replies

  7 years, 11 months ago

  By: Phil Parkin

• Store each row value in a separate variable in one statement

  I am having trouble working out how get each separate ProcessLimit into its own variable without 4 …

  markavis.mail

  3 replies

  7 years, 11 months ago

  By: sgmunson

• Add line break to string

  Hello everyone, I hope this is the correct spot to post this question. I have a string that is sto…

  juwinn

  5 replies

  7 years, 11 months ago

  By: sgmunson

• Formula Calculation embedded in table?

  Hi Experts, I have the following tables T1 and T2 linked by ID. ID 99, 100 & 101 has a formula …

  Naveen J V

  3 replies

  7 years, 11 months ago

  By: sgmunson

• Fastest way to look for a word from a string matching a list of words in a lookup table

  Hi AllI have a table currently holding 5.2 mil rows with a total of 50 + columns in about 10 of the…

  Northern Monkey

  2 replies

  7 years, 11 months ago

  By: J Livingston SQL

• format datetime to varchar

  Hello,I would like to convert a datetime column with values such as '2017-09-19 08:01:55.780' to&nb…

  arkiboys

  2 replies

  7 years, 11 months ago

  By: Thom A

• How OVER clause works ?

  Hi All, Today, I came across tsql code which is been used in our environment (Sql 2014). Its an en…

  vsamantha35

  3 replies

  7 years, 11 months ago

  By: vsamantha35

• find missing months

  please help in finding missing months from the last one year- 2016-11 till 2017-11.My data looks li…

  Papil

  4 replies

  7 years, 11 months ago

  By: Papil

• Create Table with appropriate Data Types based on flat file

  I have been asked to help another team load some data into a new SQL Database to help them analyze …

  andrew.jones 69458

  6 replies

  7 years, 11 months ago

  By: andrew.jones 69458

• Merge from Production table to UAT table (which has keys).

  I have a daily exchange rate table , which updates the exchange rates daily but this process update…

  komal145

  1 replies

  7 years, 11 months ago

  By: Phil Parkin

• Multiple COUNTs() returned in one query.

  Hi guys, I've been tasked with creating a job which will charged a fee for debits, but if there is …

  Derek Paul

  3 replies

  7 years, 11 months ago

  By: Eirikur Eiriksson

• Statistics Update is causing SP to crash

  Hello, we have a procedure that runs for long periods via a SQL Agent job.We have an issue when the…

  markavis.mail

  3 replies

  7 years, 11 months ago

  By: sgmunson

• Listing records based on condition

  I'm trying to find when a person failed a test during a given time period (cycle) and the results, …

  jkw

  5 replies

  7 years, 11 months ago

  By: jkw