I have had it work for me via a UNC path, but it is very slow!

Are you using UNC paths? (drive letters won't work)  What options did you set in...

Maybe try pushing from Progress to SQL via SQL's ODBC (I think you can get something like it for *NIX boxes)?  I have similar problems with SQL accessing DBFs -...

You have set your SQL Server to run using lightweight NT fibres rather than threads.  Somewhere on the MS site there is a discussion about the pros and cons -...

Then the 2nd interpretation is correct..  Are you likely to use this data once or are you using it to perform the ID->English resolution many times on the fly? 

If...

I now see what you mean... You want two comma separated values, one for the IDs and one for the names.

Try something like

declare @names varchar(8000), @values varchar(8000).

set @names = ''

set...

You'll probably want to encapsulate the code in a transaction and have it work as a trigger or, better yet, encapsulate such logic in the stored procedure that does the document...

Without looking at your code in depth, it is obvious that you want a where clause that can have any string in it so that you can filter based on...

Normally you would use a view rather than a computed column, except when you want to search based on the value of the computed column...

For example, if you had

Qty, ItemPrice,...

I have not really looked into doing that, but it does sound like a useful thing to work out..

I can think of two approaches.

1. Rather than using SQL's grant, deny...

Do you have to generate the SQL statement?  You can create an SP with a parameter of type TEXT - then insert the value of that parameter (along with the...

It's not working with physical disks - it is working with your logical drives such as C:, D:, etc.  So what is doing the physical storage (eg, single IDE disk,...

Few queries...

1. Are you running windows with the /3GB switch in boot.ini - this will ensure that 3GB, not the usual 2GB, of RAM is available for application data.

2. How...

I am shortly about to try the same thing...  But from what I have read, there is no problem (same as you can have SS7 and SS2k on the one...

Plz don't cross post..

I replied to your question here...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=214703

But, I thought you just wanted to ensure they had at least one campaign.  If not (ie, you want to show...

Why not join to the campaign table?  You needn't return any data from it (same as you are using the USR table but not returning data).  The distinct clause will...