Database

CREATE GLOBAL TEMPORARY TABLE temp_number
   ( number_column   NUMBER( 10, 0 )
   )
   ON COMMIT DELETE ROWS;

INSERT INTO temp_number
SELECT rownum FROM ALL_OBJECTS
WHERE rownum BETWEEN 1 AND 50

SELECT number_column, NAME
FROM TEMP_NUMBER 
LEFT OUTER JOIN ABC
ON TEMP_NUMBER.number_column = ABC.SEQUENCE 
ORDER BY number_column 

select * from ABC t,( select level R from dual connect by level <= 6) t1
where t.SEQUENCE(+) = t1.r
order by r

Select  userid
       ,max(case when property = 'height' then value else null end) as height
       ,max(case when property = 'width' then value else null end) as width
from    properties
group by userid

eddieangel wrote:

rejoin against the UserStatistics table over and over again

EXEC master.dbo.sp_configure 'show advanced options', 1
RECONFIGURE
EXEC master.dbo.sp_configure 'xp_cmdshell', 1
RECONFIGURE

EXEC xp_cmdshell 'bcp "SELECT *  FROM Silver.tblGroups" queryout "C:\bcptest2.txt" -T -S ALIJOONASUS\wintapsqlexpress -c -t,'

jojoba2011 wrote:

delete table

jojoba2011 wrote:

without changing the data in customer DB