I am not sure about the exact scenario and the situation but here is something that might help you in determining your solution:

declare @FirstTime datetime

declare @SecondTime datetime

set @FirstTime = '2011-11-05...

Based on your scenario and insufficient data given, I may not have the accurate solution for you but I have something herein that might give you and idea how to...

Yes, there is a great way to improve to a certain extent.

Please read up on a section known as advance queries using common table expressions.

I personally have benefited quite a...

GilaMonster, excellent points and directions.. currently visiting the URL you have posted..

Taking out my request.

I have create other UDF and USP to get what I needed and don't need a CLR.

Thx anyway guys..

If anyone is interested in knowing what...

The SP returns the data-set as a tabular and good for RDL or crystal reports. But, this sp is really not returning a "table" value set as in Functions.

In another...

The main error on creation is:

failed on creating DMO object

Hi Kraig,

I find your article very intriguing and useful.

We have a replication process that at some point during a week; well, either does not insert a record or it is...

Jeff,

I think, and I could be wrong, if they are not having the "void" system then probably will not leave a hole in the sequence either.

Additionally, the trust and...

what a nice method.. saved me a cursor and additional coding..

thx man..

I agree with your explanation, a very good one I might add.. and also a 64 cents comment of mine would be that the regular view is also useful in...

I think in normal accounting, at least in usa, there is a void process that can cancel.. in fact.. any checking account can handle that therefore it should not matter...

hamid, salam.. do not translate farsi to english directly.. because you might confuse the readers..

if you want you can write in FarsEnglish and I can translate that for you for...

good question Dave.. I don't see any reason for the incremented sequential number for voucher.. the only time that I might have seen that happen was if that a record...

very good thinking, but, that did not work.. same error message about creating this type of query in a "named query" in data view part of the solution.

🙁