Fname has sent a secret message

If this e-mail is not displayed properly, use the following link: http://www1.emarsys.net/u/gm.php?prm=NWFvhR7spx_125656616_71240_256455

Fname invites you to shop LUXURY & HIGH FASHION Brands at up to 80% off !! JOIN NOW & Begin your 1st Luxury Experience with a Free Rs 250 Shopping Voucher       New Sales Everyday   Indulge Yourself! Team Fashion and You Hurry & Join The Shopping Revolution Now !

G P Reddy invites you to Slice 50% of your Restaurant and other Entertainment Expenses.

G P Reddy  wants you to check this message

Hi ,
 
Can you really save 30%, 40% or even 90% on movies, restaurants, spas, salons, gyms, resorts and other fun places?

Yes, you can at www.dealivore.com. I am a user of the website www.dealivore.com.  Its an exciting website that helps you save money on movies, restaurants, spas, salons, gyms, resorts and other fun places in local places in the city.
Read till the rest of the email and you will get Rs 50.  

How Does it Work in 3 Easy Steps

	Once you register. You get a deal alert every 24 to 72 hours. These are unbeatable, mouthwatering deals you won’t typically get.
Browse the deal and when you like it you can purchase it (online or  cash on delivery)
	Get your voucher and redeem it at the location.

What should you do now?

Simple, just click here (my personal referral link) for deal alerts and get Rs 50 in your account. You can use this against your first purchase, get a bigger savings with this gift. Signing up is very easy and instantaneous.
 
If you have clarifications send me an email at  reddygantasri31@gmail.com 

Regards

G P Reddy

PS: You wont get Rs 50 if you directly register at www.dealivore.com, you need to click on my personal referral link to get the gift.

Inserting excel sheet data in to SQL Server 2005 database table

1. First of all see that you have the create permissions in that database.
2. If you have the Create Permissions, Go ahead otherwise get it from DBA
3. Try to create a temporary table with the column names of the excel sheet.

Example:

create table Temp
(
Column1 datatype null/not null,
Column2 datatype null/not null,
Column3 datatype null/not null,
Column4 datatype null/not null,
……………………… ……… like on
)

4. After creating the Temporary table Insert the excel sheet with data in to the table.
INSERT INTO Temp
SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\(NAME OF THE EXCEL SHEET).xls;HDR=YES;IMEX=1', 'SELECT * FROM [sheet1$]')
GO
5. Be sure that the sheet number of the excel sheet is mentioned correctly, here it is Sheet1 but It might be different in your excel sheet and save the excel sheet in C drive.

That's it you can see the excel sheet data in table Temp.