You really haven't given us much to go on here, just a series of terse requests for help. For example, do your tables contain only one row? If...

Where did you read that WHILE loops are better than cursors? They're both loops. Far better is to do what you're trying to do in one set-based operation....

Luis is right about scalar functions. In addition, you've missed out the bit where you execute the string that you've built. However, it still won't work, since:

(a) Your...

First thing to check - is the query on SSMS and SSRS definitely running against the same database?

Second, connection options can make a difference to query performance. Things like...

Beware, though - if you have multiple matches in joinTable for any rows in tableToUpdate then you'll get unexpected results. This is known as a cardinality error, and the...

You don't need to use a cursor at all. Just add an extra join in your inner query to to ListPolicies_CB. It'll (almost certainly) run quicker and use...

dbo.sysdatabases, dbo.sysfiles, dbo.sysfilegroups.

John

If you have access to the server on which the backups were made then you can query backupset and related tables in msdb in order to generate the RESTORE script.

John

I don't think it's a performance issue, but it is a maintenance nightmare. Some third-party vendors encrypt their stored procedures so that you can't copy or change their code.

John

OK, then it's nothing to do with permissions. You won't be able to see the procedure definition unless you have the source code.

John

What message do you get if you run

EXEC sp_helptext 'ProcName'?

John

Beatrix, where are you based? There should be a user group[/url] near you. They're only about once a month, so it's not much of a time commitment unless...

Where does the balance brought forward come from?

From your sample data, it looks as if you need to use the "gaps and islands" technique. Here's[/url] one article; I think...

First, I recommend you create a calendar table. Search this site or the internet for how to do that.

Second, how do you decide whether the next date is "Open"...

Please will you post the DDL (CREATE TABLE statement) and a few sample rows for the table you're exporting from? How many rows are you exporting?

John