Search results for query: *

Hi, I have DTS package with the following statements in the source SQl query window on Source tab. I am importing data from Sybase view to corresponding tables in SQL Server 2000. I can parse the query. but preview return this DTS Designer Error message "No rowset was returned from the SQL...

I developed a Crystal Report viewer using developer studio .NET. It works for many reports but not this one. when I enter @startdate and click for next parameter, the message "please enter a datetime value" appeared. it did not say where it was generated. any idea, anyone? thanks for helping...

I a trying to export the result of a report to Excel but keep getting blank rows in between each records. there is no extra space above or below the field in the report. how do I eliminate these blank rows? thanks in advance for your help.

I a summary page on a group footer for each group but I don't want to print page n of m on the summary page. how do I detect end of group. thanks in advance.

This is a continuation of a previous question on NOLOCK. Here is the situation. we have a static database -- a copy of the production database. there is no update, insert, or delete activity on the database, it is strictly used for reporting and research of production problem. there are a lot...

thanks bhags, one more question, does a simple SELECT (read) locks up tables too?

Does a SELECT query that just read from a set of tables locks these tables while reading? If it does, will a hint NOLOCK improve the performance of the query and hence improve the performance of other queries that read off the same set of tables at the same time? Does NOLOCK means "don't lock"...

Can anyone help to explain this please. WHY does the following statement returns one single quotation mark. exec 'select str=''''''''' str ---- ' THANKS!

ClayG, Thanks.

I am new to SQL, can anyone tell me your opinion on the following stored procedure? SQL server takes hours to process this.Thanks so much... CREATE PROCEDURE dbo.rpt_sp @StartDate DATETIME , @EndDate DATETIME , @ServiceStartDate DATETIME , @ServiceEndDate DATETIME , @CataStartAmt INT...

Thanks ClaireHsu, But runningtotal is an alias not a field in table "account".

Hi all, I am trying to find out the highest positive creditdebit balance and the date it occured for each customer in the account table. I can determine the amount of the highest positive creditdebit balance for each customer using the following codes, but not the date it occured. I can 't group...

Hi everyone, I have a crystal report based on a group of stored procedures ( name_sp;1, name_sp;2, name_sp;3). When I try to add this report to a VB application, it gives me an error message like this: "Run-Time error '-2147417848 (80010108)': automation error the object invoked has...

Thanks K, But the user requested the specific snap shot of last month's summary as Report1 was generated. User do not want to reflect any changes made between last month and the current month in the last month's Report1 for accounting purposes. Therefore creating both last month and current...

I have an accounting report, Report1. For example, In March, user generates Report1 to display some summaries of calculation. Next month, April, when user run Report1 again, she wants the summary info generated in the March to be on the April run side by side, so that they can compare. They also...

I am using CR v7. I have a parameter set up so users can choose any default zip codes in a state for example California. Users can choose discret zip codes or range of zip caodes. I would like to add a default value like "Los Angles" so that when user choose it, all zip codes in Los...

I am using a ODBC database. "checkpaydate" is a datetime data type field in that database. When I use the field in setting up as one of the parameter for a report, the parameter prompting dialog box showed both date and time selection. How do I hide the time field from users. They do...

I am trying to create mailing lable from three tables (member, claim, claimDetail) using CR V.7. Sample fields and data are listed below: Member ====== memId Name Address Dob ----- ---- ------- ---- 1 Mem1 Add1 Dob1 2 Mem2 Add2 Dob2 3 Mem3 Add3 Dob3 Claim ===== claimId memId ------- ----- 1...

I am new to CR and I am using CR V7. I am trying to get members' names and address to be printed on mailing lables. I have defined selection criteria in the select expert. However, certain members have multiple records that fall in the range of the selection criteria. As a result Identical names...

I am new to CR and I am using CR V7. I am trying to get members' names and address to be printed on mailing lables. I have defined selection criteria in the select expert. However, certain members have multiple records that fall in the range of the selection criteria. As a result Identical names...