Recent content by Barrow66

When is it necessary to use a table variable, a temp table and a derived table in a stored procedure? Does it depend on the total number of records. Lets say the Stored Procedure1 returned 10,000; Stored Procedure2 returned 100,000 and stored procedure3 returned 1,000,000,000 rows. When...

Insert into problem I have information in table variable as: Table1 Location Letter Amount 12 A 0 12 B 0 12 C 1 The information above placed in another table variable must look like: Table 2 Location Letter Amount 12 A 1 12 B 1 12...

How can one call another exe application from a visual basic environment using command line ?

I have a report that has column name CurrentVBDate. I want to populate this column (CurrentVBDate) with data from other columns. The other columns are PreviousVBDate, NextSequentialVBDate and NextSequentialVBDate. I am using CR8.5. Any assistance will be appreciated and thanks in advance for...

Hi There, Can someone tell me how to create a group tree in CR8.5 when a main report has a sub report in it's footer section. Is there a way of showing a group tree when a sub report is embedded in a main report. I need to drill down based on the first group header in both report...

I am using Access in a multiuser environment. The database is used for users accessing information by calling into the system.Users at the same time run reports and do package ordering. The database get corrupted many times in a day. How can this be averted. How much users can access accomodate...

Both some clients we use ASP and the other strict URL.However we are trying to Standardize through ASP code

Web.

I need to drill down without showing the drill-down box for users. All what the user need to do is to click on the header and see all its contents. For example, Group = Country, Second Group = Site. Country is USA and Sites are 123, 456, 789, 800. I need users to click on USA on the report to...

Is there a way of implementing immediate ifs(IIF()) within immediate ifs(IIF()) in access queries. For example, If visit4Days and visit5days does not fall within demand days then order 1. If visit4days and visit5days does fall within demand days then order 2. I have four fields that get...

Thanks. I actual want to use UNICODE.But I do not know how.

Any ideas on how to print or show greater than equal to sign. I do not mean >=. I mean greater than > and the equal to sign is -. Then minus sign needs to be below the greater than sign. Thanks in advance.

How can I use UNicode2265 in vb. Is it like Chr(2265)? Thanks inadvance

I need the >- sign. The - must be below the > sign.

Can anyone please help?????