... And like always one can tell how much you "appretiate" J C

Cheers,

it is simply an equality operation A = 3 is the same as 3 = A and you are simply searching for those who have 3 counted records with higher...

Last  altered date  is always the same as Created date in SQL 2000. Not sure about 2005 though

Cheers,

J.T.

I think the signature you are using should be :

"While (@First != 'Success')

Try++;"

instead

Christian,

IF you changed dbo.AccountMetrics to AM in the "IN"  subquery  you are creating a totally different query because there is an external dbo.AccountMetrics outside of the IN which is what...

Andrew,

If you got that error is because the Function is expecting a varchar. In that case simply double the quotes like:

Set @select1 = 'Select Reference.RefID, Reference.CreatorString As CreatorString,  Genre.Type As...

the random Top three for each division implies more than 3 records, if that's what you want maybe try:

SELECT  t1.C_division, t1.C_name, t1.C_address

FROM tableC t1

where pkey in (select top 3 pkey...

Set @select1 = 'Select Reference.RefID, Reference.CreatorString As CreatorString,  Genre.Type As Media, dbo.getRowRank(' + @Target + ', Reference.RefId) as Rank'

I don't think you need dynamic sql to solve this...

Ok lets narrow down the issue.

1. Do you have set up an mdw file for the MS Access DB?

2. Are you sure nobody else has the DB Opened?

3. Are there any ldb...

For the TSQL code you will have to PARSE the code. For such action you will be probably better of doing a find and replace from your Source Repository and...

the error is a bit self explanatory. Your ACCESS DB is in use by Another process.(does someone has Access open with that DB?)

The Fact the in QA works when local...

Is it safe to assume that when you said:

dbo.AccountMetrics.tablename you actually meant: dbo.AccountMetrics.Columnname

About the difference in speed you will need to check your indexes usage, the statistics and the...

Erm... sorry but the user is asking for registrations and cancellations PER DAY.

Joe, Your query is NOT doing that

... from mine you can:

create table TDemo ( col1 int primary key, Col2 decimal(10,2), Col3 int, ColFree varchar(20))

go

insert TDemo( Col1, Col2, Col3, ColFree)

    select 1, 10.1, 11, 'ABCD'

union all select...

Yes!

use two ( several) variables the concatenate those in the exec statement like:

select @str1 =  '... ' -- up to 8000

        , @str2 = '...' -- up to 8000