Search results for query: *

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.

Crystal Reports XI How do I sort on a summarized field? I have a formula that sums all the acdcalls for every supervisor - {@CallsHandled}. But Crystal will not let me use the {@CallsHandled} formula unless I have a group for {@Supervisor_Name}. And if I have a group on the...

Thanks PH, that was the ticket. Where can I learn more about Union Queries?

MS Access DB 2000 How can I merge 2 rows together from the example below. I would like to merge from the split field. Is it possible to merge split 499 in to split 103 and keep split 103 as an field? Now row_date logid split acdcalls acdtime acwtime 6/25/2005 79830 18 3 1059 15...

How can I use this statement to query an Informix database from SQL Server Enterprise Manager? where (row_date BETWEEN { fn NOW() } - 15 AND { fn NOW() } - 10)

SQL Server 2000 Enterprise Manager DTS Importing Data from an Informix Database Importing 1 Table, Table Name – root_dagent Connecting to the Informix database from a System DSN ODBC connection row_date is a datetime field, also sql server look at it as a smalldatetime field I am trying to use...