>- see footer for list info -< CF needs to periodically update about 1000 rows of data in MS SQL Server 2005 but I don't want it doing 1000 separate inserts when I'm sure it can be done using just 1 query. There's an id, date, and a numeric column.
Please can someone divulge the secret on what the sql query should look like? This would be really efficient in comparison to doing 1000 updates. Thanks! Gary. _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
