Re: Execute Stored Procedure

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

<rn5a@xxxxxxxxxxxxxx> wrote in message
news:1161525116.689701.264390@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

You hit the nail on the head, Mark.....the looping logic was going
wrong....
Thanks for pointing out the flaw, Mark :-)

Welcome.

BTW, you could make the SP much more robust by wrapping the four separate
statements in a transaction...


.

Relevant Pages

  • Re: Server Configuration
    ... It's always a good idea to separate the log from the data files onto ... > of a concern in an environment like mine, where the transaction rate is ... and Data) on separate RAIDs--that would be 3 RAIDs in one box! ... >> RAID you might want to see if you can't do a RAID 1+0 instead of 5. ...
    (microsoft.public.sqlserver.setup)
  • RE: table structure
    ... As far as the table structures, each transaction can ... possibly each hour for each day as a separate line ... Keep your company and schedule tables the ... tables for sales and purchases, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: sqlserver 2005: indexes on raid-0?
    ... located on a raid-5 arrayand the transaction log is on the same ... AND hourly log backups to the same disk array, ... decided to place the busiest/largest tables on separate drives. ...
    (comp.databases.ms-sqlserver)
  • Re: How do I join 2 tables
    ... changing the text wrapping in Table Properties Cell did not ... highlight one table, then highlight the other table while holding the ctl ... >>paragraph that separates the two tables, it keeps it as two separate tables. ...
    (microsoft.public.word.tables)
  • RE: table structure
    ... Table design is a good forum for your question –you should always have a good, sound table design before developing forms. ... The Load> Scheduler making the transaction is not going to want to> enter every hour for every transaction he makes each> day. ... but I'm visualizing a form that will have all the> hours listed for the day and the scheduler can just> cursor down to the hourin question and enter the MW> and $$. ... Do I need 2 separate transaction tables for sales and> one for purchases? ...
    (microsoft.public.access.tablesdbdesign)