I couldn't figure out a way to modify Lutz's method to work correctly, so here is the Quirky Update method that he mentioned.

You MUST follow ALL of the rules...

Check out the ForEach Loop Container.

It does not shrink the file; it marks the areas in it as available for reuse. If you're taking regular transaction log backups, it should grow to a point, and...

Lutz - looks great... except this is a SQL 7/2000 forum.

While technically not load balancing, here is an article on load distribution. I think that this is about as close as what you're likely to achieve with the current product.

GilaMonster (10/14/2010)

Wasn't at client today. Only there 3 days a week (more...

Here's some T-SQL code to convert a number into a corresponding letter. It should be relatively straightforward to convert into VB/C+ for code in Reporting Services:

DECLARE @page int,

...

GilaMonster (10/14/2010)

Fast typing. 🙂

You haven't...

GilaMonster (10/14/2010)

WayneS (10/14/2010)

LutzM (10/14/2010)

Question: How many false statements can you find...

Have you checked out this link? It might provide some help to you.

LutzM (10/14/2010)

Question: How many false statements can you find in his...

CELKO (10/14/2010)

1) Declare a table variable in the Outside procedure

2) Use the Inside procedure to...

So, is this getting you your desired results?

One of these should get you going down the right track.

if OBJECT_ID('tempdb..#Documents') IS NOT NULL DROP TABLE #Documents;

CREATE TABLE #Documents (document_id int PRIMARY KEY CLUSTERED);

INSERT INTO #Documents

SELECT 1 UNION ALL

SELECT...

This type of issue was recently solved on this forum. Please try this solution, and see if this solves it for you also.

Please let us know how this works for...