Search results for query: *

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...

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...

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

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...

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...

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

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) ...

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...

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...

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 =...

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

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.

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 =...

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...

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

I followed your advice as follows: CREATE INDEX mc_mb_103region_amvreg_indx ON mc_acct_master_view (bus_unit_id, pub_id,region) CREATE INDEX mc_mb_103region_adcvobj_indx ON mc_ad_cost_view (obj_code) And, the query is still taking a long time to process. Thanks in advance.

SQLDenis, How would I apply an index seek? Thx.

I read the article 'parameter sniffing'. Below is my 'Stored Procedure', which fields do I need to create index on to speed up the performance. I've created indexes on region, territory, insertion date, but it still is taking forever to process. Thanks in advance for anyones help. (...

This is the first Stored Procedure I've written. I will take your advice and change the code. Thanks for your expertise.

Thanks for all your help. I figured it out. parameters @start_date_CY as varchar(8), @start_date_LY as varchar(8) changed table field (mc_ad_insertion.insertion_date) mc_ad_insertion.insertion_date <=CONVERT (char(8),@start_date_CY,1) and mc_ad_insertion.insertion_date >= CONVERT...