SQL Server 2022 - Development

• Topics

  Started by

  Posts

  Last post

• 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, 9 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, 9 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, 10 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, 10 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, 10 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, 10 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, 10 months ago

  By: DesNorton

• sql command written in cmd that is .bat file is synchronous or asynchronous

  hi, I call few stored procedure from a .bat file  and .bat file is executed from micrisoft  windows…

  rajemessage 14195

  3 replies

  1 year, 10 months ago

  By: rajemessage 14195

• Restore table from onedrive

  I made a mistake and dropped a table with 270,000 records.  I have a backup table with 204,000 reco…

  Jocar26

  3 replies

  1 year, 10 months ago

  By: Jocar26

• How to Efficiently Find and Remove Duplicates in a Large SQL Database?

  I have a large SQL database with millions of records, and I've identified duplicate entries. What's…

  Piyushbhatt

  14 replies

  1 year, 10 months ago

  By: Jeff Moden

• Cannot able to login to mysql as localhost

  I have a query in mysql I have created a account with test@localhost and i want to access the parti…

  santhosh

  1 replies

  1 year, 10 months ago

  By: Phil Parkin

• How to find second position after decimal

  Have a numeric column HRS Numeric(5,2) Need to add error if the value after decimal point second di…

  mcfarlandparkway

  9 replies

  1 year, 10 months ago

  By: Jeff Moden

• Update CSV string with lookup table

  I need to replace word(s) in CSV string in table tblA, in the [original] column, by [word] from loo…

  itlk

  5 replies

  1 year, 10 months ago

  By: itlk

• SSIS - flat file import

  I am trying to import a text file that looks like this into a sql server database table using ssis.…

  EM2

  18 replies

  1 year, 10 months ago

  By: frederico_fonseca

• Need help on Pl SQL Stored procedure need to be converted on SQL SERVER.

  HI All. Iam looking for some support where i have been stuck since few days while converting the be…

  pavanpala.vja

  8 replies

  1 year, 10 months ago

  By: Mr. Brian Gale