I need to insert empty row in a temp table within a stored procedure.
Where is the DDL? There is no such concept in RDBMS.
What kind of concept is missing here?
Why is it a problem to have a temp table with empty rows?
It can be used to build cartesian products, and it's quite easy to populate it, for example:
-- create temp table and populate it with 10 empty rows
SELECT TOP 10 CAST(null AS CHAR(1)) c INTO #t
-- Select each row from MyTable as many times (10) as many empty rows found in #t
CROSS JOIN #t
See? A bit of creativity and concept flies.
However, I am sure it's not what OP does need it for...
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)How to post your question to get the best and quick help