Recent content by ClayG

Seems reasonable that when you merge an earlier version and a later one, you basically end up with the later one as the result, if there are no branches involved. It probably would be different if, say, the non-Head version was a branch that contained changes not in the Head.

I think its a problem of timing of the creation of objects. If A refers to B, if you define A first (which is usually allowed, eg procedure A refers to table B), then db cannot record dependency because B does not exist yet (especially because dependencies are by object IDs, not name, no object...

When I have done this sort of thing, I put the data into some kind of database engine, even a primitive one: MS-Access, or even create DBase5 files via ODBC manager. Then this sort of matching logic can be done with sql Selects with 'Like' etc.

I don't use TextPad, but I assume you would need to call ISQL.exe . Or OSQL. See its parameters: isql.exe -? (in c:\program files\Microsoft SQL Server\bin\).

You can explicitly convert collection in an expression where you use a column, eg, where m.fullname = a.fullname collate sql_latin1_general_cp1_ci_as

Try Set NoCount On at the start of the stored procedures

I think you can do this Select GroupID, Week, Username, Wins, TBD, ( Select Count(*) from Results R2 where R2.GroupID = R1.GroupID and R2.Week = R1.Week and ( R2.Wins < R1.Wins or R2.Wins = R1.Wins and R2.TBD > R1.TBD )...

The only way you get any variables into OpenQuery is to make the whole statement dynamic: set @stm = 'SELECT @BeeDirectCountTransactions = Count(*) FROM OPENQUERY(sbdatabase1,''select * from ' + @TableName +''')' Seems crazy because the inner statement going to the remote server is...

You could look in the SysDepends table for tables referenced by the SP. SysDepends is not always 100% correct, but usually OK for this.

Are you returning you 'values' in a recordset or some other way (output variables?). Details please. Otherwise, for a wild guess, try Set NoCount On in the procedure (long story)

SELECT @cmd = 'SELECT * INTO #OPEN_CLOSE_ALL FROM OPENQUERY(PHPROD, ''SELECT DISTINCT A.PRI_ACCT_ID, ... TO_CHAR(E.PROC_DATE,''DD/MM/YYYY'') ... You have string within strings within strings. Level1: @cmd = '..' Level2: the Oracle statement ''Select Distinct ...'' correctly has two quotes...

your own spid is the variable @@SPID

objDocument.writeln "variable = inputbox(""enter value:"",, variable)" As for passing back to 'main script', you could Dim variable at the global level.

It would be the command-line arg. It sounds like the command-line of the association does not have the argument in it - you need %1 with quotes: Command: c:\progampathxxxx\youprogram.exe "%1" Also switch off "DDE" unless you know how to deal with it (remove the DDE subkeys if you are...

Also, you seem to build a select statement string that is not used, you just open the whole table instead ?