I thought about that, but it just doesn't seem right. This is an isolated case, most Entry rows won't be inserted as scheduled transfers. Entry will be the largest table...

I've been trying to get around this problem too. I tried using the OUTPUT clause of the INSERT statement, but it didn't help me. The OUTPUT clause can only output...

It would be interesting to know if you can spawn threads in SQL CLR. SQL Server already has its own multi-threading load distribution in place for query processing.

It sounds like...

I've attached two files. Change their extensions to .cs (which is not a permitted attachment type). Add these to a C# class library project. (I always find it helpful to...

Well, I haven't tried to do what you're doing, but I have used Oracle via CLR (C# app, not from within SQL Server) and Service Broker, though not in the...

You can use a calendar or tally table to provide all relevant dates then left join each view to that.

Excellent! This works:

SELECT C.transactionDate, S.entryId

FROM Schedule S, Calendar C

WHERE S.intervalId = 4

AND C.transactionDate >= S.nextDate AND (S.endDate IS NULL OR C.transactionDate <= S.endDate)

...

The issue with the milliseconds would be an excellent Question of the Day!

You could use Service Broker to indirectly call the DLL. I've used Service Broker before for similar purposes (accessing serial ports), it works as advertised but has a steep learning...

I am feeling very charitable toward SQL Server right now. It's a great product!

Yesterday, I had to assist another developer in writing queries for MS Access, interpreting its useless error...

I'm going to vote for quality first.

Consistency is a form of quality. If a convention or practice is good enough to be enforced consistently, then it must be a quality...

Yes! Somebody, please kill Hungarian notation! There is no appropriate place for it, IMO.

Modern development environments have made Hungarian outdated.

First, there are too many types and scopes available. Developers...

I didn't think I knew this, but I got it right! When I saw the possible answers, I realized I'd seen this symptom before and was able to deduce the...

I support giving users as much freedom to manage their own machines as they demonstrate they can handle. In my company, most of the employees are engineers, so they are,...

I think you have to escape the less than and greater than signs (angle brackets) as < and > or else everything in brackets is stripped out, thus the connection...