SQL Server 2017 - Development

• Topics

  Started by

  Posts

  Last post

• How to Mark a case as a 're-open' if the same Case Id occurred prior to the one being looked at

  I have been trying a few various methods to see if I can get this to work, but I haven't had any lu…

  matter2003

  10 replies

  7 years, 1 months ago

  By: ThatDataGuy

• Creating a non-unique index

  If you don't specify Unique, then by default a non-unique index is created.  But suppose I wan…

  michael.leach2015

  2 replies

  7 years, 1 months ago

  By: Jeff Moden

• Select Sum Of Values

  Hello Everyone,I am working with a poorly designed database that we are not allowed to change. I ju…

  AndrewSQLDBA

  3 replies

  7 years, 1 months ago

  By: Eirikur Eiriksson

• Bizarre behavior around a Varchar (19) - SSMS is treating it like a date

  Hi All, I ran across a situation today I have never seen before.   I have been working o…

  Carla Tillman

  2 replies

  7 years, 1 months ago

  By: Thom A

• TSQL: Grouping continuous timeslots together

  Dear  Communitiy, hope you can help me solving this issue: I have to group continuous timeslot…

  tommired2000 99625

  1 replies

  7 years, 2 months ago

  By: fahey.jonathan

• LIKE OR NULL with Multiple AND

  I have this table and I'm writing VB.Net code to find the error based on supplied TAG/s, here is my…

  ma_jeeves

  2 replies

  7 years, 2 months ago

  By: Thom A

• Query Help Please

  I am still quite a beginner at this SQL querying, so I appreciate any help on this. I have pulled t…

  thunter 5669

  2 replies

  7 years, 2 months ago

  By: thunter 5669

• Looping through a table-valued function

  Hi all, I have a question about the best/most efficient way to accomplish what I'm trying to do. I …

  RacerX330

  17 replies

  7 years, 2 months ago

  By: RacerX330

• Like operator with additional conditions

  Hi,I have the following values in a column. TT,FF,RR,GG,MM,NNLL,PP,TT,NNRR,NN,MM,LL If the value ha…

  sql_2005_fan

  5 replies

  7 years, 2 months ago

  By: Lynn Pettis

• Parse an SQL statement to find date columns

  Hi All This is a general question about T-SQL statements If I have a reasonably complex Select stat…

  andrew 67979

  1 replies

  7 years, 2 months ago

  By: drew.allen

• Dynamic script to script out statistics before dropping them

  I am looking to script out statistics using the below filter before dropping them so that I can rec…

  Feivel

  4 replies

  7 years, 2 months ago

  By: Feivel

• Synchronize 1 table between SQL servers in different countries

  Good day. I am looking for help on how to synchronize data between SQL server in 2 different count…

  olacour

  2 replies

  7 years, 2 months ago

  By: olacour

• Help on DDL_TABLE_EVENTS for auditing

  I am been putting together some auditing in non-prod that logs to a table and sends out a email on …

  Jasonb-231582

  8 replies

  7 years, 2 months ago

  By: Jasonb-231582

• Allocate daily meetings to employees but set a max of 5 hours per day + SSRS v3.0

  Hi all, I am currently working on a project where I need to allocate meetings to employees (randoml…

  naveed.tuf

  2 replies

  7 years, 2 months ago

  By: fahey.jonathan

• Row Count on a table not equal row count in XML file

  Hi, I have this SQL code to load data from a SQL table to XML;SELECT (SELECT BatchRunID, GETDATE() …

  mediacommentry

  1 replies

  7 years, 2 months ago

  By: sgmunson