INSERT INTO SELECT - large amount of records
I want to insert records into a TempTable. Something like this:

    insert into ##tempT
    SELECT * FROM MyTable 

MyTable contains a large amount of records so the "insert into" takes a long time. 

If I try to run:

    SELECT COUNT(*) FROM ##tempT

it returns always "0" until all records from "MyTable" are inserted by INSERT INTO command.

How can I get a progress count that advise me how many records are in ##tempT? 

I need to update a progress bar value while the SQL command is running.


Thank you.

INSERT INTO SELECT - large amount of records
===

I want to insert records into a TempTable. Something like this:

    insert into ##tempT
    SELECT * FROM MyTable 

MyTable contains a large amount of records so the "insert into" takes a long time. 

If I try to run:

    SELECT COUNT(*) FROM ##tempT

it returns always "0" until all records from "MyTable" are inserted by INSERT INTO command.

How can I get a progress count that advise me how many records are in ##tempT? 

I need to update a progress bar value while the SQL command is running.


Thank you.
