>- see footer for list info -< MS SQL i'm guessing and I'm not an expert on that DB unfortunately, however I do believe that it is possible to pass a record-set to a MSSQL stored procedure
words in red ===> google! http://www.sqlteam.com/item.asp?ItemID=637 this might help or maybe someone with your specific db knowledge can help. good luck! On 3/23/06, Gary F <[EMAIL PROTECTED]> wrote: > > >- see footer for list info -< > Hi Michael. Yes, this is an update. But it's not getting data from another > table. CF has the data as XML (effectively a structure/array) and needs to > blast it into the db. The primary key (ID) will correspond to what is > already in the db. > > It's actually a stored procedure I need to write (for security reasons). > Sorry, I should have said that before. My bad. I think part of the > challenge > is passing anything up to 1000 rows of data using @parameters. Here lies > the > limitations of SPs! Yup, I'm out of my depth. Glug, glug, glug. ;-) > > Gary. > > On 3/22/06, Michael Traher <[EMAIL PROTECTED]> wrote: > > > >- see footer for list info -< > > Is this an update or an insert? > > > > But anyhow > > > > it will be something like > > > > update mytable m > > from myothertable y > > set id = y.id, > > thedate = y.thedate, > > thenum = y.thenum > > where m.key = y.key > > and y.othercriteria = 'foo' > > > > or > > > > insert into mytable > > select id,thedate,thenum > > from myothertable > > where y.otherciteria = 'foo' > > > > HTH :-) > > > > On 3/22/06, Gary F <[EMAIL PROTECTED]> wrote: > > > > > > >- 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. > > > > > > > > -- > > Mike T > > Blog http://www.socialpoints.com/ > > _______________________________________________ > > > > 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 > > -< > > > _______________________________________________ > > 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 > -< > -- Mike T Blog http://www.socialpoints.com/ _______________________________________________ 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 -<
