Recent content by asimeqi

I am using Micros 9700. I need to have the trailers print in a Journal Printers. Does this option exist? If that is not an option is there an option to print the guest check in the Journal Printer? I think if that happens the trailers will print on the Journal too. Right now I have no way of...

Thanks Bo, I probably will end up doing that but it would be good if there is a way to apply Equal Pay programmatically. Can you tell me how to disable Equal Pay? I am sure you know this but I found that one way to undo the Equal Pay is to split the check and move all the items in the second...

There is this feature in Aloha, called Equal Pay. In the payment screen you hit the Equal Pay key, you select the number 2 and the amount to pay is split in 2. You can select one of the payments and pay cash etc. for it. All is well. Now suppose that you have your special mode of payment...

Thank you guys. That was very helpful.

I have a table like this: DECLARE @operator_activity TABLE ( account_id INT, operator_id INT, num_trans INT ) I need to find the max value of num_trans for each account and also the corresponding operator_id. So I write something like this: DECLARE @operator_activity TABLE (...

Thanks guys, both your queries are instructional.

I have this table: DECLARE @transactions TABLE (account_id INT, amount INT) INSERT INTO @transactions VALUES (1, 1) INSERT INTO @transactions VALUES (1, 2) INSERT INTO @transactions VALUES (1, 3) INSERT INTO @transactions VALUES (2, 2) INSERT INTO @transactions VALUES (2, 2) I want to write a...

Thanks George. That is an wonderful trick.

I have a table like this: Declare @transactions Table(tran_id Integer, account_id Integer, tran_date datetime) Insert Into @transactions Values(1, 1, '2006-06-08 08:00:00') Insert Into @transactions Values(2, 1, '2006-06-08 14:00:00') Insert Into @transactions Values(3, 2, '2006-06-09...

Thank you guys. The LEFT OUTER JOIN did it. For future readers of this thread I think it is worth mentioning that the join is way faster if the 2 tables are ordered by the join attribute. In that case the optimizer can perform a MERGE JOIN. I discovered this the hard way.

That works but it is a bit slow. Table2 has 500,000 rows. Table1 has 20,000,000 rows. I could use all speed ups that I can get.

Yes, they have the same primary_key.

I have 2 tables, table_1 and table_2. Table 1 has all the rows of table_2 and some more. I need to find the rows in table 1 that are not in table 2. All I could think of is to use a cursor. There has to be another way, right?

Yes Shankar, part of the information that I need to hide is licensing information. I will certainly encrypt it but the keys will be in code. This program is going to be distributed in a country where piracy is rampant. There are kids who wouldn't mind spending months of their life figuring out...

I have an application which uses a SQL Server Express database. There are tables in the database that contain information I do not want users of the application to be able to see or be able to change. However since I do not have control over the database file, the user can simply install a copy...