I think you should look into normalizing (splitting the strings so that each value has it's own row) the BID and BWG columns in the #MD table so that you...

You need to include your date parameters in the WHERE clause of the appropriate dataset query e.g.

SELECT DISTINCT

ClaimDetail.PlanPaid

ClaimDetail.Count

ClaimDetail.Account

FROM

ClaimDetail

WHERE (ClaimDetail.Account = @account)

AND ClaimDetail.PlanPaid BETWEEN @startDate AND @endDate

Assuming...

Try this:

Mongosis[/url]

Be sure to check out the requirements and get version 1.7.0 of the MongoDB C# driver. The component can be a little slow, and due to the nature...

I think if I understand you correctly then the short answer is: Not easily.

The idea above is good, but I'm not sure you can use an expression to populate the...

No problem, happy to help 🙂

In case you wanted to extend this to see how many months people pay for in subsequent payment periods, you can change the last part...

Hey there,

This solution gives you what you've described, but with different output columns:

--First I use LAG to find where a new payment period begins by checking the months between the...

Many thanks to both of you - both options work and have given my brain the kick in the right direction it needed at this end of the week! 🙂

Sure, here you go:

CREATE TABLE Request

(

RequestId INT NOT NULL,

EmailAddress VARCHAR(50) NOT NULL

);

CREATE TABLE Quote

(

QuoteId INT NOT NULL,

...