Steve Jones

My background is I have been working with computers since I was about 12. My first "career" job in this industry was with network administration where I became the local DBA by default. I have also spent lots of time administering Netware and NT networks, developing software, managing smaller IT groups, making lots of coffee, ordering pizza for late nights, etc., etc.

I currently am the editor of SQL Server Central and an advocate/architect at Redgate Software. I am also the President of SQL Saturday, maintain the T-SQL Tuesday monthly party, and remember our colleagues at sqlmemorial.org.

You can find out more about me on my blog (www.voiceofthedba.com) or LinkedIn (www.linkedin.com/in/way0utwest)
  • Interests: yoga, reading, biking, snowboarding, volleyball

All authors

All authors

Blogs

FREE Window Functions Course (This Month Only!)

By

Want to really level up your SQL game? I mean, go from good to great? This March...

Tally Table Alternatives: #SQLNewBlogger

By

We published an article recently at SQL Server Central on Tally Tables in Fabric...

Real-Time Intelligence in Microsoft Fabric

By

In today’s data-driven world, organizations need the ability to analyze and act on data...

Read the latest Blogs

Forums

Dynamic T-SQL Script Parameterization Using Python

By omu

Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...

Solutions for Environmental Testing | Fare Labs

By farelabs

The state-of-the-art FARE Labs Environmental Testing Laboratory provides a comprehensive variety of testing services...

Database restoration slowed down abnormally.

By JasonO

I'm running some restoration activity as part of a rehearsal to prepare for an...

Visit the forum

Question of the Day

Inserting Sequences

I created a new sequence in SQL Server 2022 with this code. 

CREATE SEQUENCE myseqtest START WITH 1 INCREMENT BY 1;
GO
I want to use this to insert some data from another table into a new table with this sequence. Which of these queries shows the way to do this efficiently? 
-- 1
INSERT dbo.NewMonthSales
  (SaleID, saleyear, salemonth, currSales)
SELECT
  NEXT VALUE FOR myseqtest
, ms.saleyear
, ms.salemonth
, ms.currMonthSales
FROM dbo.MonthSales AS ms;
GO

-- 2
INSERT dbo.NewMonthSales
  (SaleID, saleyear, salemonth, currSales)
SELECT
  NEXT VALUE 
, ms.saleyear
, ms.salemonth
, ms.currMonthSales
FROM dbo.MonthSales AS ms, myseqtest;
GO

--3 
DECLARE mycurs CURSOR FOR SELECT
 ms.saleyear
, ms.salemonth
, ms.currMonthSales
FROM dbo.MonthSales AS ms

DECLARE @yr INT, @mn INT, @sales NUMERIC(10,2)

FETCH NEXT FROM mycurs INTO @yr, @mn, @sales
WHILE @@FETCH_STATUS = 0
 BEGIN
   INSERT dbo.NewMonthSales
    (SaleID, saleyear, salemonth, currSales)
    SELECT
      NEXT VALUE FOR myseqtest
    , @yr
    , @mn
    , @sales
   FETCH NEXT FROM mycurs INTO @yr, @mn, @sales
 END

See possible answers

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy