Sql Inserting Multiple rows into a Table

After spending hours trying to work out why the sql bulk insert command refused to work. (it always claimed it could not open the file but the permission sets looked fine) I found Pinalkumar Dave’s blog at http://blog.sqlauthority.com/2007/06/08/sql-server-insert-multiple-records-using-one-insert-statement-use-of-union-all/ and the example code worked wonderfully for me. So I had to do was to edit the data file, but a few change and replaces are better the inserting the values n times

A quick example

Insert into usage (Forename,Surname,Town)
Select ‘Fred’,’Smith’,’Manchester’
union all
Select ‘Bob’,’Jones’,’Wigan’
union all
Select ‘Anna,’Bell’,Stockport’’
Go

So thank you again Pinal Dave

Office 2010 Useful Blogs

Microsoft’s blogs on Office 2010 are well worth reading

http://blogs.technet.com/office2010/default.aspx This is the engineering blog

and the web apps blog is http://blogs.msdn.com/officewebapps/

I love the office web apps I can see how they will be used everywhere within a few years

Have a look at the Powerpoint blog on http://blogs.msdn.com/powerpoint/archive/2009/11/11/powerpoint-on-the-web-editing.aspx