Sorry about that but yes it pertains to the application connection to SQL.

e.g. using ADO might use either of these

Provider=SQLOLEDB;OLE DB Services=-1;Data Source=server;Initial Catalog=dbname;User ID=username;Password=password;APP=text

DSN=dsnname;UID=username;PWD=password;APP=text

If you add APP=text to your SQL connection then the info appears under Application in EM (process info). I use this so I can associate spids with users.

It means your connected to the server in question.

If you're referring to me maybe my reply was confusing! I have already achieved this by downloading existing source from net (to save time) compiled the DLL and wrote a...

I installed 2.7 on IIS server and found all my connections to SQL (DSN's) failed. It seems that the connection properties in 2.7 changed. Other than that found 2.7 OK.

...

I wanted to do this in SQL7 and produced a DLL used by ActiveX Script in DTS.

"uid" will need execute permission to db.dbo.proc_name on "server" as well as access to the database db.

xp_cmdshell is a restricted command and can only be called by sysadmin/dbo users. If your testuser is non sysadmin then it does not have permissions to the command even by...

Try using subquery

SELECT Case_Table.Case_Number, Note_Table.Note_Type, Note_Table.Date_Entered

FROM Case_Table

INNER JOIN Note_Table ON Case_Table.Case_Number = Note_Table.Case_Number

AND Note_Table.Date_Entered = (SELECT MIN(Date_Entered) FROM Note_Table WHERE Case_Number = Case_Table.Case_Number)

WHERE Case_Table.case_number = 15214

How about

SELECT Case_Table.Case_Number, MIN(Note_Table.Date_Entered) AS 'Date_Entered'

FROM Case_Table

INNER JOIN Note_Table ON Case_Table.Case_Number = Note_Table.Case_Number

GROUP BY Case_Table.Case_Number

The sql should do that. e.g. if A contains keys 1,2,3 and B contains 1,3 then the query will return 2 only.

SELECT A.*

FROM A

LEFT OUTER JOIN B ON B.key = A.key

WHERE B.key IS NULL

will show all rows in A that do not have a corresponding key in B

Also if you specify a DSN in Data source instead of path & name of mdb will generate this error.

When I want leading zeros I do

REPLACE(STR(numericcol,overalllength,numdecplaces),' ','0').

Antares686, which solution do you think is the more efficient or does it not matter?

Try

STR(OID,15,0)