Re: [SQL] Job control in sql

2012-06-04 Thread lewbloch
Sorry about the earlier unfinished post - premature click. Svenne Krap wrote: > Ireneusz Pluta wrote: >> Svenne Krap pisze: > >> I am building a system, where we have jobs that run at different > >> times (and takes widely different lengths of time). > >> > >> Basically I have a jobs table: > >> >

Re: [SQL] Job control in sql

2012-06-04 Thread lewbloch
Svenne Krap wrote: > On 29-05-2012 12:32, Ireneusz Pluta wrote: > > W dniu 2012-05-25 10:28, Svenne Krap pisze: > >> Hi. > >> > >> I am building a system, where we have jobs that run at different > >> times (and takes widely different lengths of time). > >> > >> Basically I have a jobs table: > >>

Re: [SQL] Select row cells as new columns

2012-06-04 Thread lewbloch
danycxxx wrote: > Yes, I've looked at it, but id doesn't create the desired output. After more > research I've found that I my design is similar to Entity, Attribute and > Value(EAV) design and I think I have to redesign. Any suggestion regarding > EAV? Is there any other approach? EAV is controve

Re: [SQL] UPDATE Multiple Records At Once?

2012-04-16 Thread lewbloch
Carlos Mennens wrote: > I'm trying to update a customer record in a table however I need to > change several values (cust_address, cust_contact, cust_email). My > question is how do I properly format this into one single command? > > > forza=# SELECT cust_id, cust_name, cust_address, cust_contact