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...

awe comeon, you didn't need to post a question for this:

your error says line 24;

if you go to your query, you'll see this, starting (guess where? line 24!):

','+ @Col1 ...

if the database you are connecting to is set at compatibility level 80, the newer syntaxes will be rejected; you just need to change the compatibility level:

right click

properties

options

third drop down...

sure;

declare @FLD4 int

SET @FLD4=42

INSERT INTO Table_B(Fld_1, Fld_2, Fld_3, FLD_4)

SELECT Fld_1, Fld_2, Fld_3,@FLD4

FROM Table_A

homebrew01 (11/19/2008)

---

I want to insert into a table from another table, and from a variable

So Table_A has 3...

googled sql error 913 and the first hit came up with this:

http://www.lcard.ru/~nail/sybase/error/8662.htm

Possible causes of Error 913 are:

Accessing a stored procedure or view that refers to a table in a database...

yeah queries from profiler can be hell to get your arms around;

I've formatted your query in the attachment you see; it's just a bunch of find and replaces to get...

I'm not sure how you'd identify unused indexes; hopefully someone has an idea on how to do that.

if you use the search function and poke around the Scripts section for...