Well I think it was where there isn't a matching key/date.

The query (+principle of charity) backs you, the data (+ same) backs me. We may never know....

Peter, yours will keep repeating the same update, too

I'm afraid there's a silly @cnt in your code, which just gets bigger and doesn't do anything else. There is nothing in the code to tell it which records have...

But I don't see why you can't use a return code or output param.

Doesn't something like this work?

 

set prm1 = objCom.parameters.add(createparameter etc. etc., adparamoutput, blah)

set objRS...

in SQL8+, you could put the results in a varaible and wait until everything else is done before returning it. You could supress the rst at the source, rather than...

Not any remotely straightforward way using bcp. The files generated by bcp are flat files, the only markup being column and row terminators (standardly .csv (comma-delimited files) are viewable in...

where does the aggregation occur? Can you give us an outline of the query?

eg

select col1, min(x) from

(select col1, id from t3 where x

union

select.col1, max(id)-min(id) from t4 group by col1...

perhaps:

UPDATE A SET

--draft code - test well.

-- view name is 'testdeps' - change to the name of a user view  - it should work...

Return the resultset last. Why does the sp succeed even though one of its OA calls fail?

Yes - SQL injection only occurs where free text entered by the user is concatenated into a SQL string for dynamic execution.

any paralellism in the plans?

I know you may need rich or adaptable regexes, but if it's just for checking email addresses, you should at least bear in mind that you can also use LIKE which...

If were just a question of applying  parameters, you wouldn't need the dynamic SQL. Presumably you want to issue a command which involves a DB in non-subsitutable position. Is the verification against...

UNION removes all exact duplicates from the concatenated recordset. This involves a sort. If you won't have or don't mind dupes, use UNION ALL which is a straight concetenation.