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

ouch...that is a hard one.

I think you are saying you have an excel spreadsheet that contains embedded images. say someone pasted half a dozen images into an excel worksheet, and...

yeah it depends on how accurate your data needs to be; a developer might just need to know whether some table has a lot of rows or not, but other...

2000 doesn't have a Schema, just object owners...for each test.object, you want to use sp_changeObjectOwner instead.

sp_changeObjectOwner 'test.table','dbo'

2005 makes it REALLY easy by using a Common Table Expression(CTE) and the Row_number () function

here's a simple example:

with MyQuery As (

select row_number() over (order by name) as RowNumber,*...