Recent content by HulaGirl

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