If you want administer sql from the PC, install the client tools on that PC. This will set details in the registry and install the snap-in required.

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