Your parameter names seem to be different when you build your dynamic SQL.

@paymentID and @PaymentID are not the same.

I am curious as to how just...

I think the OP wants to know the fifth...

Information you provided in your post is too little for anybody to come up with any meaningful suggestion.

Having said that, look at the db configuration on DB2 side, check...

For large volume of data deletion, I always unload the data to be kept, truncate the table and load the data back. You can reduce your overall time for the...

Try creating a function like the following:

create function [dbo].[removeMultiSpace] (@cString varchar(300) )

returns varchar(300)

as

BEGIN

declare @k smallint, @left varchar(300), @right varchar(300)

select @cString = ltrim(rtrim(@cString))

...

It has nothin to do with SQL 2005.

Do the following:

Open you Excel file

Goto File -> Properties

Click on the "Contents" tab

If you don't see "Sheet1" under Named Ranges, your query...

Assumption:

You have an Account_Master table (and may be some other table(s) you need for the report) as follows

account_id int,

account_name varchar(100),

..

etc..

And you want to run a query for the report...

Disclaimer:

I have not worked with Foxpro DB. However, if you can open the dBase files in MS ACCESS, then this solution might work.

You can put all your dBase files in...

I would try something like this

SELECT ClassId, race

, CASE WHEN SUM(Total) > 0 THEN (SUM(Absent) * 100.00)/SUM(Total) ELSE 0.00 END) as PercentAbsent

FROM (

SELECT a.ClassId, s.race,

...

I would not recommend storing formatted data in the database. If the data elements you are storing are of integer types, you can create a View that right justifies the...