SQL Server 2022 - Development

• Topics

  Started by

  Posts

  Last post

• Is TemporalTable SysStartTime available before performing an insert/Update?

  I want to align a Date column (datetime2(7)) with the same full resolution date of SysStartTime col…

  Dwaine Wright

  6 replies

  2 years, 4 months ago

  By: Ken McKelvey

• Matching the table

  Hi All, I have two table called TableA and TableB. Here I need to match the TableB records from Tab…

  sathishkm

  2 replies

  2 years, 4 months ago

  By: Dennis Jensen

• SSDT import into a table from .csv corruption

  Hello everyone, I am importing from a csv file into a table. Everything works fine. One filed is im…

  atzvei

  6 replies

  2 years, 4 months ago

  By: Jeff Moden

• Master Data - Hierarchies Creation, Change and Maintenance

  Dears, Hope this message finds you well I am now moving into a Master Data position and my experien…

  river1

  16 replies

  2 years, 4 months ago

  By: Jeff Moden

• Grouping the first letter in a string

  Hi All, I have the column of data in SQL Server. Here  I need to group the letters of first word in…

  sathishkm

  6 replies

  2 years, 4 months ago

  By: Jeff Moden

• Extracting the string before and after the given character

  Hi All, I want to extract the string before and after the given characters. Example: ijk.nl?utm_sou…

  sathishkm

  1 replies

  2 years, 4 months ago

  By: aitorzur@hotmail.com

• Data Problem

  This is the Data ID ----- Date From ------   Date To    ------- 2  ----- 2020-01-01  ----- 2020-01-…

  immad

  4 replies

  2 years, 5 months ago

  By: Jeff Moden

• what's the performance difference between unique clustered index and primary key

  Is there a performance difference between a unique clustered index and a primary key clustered inde…

  Snargables

  29 replies

  2 years, 5 months ago

  By: CreateIndexNonclustered

• Partial Matching the Columns

  Hi All, How could I partially match the columns from two different table. I have attached the excel…

  sathishkm

  3 replies

  2 years, 5 months ago

  By: Jeff Moden

• Use a flag, or calculate, to retrieve counts

  I'm working on a Holiday Leave system (for typically several hundred or more personnel).  Currently…

  edwardwill

  11 replies

  2 years, 5 months ago

  By: Jeff Moden

• Case and When Query

  Hi All, I want to rewrite the below query using the Case and When statement Query 1 update [SF_Titl…

  sathishkm

  9 replies

  2 years, 5 months ago

  By: CreateIndexNonclustered

• Stop deployment of SQL DACPAC if there is DROP statements

  Hi all, We have a SQL project to be deployed to an Azure SQL server. We are looking for s specific …

  ajupulickal

  3 replies

  2 years, 5 months ago

  By: Jeff Moden

• First Two Words

  Hi All, I want to extract first two words from the string. Example ABC Property Management Inc. I n…

  sathishkm

  20 replies

  2 years, 5 months ago

  By: Jeff Moden

• Dynamic Query

  Hi All, I have to generate a dynamic query for the below mentioned keywords to update them in Title…

  sathishkm

  2 replies

  2 years, 5 months ago

  By: Michael L John

• Random Number Generating

  Hi All, I need to generate random unique numbers for 10 million records. Here is my requirement Th…

  sathishkm

  17 replies

  2 years, 5 months ago

  By: Jason A. Long