SQL Server 2022 - Development

• Topics

  Started by

  Posts

  Last post

• Best table structure for a tall table that needs to be pivoted

  Hi Everyone, I have a table with about 2 million distinct IDs and another table with about 7000 dis…

  Dolfandave

  23 replies

  3 years ago

  By: Jonathan AC Roberts

• Struggle Bus - Varbinary(max) Performance Suggestions?

  I have a very large table I am dealing with that has a varbinary(max) column.  I have a Order By th…

  beantownace

  6 replies

  3 years ago

  By: EdVassie

• get a substring value from string

  Hi, I am new to SQL Server. I have table create table tmp1 ( serialnumber varchar(500) ) insert int…

  sonika2015

  43 replies

  3 years ago

  By: Jeff Moden

• What's the logic of the NOT IN clause?

  I thought I understood the "NOT IN" logic very well until I run into a case where the presence of N…

  Sam-263310

  21 replies

  3 years ago

  By: Jeff Moden

• Using SQL - Convert column to rows - not a straight forward pivot

  Hello All, I have below sample table. Code is also included. create table Trade_test (portfoliocode…

  abi

  3 replies

  3 years ago

  By: Jeff Moden

• FILESTREAM

  Trying to setup database with FILESTREAM. Using scripts that work great on previous versions of SQL…

  Ronzo

  1 replies

  3 years ago

  By: Ronzo

• I have to do a price increase on our parts. My question is history records.

  For each part there must be a history record of price from to price to. Is there a better way to do…

  bswhipp

  4 replies

  3 years ago

  By: Ronzo

• height_cm -> 167.60 centimeter need to convet height_FT column and Height_IN

  height_cm -> 167.60  i have data in sql server column that data i need to insert HeightFT column…

  DBA.k

  1 replies

  3 years ago

  By: frederico_fonseca