Recent content by safari7391

Removing the acd gives the store proc 586840 rows to the views 587660 rows.

For some reason the rows are off by 347. With your stored proc I have a total of 588007 compared to my views which give me 587660. Any idea why?

Stored Procedures SQL Server 2000 I am new to stored procedures, but need to create a stored procedure to increase the performance of a report. Is it possible to take the following 3 views and place them in a stored procedure? If so how? View3 reference view2, view2 reference view1 and view1...

This is only returning the same field as the date field. I only need to get the previous week. Do you have any other suggestions?

How would I use the the 2 formulas you provided in the critera section of my date field? I am only trying to get the previous week data.

Hello Everyone, Have a problem, hope someone can help. MS Access 2002 How to query data from a daily date field [row_date], for any dates that are from the previous week (from Sunday to Saturday). No matter which day the query is ran it will bring back the previous week data.

Where would it go in this SQL Statement? CREATE TABLE [SUP_EXC_Portal].[s53f].[dagent] ( [row_date] smalldatetime NULL, [acd] smallint NULL, [split] smallint NULL, [extension] char (7) NULL, [logid] char (10) NULL, [loc_id] smallint NULL, [ti_stafftime] int NULL, [ti_auxtime] int NULL...

SQL Server 2000 Enterprise Manager DTS Package - Import How to get the previous day of data from the SQL Statement? I would like use the [row_date] as my date range. CREATE TABLE [SUP_EXC_Portal].[s53f].[dagent] ( [row_date] smalldatetime NULL, [acd] smallint NULL, [split] smallint NULL...

Sorry about the missing information. I am using Cryststal Reports XI and a MS Access datbase. The parameters are created in MS Access.

how can I pass 3 parameters from a access database to crystal reports and use them as a dynamic parameter. I have already passed the 3 parameters from the access database to the crystal report and able to see the 3 parameters under the paramater section in crystal report. Just do not know how...

Also how can I pass 3 parameters from a access database to crystal reports and use them as a dynamic parameter. I have already passed the 3 parameters from the access database to the crystal report and able to see the 3 parameters under the paramater section in crystal report. Just do not know...

I am using Crystal Reports XI and I do not see the SQL Expression in that version. Although I do have a copy of Crystal Reports 9, and it has the SQL Expression in it. Should I down grade the report to version 9?

Can you please go into more detail about the "add command" and "sql", this is kind of new to me. The first formula is the... (select sum(AKA.`Sum_acdcalls`) from Daily_Metrics AKA where {fn ifnull(AKA.`Sprvr_Name`,'Other')} = {fn ifnull(Daily_Metrics.`Sprvr_Name`,'Other')}) Not sure about all...

This is the way I am sorting. I am using a parameter to sort the different summarized fields listed below. But the field are not working unless I group by the {@Supervisor_Name} formula. And I do not want to group by the {@Supervisor_Name} formula, because the fisrt sort will be by...

Group Sort Expert is greyed out. I have no groups.