But the table is flagged as a user table (whether by error, design or feature), therefore the correct answer is correct

from a certain point of view

Tom,

You are using table instead of db

Try this

declare @sql as varchar(300)

set @sql = '

  declare @intCount as int

  if exists (select name from ?.dbo.sysobjects where name = '+CHAR(39)+'users'+CHAR(39)+'...

No, you can use the OLE DB driver to connect between servers, it connects the same way as an application would. Linked servers are only necessary for 4 part naming...

You could use DTS to export from processing to production, or import to production from processing depending on which server you want to run the DTS.

REPLACE(

SUBSTRING(LEFT(@stringvalue,

CHARINDEX('Subject:',@stringvalue)-1),

CHARINDEX('To:',@stringvalue)+4,LEN(@stringvalue)),

CHAR(13)+CHAR(10),'')

How about

select P.vcFname, count(*) as x

from tbl_Projects P

inner join tbl_ProjectsResearchers PR

on PR.fk_intprojectID = P.pk_intProjectID

group by P.vcFname

For me, for each of my procs, I create a txt file containing sql to drop the proc (if it exists), report the drop, create the proc and report the create.

I...

or

select a.docnum

from F0413 a

inner join F0911 b

on b.docnum = a.docnum

and b.doctype IN ('PK','PO')

group by a.docnum

having sum(case when b.doctype = 'PK' then 1 else 0...

No apology needed. 

I liked your code, it is the way I like to do it, not sure why I did my differently other...

Jeff,

Well done, I do not want to steal your thunder but I must take issue with your post.

First, my query does return the first value (ID=1920). 

Second, I extended the data...

SELECT l_use, COUNT(l_use) countlu FROM #t

GROUP BY CAST(l_use as varbinary),l_use

This should work, but may be bad performance (depending on indexing) for a lot of rows

select a.*

from  a

left outer join b

on b.col1 = (select max(col1) as col1...

I have been thinking about this and have not come up with a simple answer yet. I am still unsure of what you want. Your asp is showing the details already...

Josh,

Create a new thread with details of your procs / triggers and what you expect them to do. This QOD is contrived to produce the result. Without details of what...

Few questions

Do you want the sums (revenue, expenses etc) as well as calculated totals?

Is there a fixed number (and name) of sums and totals?

Do you want the results in rows or columns...