Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by brxmas

  1. brxmas

    Control Button

    Doug, There is no subform, I'm adding records to the form itself. Private Sub Command44_Click() On Error GoTo Err_Command44_Click Dim intnewrec As Integer stDocName = "frmrentals" DoCmd.GoToRecord , , acNewRec Exit_Command44_Click: Exit Sub Err_Command44_Click: MsgBox...
  2. brxmas

    Control Button

    I'm trying to add a new record in my form using a 'Command Buttom'. Below is my code. Private Sub Command11_Click() On Error GoTo Err_Command11_Click Dim intnewrec As Integer stDocName = "frmrentals" DoCmd.GoToRecord , , acNewRec Exit_Command11_Click: Exit Sub...
  3. brxmas

    Group DistinctCount

    Nevermind, I can create a formula and group it by it.
  4. brxmas

    Group DistinctCount

    SQL 2000 Crystal XI I have a group on a report {class_group_desc} I need to have a DISTINCTCOUNT for each {ad_num} Formula {@emp}: distinctcount({@dist})-1 Formula {@dist} If {mc_period_dates.period_year} IN [2006] AND {mc_period_dates.period} = 5 AND...
  5. brxmas

    Stored Procedure Dates Not Linking Into Crystal Rpt

    SQL Server 2000 Crystal 9.0 I'm having problems getting the following fields to link into my Crystal report: @year, @period, @start_period_CY, @end_sun_CY, @start_period_LY, @end_sun_LY Below is my Stored Procedure CREATE PROCEDURE [bc].[Test_Fri] @year int = NULL OUTPUT, @period tinyint...
  6. brxmas

    Datetime Select????

    select insertion_date = Convert(VarChar(10), mc_ad_insertion.insertion_date, 101) From mc_ad_insertion Where insertion_date >= '03/24/2006'
  7. brxmas

    Stored Procedure Using RollUP

    ODBC 2000 Crystal XI My Stored Procedure is below. I would like to do a ROLLUP on each prod_code. Which is best ROLLUP or COMPUTE SUM to use for quick processing time. I've never used either. I would appreciate anyones help. Thanks in advance. ( @year int , @start_date_CY varchar(10) ...
  8. brxmas

    Stored Procedures NOT IN Clause

    Denis, I tried both your 'Where' statements and I still get obj_codes 19,29 and 900 and prod_codes 'ELDY' mc_ad_cost_view.obj_code IN (select obj_code from mc_ad_cost_view where obj_code NOT IN ('19','29','900')) and mc_ad_insertion.prod_code IN (SELECT prod_code FROM mc_ad_insertion WHERE...
  9. brxmas

    Stored Procedures NOT IN Clause

    Hope this gives you a little more insight. For example I do not want to see any records that have an obj_code of 19, 29, 900 and prod_codes of ELDY, INEM. There should only be data for obj_codes 100, 200, 300 and prod_codes of MBDY, MBEX, MBLE. The example below shows what data is coming in...
  10. brxmas

    Stored Procedures NOT IN Clause

    Need help with using NOT IN in a Stored Procedure. I've tried various ways, but data still is incorrect. Maybe someone can tell me what I'm doing wrong. Thanks in advance for your help. SELECT ad_num = mc_ad_detail.ad_num , source = mc_acct_master_view.source , adv_type =...
  11. brxmas

    Stored Procedure Performance

    That's for everyone's input. I have the query down to 5 min and 12 seconds.....Thanks again.
  12. brxmas

    Stored Procedure Performance

    I really appreciate everyones help in resolving why it's taking forever to run this query via 'Stored Procedure'. What do I need to change to increase the speed? Thanks.
  13. brxmas

    Stored Procedure Performance

    Here's the exec plan. Thanks in advance. StmtText DECLARE @year int, @start_date_CY smalldatetime, @end_date_CY smalldatetime, @start_date_LY smalldatetime, @end_date_LY smalldatetime --SET @start_date_CY = '11/28/2005' SET @year =...
  14. brxmas

    Stored Procedure Performance

    I looked at the 'Execution Plan' and there are table scans. What can I do to improve the process? Thanks in advance for your expertise. Below are the Statistics. Application Profile Statistics Timer resolution (milliseconds) 0 0 Number of INSERT, UPDATE, DELETE statements 0 0 Rows...
  15. brxmas

    Stored Procedure Performance

    The db has 53,742 records. And, it took 12 minutes to process. Thanks.
See more

Part and Inventory Search

Back
Top