.

Since it's a calculation based on the current state of the data couldn't you just use a query?  Why does the balance have to be stored?  Perhaps it...

.

Since it's a calculation based on the current state of the data couldn't you just use a query?  Why does the balance have to be stored?  Perhaps it could be...

Disclaimer: I'm not saying this is the correct way to do this.  But it's compact and nice to look at imo.  String integers convert implicitly and time differences are easily...

Mission accomplished.  It only took 4 days.

[Edit] I thought there was a typo in line 2 but the date difference seems to also need to include the day date.  Therefore, there's a typo in line 3...

• This reply was modified 5 years, 1 months ago by Steve Collins.
• This reply was modified 5 years, 1 months ago by Steve Collins. Reason: Combined dates and times by converting to datetime

What you posted is by definition not a table at all! The table must have a key. You cannot embed spaces in the data element name in any of...

There are different ways to accomplish this.  Here's one.  In order to use the ROW_NUMBER function in the OUTER APPLY I created a table valued function called dbo.func_reserve_accuracy_amount.  When OUTER...

• This reply was modified 5 years, 1 months ago by Steve Collins.

[Edit] Ok, there were 2 updates above and this post was after the first without having read the second.  So I'm wiping it out.  To be updated if possible

• This reply was modified 5 years, 1 months ago by Steve Collins.

It appears this query meets the requirements, or maybe it's close?  Something like this

drop table if exists #test;
go
create TABLE #test (
  ClaimID int NOT NULL,
 ...

Please have a look at this article about string splitters.  I think you're looking for something like this

drop table if exists #stuff;
go
create table #stuff(
  sometext...

• This reply was modified 5 years, 1 months ago by Steve Collins. Reason: Updated with Phil's sample data

We have a stored procedure and job that will email out invoices daily. It all works great, however, we are trying to get the current date in the CSV...

Awesome Steve...u got it.

i have some question about fol. is it part of that update statement where you use "OUTPUT inserted.book_id into @b-2" and that declaration part where u...

• This reply was modified 5 years, 2 months ago by Steve Collins.

Here's an alternate way of writing the query.  I've been experimenting with windowing functions and I'm pretty sure, but not 100% certain, this is equivalent to Scott's query.  I would...