SQL Server 2022 - Development

• Topics

  Started by

  Posts

  Last post

• Return

  Self taught novice learning SQL and would welcome some help with the following code problem In my d…

  Cybodz

  11 replies

  1 year, 10 months ago

  By: Cybodz

• Freezing of multiple databases using VDI snapshot backup command.

  Transact-SQL snapshot backup for SQL Server 2022: Suspend all user databases on the server for a sn…

  Vivek Luhaniwal

  1 replies

  1 year, 10 months ago

  By: Vivek Luhaniwal

• Last value in a row containing..

  I've inherited code in which I need to designate each PATID as either Rel_Exempt or Med_Exempt, dep…

  boehnc

  7 replies

  1 year, 10 months ago

  By: boehnc

• Replication for archive server with longer retention period

  I want to set up SQL Server transactional replication from a main SQL Server to an archive SQL Serv…

  Jon 0x7f800000

  4 replies

  1 year, 10 months ago

  By: Jon 0x7f800000

• Retrieving First Word, First + Second Word, First + Second + Third Word, First

  Hi All, I have the company names in one column. Need a sql server query to  fetch in separate colum…

  sathishkm

  8 replies

  1 year, 10 months ago

  By: Jeff Moden

• Why don't these two queries return the same data?

  I have a table-value function that returns data for a report.  However, it's not returning the corr…

  edwardwill

  3 replies

  1 year, 10 months ago

  By: edwardwill

• SQL Challenge: Employee Salary Analytics

  onsider an employees table: employee_id (int) employee_name (varchar) department (varchar) joining_…

  Piyushbhatt

  4 replies

  1 year, 10 months ago

  By: Mr. Brian Gale

• Lead Updates Not Working, Only Rendering Nulls

  I hav a table that holds sports betting lines that i am using in a pseudo SSIS environment, and i'm…

  Zososql

  9 replies

  1 year, 11 months ago

  By: Phil Parkin

• Average price calculation

  Hello! I need to make a query that will calculate my average price for each item. CREATE TABLE [dbo…

  Puiu

  5 replies

  1 year, 11 months ago

  By: Jeff Moden

• Need help on query - DATEDIFF

  Hello, I want to have value Month ago Year ago So far, I've this SELECT CASE W…

  Adelia

  3 replies

  1 year, 11 months ago

  By: Jeff Moden

• Check Code Correction Current Period Prior Period Movement

  Please assist me?I am trying to calculate Current Period Prior Period Movement from my data, the da…

  yrstruly

  9 replies

  1 year, 11 months ago

  By: Mr. Brian Gale

• Can you reference 'Inserted' or 'Deleted' Trigger Table in SQL Mail Query

  Hello, I am trying to reference the results from the Inserted or Deleted tables from a SQL Trigger …

  DanielP

  2 replies

  1 year, 11 months ago

  By: DanielP

• Newby - Stuck with a trigger.

  Hello Forum, Apologies for this post, I'm stuck with an update trigger that i need to amend.  I nee…

  Private102

  2 replies

  1 year, 11 months ago

  By: ScottPletcher

• Primary key column question

  Hi, I'm new to sql server and successfully created a table of columns, however after creating the t…

  sqlsurfer

  2 replies

  1 year, 11 months ago

  By: Mr. Brian Gale

• Save output table in sql server

  How can I save the output table from the join code below in sql server. select * from [Products]  j…

  Teewhy

  1 replies

  1 year, 11 months ago

  By: DesNorton