>- see footer for list info -< I did try Googling, honest! Obviously I had a keyword issue. ;-) Thanks for the pointers, looks like a good starting place.
Cheers! Gary. On 3/23/06, Michael Traher <[EMAIL PROTECTED]> wrote: > > >- 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 > -< > _______________________________________________ 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 -<
