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 4 years, 11 months ago by Steve Collins.
• This reply was modified 4 years, 11 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 4 years, 11 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 4 years, 11 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 4 years, 11 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 4 years, 12 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...

It's missing a comma at the end of line 6.  There's not any sample data so I'm not able to run the code.

It appears you're looking for something that either works completely or fails and completely rolls back.  Something like this try/catch script which doesn't have error handling or parameters.  The reserved...

• This reply was modified 4 years, 12 months ago by Steve Collins.
• This reply was modified 4 years, 12 months ago by Steve Collins.

4. There 56 left brackets and 56 right brackets in your code which could/should be replaced by nothing.  They're necessitated by spaces in object names.  Please, please, please never again,...

It's good news we're making...

A couple of things

1.  Opening an xlsx file is going to be a tough sell around here.  Not a good practice.

2. Table aliases are essential for readable code.  Please choose...