Search results for query: *

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

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.

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

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

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

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

Crystal Reports XI Windows 2000 Pro Access Database ODBC connection Also I have a Left Outer Join on the detail table and a summarized table of the detail table. The data captures call center data, but it is rolled up to the skill leave of each agent not as each individual call – detail table...

I need help passing summarized formulas from a main report to a subreport. Also taking the same formulas and having the ability to sort on them through a parameter in the main report. Reason: The reason a subreport is involved, it’s to pass the summarized formulas from the main report to the...