I'm not sure about your problem. Maybe, reasons can cause it.

- You removed the app but it was not clean up all . Some files or info in registry...

Sorry for late. I investigated the log file and tried to re-install it. It's OK.

Thank for your support

Thanks,

I solved my issue but I got another error while installing:

SQL Browser could not be started. Reason: SQL Browser could not be started. Reason:Service 'SQLBROWSER' start request failed.

SQL Server Browser...

In this case, you must use a system store procedure sp_executesql because your dynamic query is containing a parameter.

EXEC sp_executesql @query,N'@TotalEmployee',@TotalEmployee

Thank guy,

I will try to do this way.

If there is a report parameter. The fomular will be

=DateAdd("yyyy",-1,DateAdd("d",-1,Today()))

You should use

select dateadd(yy,-1,dateadd(d,-1,getdate()))

Thanks,

The DailyTransaction tables and table A are on a server and I only get data from the tables and insert them into A.I only use script(s) to transfer data.

The server...

The simplest way is you use SUBSTRING fuction.

My example:

DECLARE @NegativeNumeric varchar(100)

SET @NegativeNumeric='50.10-'

SELECT (-1)*CAST(SUBSTRING(@NegativeNumeric,1,CHARINDEX('-',@NegativeNumeric)-1) AS numeric(18,2))

Which approach if we populate large data into a table many times?

Eg: Today I populate 2GB data follow below steps

Create Clustered Index on table

Insert data

Create Non-Clusterd Index(s)

Tomorrow, I will also...

Thank GilaMonster,

You mean that the key in Clusterd Index will be added implicitly into Non-Clustered Index(s),right?

Sorry if I'm missunderstanding your idea.

By the way, If I have a query

DECLARE @ReportDate datetime

,@MerchantNumber...

Thanks,

Another way,the key in Clustered Index will be included automatically into Non-Clustered Index (SQL 2005), right?

If YES,come back my example.

I created Clusterd Index on ReportDate.

Then create a Non-Clustered...