Search results for query: *

Kraeg, How did you do it? You mentioned using the ColumnHeadings property of the Query. How does this help to eliminate the problem? I am having the same problem even in a smaller crosstab query and I only have one table so I can learn how to take care of this.

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

Thanks for the help, all. I am using SQL Server 7.0 but I am trying to get SQL Server 2000. I was hoping that there was some easy date function such as Networkdays in Excel. The less lines of code the better as I am not a natural programmer and I would actually like to understand the code...

MAybe I am missing something but how does that enable me to determine how many weekdays are between Start_date and End_date? For instance the DateDiff between April 30th 2001 and may 7th 2001 would be seven days even though there are only 5 weekdays. Please explain.

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

Thanks for the help. I worked with my company's IT SQL Server support person and he set me up to use SQL Server's query analyzer and test my SQL statements. This is so much more usable in explaining what is happening.

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

Thanks, Jerry but I oversimplified the problem. Of course I have lots of records with multiple duplicates so your solution would only work for this BD serial number. Thanks anyway.

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

Tom and guest, Please be patient with me. I'm sorry but the two SQL statements posted in the last message look exactly the same to me, i.e., I was instructed to invoke an ordinary query: Select id_number, creation_time INTO table_raw from table_case And this would allow me to...

Tom, I tried your suggestion and got back another error message: [Microsoft][ODBC SQL Server Driver] [SQL Server] Invalid object name 'table_raw' (#208) Don't know if I am posting my reply correctly or not. thanks

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