Recent content by rotelmak

Thanks AP, but I got this wrong result product_id date_c input last_date_s total_sales 001 01.09.2008 100 11.09.2008 100 001 01.09.2008 50 11.09.2008 100 Result must be product_id date_c input last_date_s...

I have table with this data(sql 2000): product_id date_c input sales 001 01.09.2008 100 001 01.09.2008 30 001 10.09.2008 40 001 10.09.2008 10 001 11.09.2008 50 001 11.09.2008...

My test table have this columns with this data cus_id inv_n date_ip debit credit 1 101 10.01.07 100.00 1 101 25.01.07 70.00 1 101 26.01.07 10.00 2 102 11.01.07 200.00 2 102 26.01.07 150.00 2 103...

Table finarh have this fields: customer_id char(9) datanal datetime nalog char(6) dokument char(12) diznos decimal(12,2) piznos decimal(12,2) datadok datetime valudok datetime oe char(4) re char(2) Also table...

Thank you SQLDenis, Lamprey13

I have stored procedure wich select(sum) data from table1 and insert modifyed data in table2. It is important to prevent other users of the aplication to change data(insert,update,delete) into table1, while query is in progres. How can I lock records in table1 (sql server 2000)? Thank you

Borislav, invoice_no field is character type. Now your code works fine. Thank's

Here is SP code: CREATE PROCEDURE [dbo].del_invoice @minvoice_no CHAR(12) AS begin SET NOCOUNT OFF BEGIN TRANSACTION delete from mytable WHERE invoice_no = @minvoice_no IF @@error <> 0 BEGIN ROLLBACK TRANSACTION RETURN END COMMIT TRANSACTION SELECT...

Borislav, crsDeletedRecs return zero, not number of deleted records

I am novice in sql2000. I call stored procedure with SQLEXEC function to delete invoice in sql2000 database. How can I see in VFP form number of deleted records ?

Works fine. Thank you Alex

I have table with this records product_id quantity color 1 10 red 1 20 black 1 30 green 1 40 red 1 50 black 2 60 black 2...

Thank you SQLDenis. It works fine

Borislav I use Sql 2000

I am novice in sql. In my test database I have table with this structure and data: myfield1 401 580 633 785 801 Can I get with query this output result, without usig identity column: myfield1 recordno 401 1 580 2 633 3 785 4 801 5