i would highly recommend you have a permanent Tally table; As you read more here, you'll see how usefull it really is;

on SQL2000, you need a table that is at...

I'm including some code below;

there is a table called "tally" that is required; Using a tally/numbers table to do string manipulations has proven to be the fastest way to manipulate...

just guessing, but one of your columns that you are gathering dynamically might be named INDEX and causes a keyword error in the syntax check;

PRINT your SQL statement just before...

Your ERD program HAS to have the ability to define joins between the tables it queries against....I think the place to fix your issue is in the application itself, rather...

Here's some hints on your questions, as this looks a lot like homework:

first, if EMPID is the primary key for EACH of the 150 tables, are they identity() generated or...

i believe the error is here:

User].FirstName + " " + [User].LastName as FullName

double quotes are treated the same as brackets: [ ]

so it is looking for a column named [emptyspace],...

do you have the ability to make the ERD use a specific view for the report, instead of underlying tables?

if that were true, you could cleanup some of the queries,...

i think because he's locked into using the ERP to generate the queries and cannot adjust them, we are a bit limited on suggestions....the executtion plan will help a lot,...

first you said row size, then you said table size...which is it?

there is a difference between the max space that a row can take, and the actual length of any...

you can't substitute a variable for an object name like that directly...you need to use dynamic sql to accomplish what you want:

declare @sql varchar(max)

SET @sql ='SELECT

c.CustomerID,

c.CompanyName,

c.City,

c.ContactName,

o.OrderID,

o.OrderDate,

od.UnitPrice,

od.Quantity,

od.UnitPrice * od.Quantity AS ExtendedPrice

FROM

Customers...

i think i had a similar issue, and it was related to a weak password for my user; i don't remember if it was my sa account or my admin...

not sure if this is what you are looking for;

do you want the sum() of quantity grouped by vendor id?

something like this?:

[font="Courier New"]SELECT

  SUM(X.Quantity) AS QTY,

  TMPData.VendorID  

FROM dbo.GetAllReorderScannedItemsByDate() X

  INNER JOIN (SELECT...

ugg...i had a long explanation, and it got lost when posted...rewriting it again here:

A version of the RichText control exists in All versions of .NET; it's under System.Windows.Forms.RichTextBox.

However, just because...

here's one possibility:

if it's not parameter sniffing as mentioned above, which uses a bad execution plan so it's slow,

it might actually be the data and the time it takes to...

most of the issues appear to be that the dll is not registered on the server.

'Invalid class string' implies that the control is not installed on the server...specifically that the...