View Single Post
  #3 (permalink)  
Old December 21st, 2006, 02:42 AM
maulik77 maulik77 is offline
Registered User
 
Join Date: Nov 2004
Location: Ahmedabad, Gujrat, India.
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to maulik77 Send a message via Yahoo to maulik77
Default

you can also use following for Selected records.

SELECT * INTO #temp from (Select top 3 * FROM tbl_BannerManager
        WHERE GETDATE() between dStartDate and dEndDate
        AND ndepth = 3)a

Cheers!!:)

Maulik Pandya