Search results for query: *

I am running SQL Server 2000 on Windows NT 4.0. Friday I did some disk maintenance and installed a new program from Data Flux. Monday afternoon I tried to run several SQL queries and no matter what one I tried the performance was extremely poor. Queries that had taken normally 9 seconds to...

Below is a web description for the above product. Designed for Microsoft® Visual Studio® and other COM-based development environments, the feature-rich Crystal Reports Report Designer Component 8 (RDC) gives developers unprecedented control over report layout and formatting for web...

I have been investigating the potential of the SQL Server 2000 Analysis Services module. I would like to be able to take the results and put them in regular reporting formats or setup automated reports. But it seems hard to find a reporting tool that doesn't include a vendor's whole package...

I hope I can explain this correctly. My SQL Server administrator has given me permission to create Tables in the TEMPDB. This works fine until he has to reboot the TEMPDB and then I lose those rights. What would be a permanent solution, so he doesn't have to set me up everytime the TEMPDB is...

What is the rest of the SQL statement that I would have to write to determine the amount of weekdays between two dates? The first part seems easy enough: DateDiff(d,start_date,end_date) AS DaysDiff but from other SQL resources the rest of this statement seems to involve lines of coding...

I am trying to utilize SQL in Access to speed up my queries. While running the queries frequently half my video display disappears and I can't tell if and when the query is done. When checking what is happening with Windows NT task manager Microsoft Access appl is shown to be "Not...

I have a form that displays the time ticking by in a stopwatch format. In order to start the action I have to press the "Start" command button which then of course turns into a "Stop" button. After pressing a command button on my main form to run a certain long query I'd...

I have been racking my brain trying to figure out how to get the record with the earliest "StartTime" from three identical records. I have tried First and Last, Min and Max from the aggregate functions with no luck. Would prefer minimum programming or code for the answer. Example...

I guess I should have posted this question in this forum. I am trying to insert a text string called "quote" in place of a number valued bar on a bar graph when the field (Istatus) equals "quote." When the field (Istatus) equals "active contract" the values in the...

This is my SQL statement: SELECT [serial_no] & " " & [part_number] AS MACH_ID, TestGetLivedata.type, [EndDate]-[FirstDate] AS DaysLeft, TestGetLivedata.IStatus, IIf([IStatus]="active...

I have been trying to optimize performance in my Access Database by building SQL pass thru queries to data mining on our SQL Server which is on a network. Since I am unable to do a "make table" SQL query I have been running a SQL select query and trying to paste the results into a...

I am trying to use SQL pass thru queries in Ms Access 2000 to query our Call Center tables (application is Clarify) which are on a 7.0 SQL Server located on the network. Here is my SELECT statement: Select id_number, creation_time INTO table_raw from table_case When I run this query I get an...