SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• Need help sorting based on 2 different column DateTime

  I've this table and data as following, CreatedDate CANNOT NULL. LatestRepliedDate can NULL CREATE…

  Adelia

  3 replies

  4 years ago

  By: Zidar

• How to calculate period in T-SQL with years, months, and days. If less than ....

  I've this ( years, months, and days ) DECLARE @date datetime, @tmpdate datetime, @years int, @month…

  Adelia

  14 replies

  4 years ago

  By: Adelia

• Is it possible to migrate a solution from SSMS to SSDT?

  VS 2017, SQL Server 2016 and 2017, is it possible and or making sense to migrate a solution from SS…

  VoldemarG

  5 replies

  4 years ago

  By: Phil Parkin

• SQL Server database suspect mode

  What is suspect mode? Is the database suspect mode solved automatically? If no, Any other methods a…

  IT researcher

  1 replies

  4 years ago

  By: Ant-Green

• Generate script

  USE [DatabaseA] GO CREATE DATABASE AUDIT SPECIFICATION [DatabaseAuditSpecification-DatabaseA] FOR S…

  mtz676

  3 replies

  4 years ago

  By: Jeff Moden

• I need to combine these two query's

  I need to combine these two query's to get shipped and received for each year,month in one query. S…

  kat35601

  4 replies

  4 years ago

  By: ScottPletcher

• Service Broker limit in SQL

  As mentioned in the link below, https://www.codemag.com/article/0605061/SQL-Server-2005-Query-Notif…

  IT researcher

  2 replies

  4 years ago

  By: IT researcher

• Deadlock in SQL

  I am getting below Deadlock Error: Transaction (Process ID 1900) was deadlocked on lock resources w…

  IT researcher

  3 replies

  4 years ago

  By: Johan Bijnens

• Need help on Substring

  Hi, I've table and data as following, declare @t1 table (Id int identity(1,1), first_name varchar(2…

  Adelia

  4 replies

  4 years ago

  By: Adelia

• Seeking input on Best Method to Join on First or Last Row in a 1:M Join

  I have included the DDL to re-create the 2 tables in this examples. I can't post the actual DDL so …

  YSLGuru

  27 replies

  4 years ago

  By: ScottPletcher

• Data type convert help

  Hi Gurus, I am just trying to convert data type on a sql script. ----From this format to and conver…

  Tac11

  5 replies

  4 years ago

  By: Zidar

• Storing the datediff between a row and the previous row

  So I want to store the difference in milliseconds between rows in a column Table format ID , Label,…

  simon_s

  8 replies

  4 years ago

  By: Zidar

• WEB SERVICE DATA RECEPTION

  Hello, I am able to get data from web service with Excel VBA Code : Sub LOGIN() Dim Movie As Object…

  Vedat ÖZER

  3 replies

  4 years ago

  By: Vedat ÖZER

• Do you really write SQL queries sequentially? What is your preferred way of writ

  Just curious if there are people who really write SQL queries sequentially. For example, I often ju…

  Herzog

  3 replies

  4 years ago

  By: jonathan.crawford

• Flat file import

  I am importing a flat file from a network share which is dropped there by an application and popula…

  stevec883

  5 replies

  4 years ago

  By: stevec883