SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Running total with a twist

  Hi! I'm trying to optimize a cursor-solution for following problem: A customer can have a number of…

  siggemannen

  7 replies

  8 years, 1 months ago

  By: aaron.reese

• Getting free periods from booked periods

  I have this issue. I have a table with booked items, simplified here:declare @t table(dBookedFrom s…

  marc.corbeel

  12 replies

  8 years, 1 months ago

  By: jcelko212 32090

• Return rows where value doesnt exist

  Hello Everyone,     I have a slight problem so I hope you can help.I have a tab…

  meichmann

  9 replies

  8 years, 1 months ago

  By: Lynn Pettis

• Creating Filters like Previous Week, from Tuesday to Monday

  Hi, If I needed to create some kind of filter that would get the data between the previous week's T…

  kyagi.jo

  6 replies

  8 years, 1 months ago

  By: Jeff Moden

• Issue with Chinese Unicode

  I tried many collations still the below sql returns ??????  , Please help. declare @titleEntry…

  archana.mandiriappan

  3 replies

  8 years, 1 months ago

  By: HanShi

• Mind Boggling query.

  defineamol

  9 replies

  8 years, 1 months ago

  By: Jeff Moden

• Openrowset update issue

  Hi  I have a problem using OPENROWSET to move data from Server A to Server B correctly.I have …

  wbeetge

  5 replies

  8 years, 1 months ago

  By: Sue_H

• Prices – From the certain period to certain month.

  Hi All, First off all I am new to the forum and I am new to TSQL and I need some guidance. I have a…

  pete_80

  3 replies

  8 years, 1 months ago

  By: sgmunson

• Determine where a value falls between ranges to assign points

  I need some suggestions on the best method to assign points based on how a store per…

  ollyjolly

  4 replies

  8 years, 1 months ago

  By: sgmunson

• Crosstab With column Sum(values) and Count(nrDocuments) by Entities

  Hello communty, I try to build  a crosstab  that  return  for  each entity…

  luissantos

  1 replies

  8 years, 1 months ago

  By: frederico_fonseca

• Analyzing Existing MS SQL Database for Data Types and Sizing

  Hi All. First time posting here and need some guidance. I have a database that I am managing that w…

  andrew.jones 69458

  3 replies

  8 years, 1 months ago

  By: ScottPletcher

• Strange "The datepart millisecond is not supported by date function dateadd for data type date." error

  Hi, I am getting strange error 9810 "The datepart millisecond is not supported by date function dat…

  btio_3000

  11 replies

  8 years, 1 months ago

  By: btio_3000

• Updating datetime2 column not working

  Hello, Trying to update some datetime2 columns. UPDATE T_MYTABLE SET dateTransferred = '2018-03-26 …

  WebTechie

  19 replies

  8 years, 1 months ago

  By: Lynn Pettis

• Performance issue with the table having 40M rows

  INSERT INTO #ttSELECT DISTINCT dr.terr_grp_id,dr.terry_cd,dl.deal_line,dl.revs_no FROM deal_right d…

  archana.mandiriappan

  7 replies

  8 years, 1 months ago

  By: Jeff Moden

• Odd behavior -- execution plan different when I execute in the target database vs not in the target database

  So I have a query that's basically SELECT column FROM DB1.Schema.View.  The view is a bit of a…

  llevity

  15 replies

  8 years, 1 months ago

  By: TheSQLGuru