The TOP 1 was because INSERTED could technically return multiple rows and you can't assign the values of rows to a single variable.

ONSA_NSS.datesent = GETDATE()

Scott has a very good point.  With a scheduled job, you can at least test to see if the job completed and then try again on the next run (using...

That seems pretty straighforward.  Here's my example tables and the trigger.  I used a bit for the AutoSend field instead of Yes/No but you can adjust for that.

--Create example tables

create...

Very true.  Cursors will suck the life out of a SQL server.  Here's another angle for a set based operation.

First, I had to assume that we have (or can add)...

I believe you need to change the regex by removing the |\s? at the end.  That looks like a blanket search for whitespace. So it would look like:

'({\\)(.+?)(})|(\\)(.+?)(\b)}'

I am humbled by your veteran approval.

I should have caught that one off scenario but I had focused on dealing with a missing...

My error.  When using merge replication, the entire thing is one big transaction.  RDA on the other hand can be broken into individual transactions.

What that means is that SQLCE is...

Sorry, thought you were in SQL 2005.

I think it can be done with Windows API calls to OpenClipboard (e.g. http://www.mentalis.org/apilist/OpenClipboard.shtml) and then calling SetClipboardData and GetClipboardData with different formats. ...

OK, that's a little different than my original answer was trying to do.  Basically, you want to walk your tmp_D_Dates table instead, incrementing this row counter as you go.  Although...

So fiscal_day is a counter of the items in that period order by date?  So if the data looked like this, the results would be:

Assuming the period is defined...

Maybe a snippet of sample data would help, I don't quite get the goal.

You have table mend_period which looks like:

Then you have table tmp_D_Dates which looks sort of like:

Couple ideas:

Use a try-catch block to catch a failed Connect call.  You should probably set a reasonable LoginTimeout value first.

I believe you could use SQLInstance.Status to check whether the service...

No answers here?  I'll add my $.02 and see what's up.

I don't think it's entirely a matter of processing, on the PocketPC it is all about storage and the amount...

Ooph.  OK, it looks like the SQL code is only looking for duplicate brokers (address and DBA (which includes zip code) are similar but not identical).  Then the ASP code...