How can I use my SQL query in the cursor query?

Question

I want to get the output by returning in the course question against the values from the following SQL query question. I want to record this print. How can I do that? Thank you for your help.

SQL query:

SELECT 
    [NoMatchExplanation],
    COUNT(*)
FROM 
    err.CustomerBank
GROUP BY 
   (NoMatchExplanation)

Cursor query:

DECLARE cr_Read CURSOR FOR
   SELECT TABLE_SCHEMA + '.' + TABLE_NAME
   FROM INFORMATION_SCHEMA.TABLES 
   WHERE TABLE_SCHEMA = 'err'

DECLARE @name NVARCHAR(100)

OPEN cr_Read

FETCH NEXT FROM cr_Read INTO @name

WHILE @@FETCH_STATUS = 0   
BEGIN
    INSERT INTO etl.ErrorTable VALUES (@name)

    FETCH NEXT FROM cr_Read INTO @name
END

CLOSE cr_Read
DEALLOCATE cr_Read

you dont need a cursor for this. Check Ruslan's answer

GuidoG
– GuidoG

2017-08-28 12:38:56 +00:00
Commented Aug 28, 2017 at 12:38 — GuidoG
– GuidoG, Commented Aug 28, 2017 at 12:38

Ruslan K. · Accepted Answer · 2017-08-28 12:32:30Z

5

Just do like this:

INSERT INTO etl.ErrorTable
   SELECT TABLE_SCHEMA + '.' + TABLE_NAME
   FROM INFORMATION_SCHEMA.TABLES 
   WHERE TABLE_SCHEMA = 'err';

answered Aug 28, 2017 at 12:32

Ruslan K.

2,0011 gold badge16 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How can I use my SQL query in the cursor query?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related