SQL Server 2016 - Development and T-SQL

• Topics

  Started by

  Posts

  Last post

• Choose the result NOT in a JOIN-query

  I have this question selecting all students that are registered to a course. Select distinct Regist…

  larsp777se

  12 replies

  8 years, 5 months ago

  By: Gail Shaw

• Summarize field by week of the month

  Hi Guys! Hope you can help me with this. I have 3 tables as: table 1A        B …

  munchthk

  10 replies

  8 years, 5 months ago

  By: GaryV

• Batch Transaction (Begin Trans/Commit Trans) - DML Operation

  Hi ,I have a very Huge table (millions of the rows). I am performing a batch operation on it via SQ…

  vineet_dubey1975

  6 replies

  8 years, 5 months ago

  By: Sergiy

• Slow Full Text Search on New Server

  Got a new SQL Server, running SQL 2016 on Windows Server 2016. This VMWare at our hosting site.Serv…

  homebrew01

  19 replies

  8 years, 5 months ago

  By: homebrew01

• Why does Microsoft recommend THROW over RAISERROR?

  THROW has more cons than pros. This is the consensus I've encountered among developers.This post go…

  knightwisp

  4 replies

  8 years, 5 months ago

  By: FridayNightGiant

• Transpose dynamic rows into column

  hello all, i would like to seek your kind help regarding the transpose of rows into columns.i have …

  golden-1131024

  2 replies

  8 years, 5 months ago

  By: Jeff Moden

• SQL CONTAINTABLE with Multiple Word option - How to identify which word was found

  Declare @color nvarchar (100) Set @color='Red or Blue' Select T1.CARDID,t1.CarDescription,@COLOR fr…

  gjorgez

  2 replies

  8 years, 5 months ago

  By: gjorgez

• Grabbing sets less than an arbitrary number; not quite a bin packing problem

  I'm in a SQL2016 environment.Help me find the logic mistake in my code, please! I have an issue whe…

  Lowell

  5 replies

  8 years, 5 months ago

  By: Lowell

• Casting data from old table to a new one and changing its type

  I'm using SQL Server Management Studio. There is a table called Agreement in my database containing…

  rutos.mer

  14 replies

  8 years, 5 months ago

  By: Thom A

• Why does this amended JOIN cause a syntax error.

  I wish to change this SQL: SELECT    CONVERT(varchar(2), Data.WeekNumber) AS We…

  edwardwill

  7 replies

  8 years, 5 months ago

  By: Johan Bijnens

• Shred XML

  Thanks. I am trying to shred the xml below but getting more rows instead of 3 rows. Any help? I wan…

  fafful

  5 replies

  8 years, 5 months ago

  By: Eirikur Eiriksson

• Need Help .. Barcode Fonts not working in Sharepoint Reporting services after Intalling Fonts and Rebooting the server

  Installed barcode fonts on the Database Server and Rebooted the server.When I open report in the Re…

  mandavli

  3 replies

  8 years, 5 months ago

  By: mandavli

• Append json value

  Hi all,I have json like thisDECLARE @j NVARCHAR(max) = N'[{"Views":1,"Date":1493119613,"MediaCaptio…

  farax_x

  5 replies

  8 years, 5 months ago

  By: Jovan Popovic

• Importing only certain named columns from CSV

  I have a client that is terrible about giving me consistent data sets, so there could be any number…

  achilleid

  5 replies

  8 years, 5 months ago

  By: Matt Simmons

• Looking for examples

  Good evening I have the following code I need to execute and I can't for the life of me find any go…

  dallas.gibson

  3 replies

  8 years, 5 months ago

  By: Thom A