Thanks! That is very helpful. That is the way I will do it.

I've considered an alternative whereby you define the dataset in RS using a dynamic string that returns...

Antares686 (11/7/2007)

---

Also, I converted over most of my reports to using Stored Procedures. In some of these cases the called Procedure is setup to determine between a set of Procedures...

Please let us know what you do. I'm interested in this as well.

So where wil "John Doe" come from?

a) user entered parameter

b) another column of the same record (as dwall asks)?

I guess you would enter text in a text box, assign it's...

Jon, thanks. I've seen that article and it's exactly the concept I'm talking about. I was hoping for some more detail and examples. It basically described an overview of the...

I agree but please do without the typical IT-"everyone is stupid" attitude.

I always use dynamic sql to build an OPENQUERY so that the statement it sends has the where clause in order to ensure that the less data is retrieved. I...

Thanks, guys, for the syntax confirmation. Our Progress version is 9.1C and were usign the pre-SQL92 version of the Merant ODBC drivers. This combination does not allow the CAST function or...

Could you please tell me the exact CAST syntax. I'm still having trouble. I'm using...

select *

from openquery(cvsc,'select cast(sum(price * qty-ordered) as bigint) from coitem price where ship-date =8/20/2007')

Also, how can...

no, I haven't. I'm having to pull the fields (without the aggregate functions) from Progress and use SQL Server to perform the Sum/Group By.

One thing you can do if you,

1. create either actual tables or ## tables exactly like the temp table you want to use.

2. temporarily change your script to refer to...

Thanks. That made it crystal clear. (It's monday.)

malcome,

That last part of your script (shown below) is interesting. Hard to envision how that works, but it does. Anyone care to explain. Thanks.

DECLARE @RowID INT

SET @RowID = 0

UPDATE @PersonWithCounter

SET...

I realize that you can do this by not giving one parameter a default value. The problem is that I would like to have a default value for all parameters...

The view is used by a number of reports and programs. The number of rows returned by these queries vary from one record to 10 thousand on average.

The database...