Is the "base length" of the columns at least the same? That is, when you say the value is the same except chars are added, is the initial value...

Not at all :-D. Slapping...

Jeff Moden (1/12/2016)

---

I've got to say that I totally disagree with that. The clustered index is frequently used for...

SELECT CAST(size / 128.0 AS decimal(9, 2)) AS size_mb

FROM sys.database_files

WHERE type = 1

;WITH cte_days AS (

Select 1 AS day#, 'Mon' AS day UNION ALL

Select 2, 'Tue' UNION ALL

Select 3, 'Wed'...

Steve Jones - SSC Editor (1/12/2016)

---

I'll grant you that if there are no non-clustered indexes, this isn't a problem, but you have other problems if you have no indexes on...

If you need a procedure to run in the context of multiple databases, create it in the master db, start the proc name with "sp_", and, after you create it,...

It's not necessarily bad....

Some third-party vendors offer such tools. Naturally all -- or at least most -- of them cost money.

MS provides the tablediff utility, which is free. It's command-line only,...

SQLisAwE5OmE (1/11/2016)

---

ScottPletcher (1/11/2016)

---

I would think it would be something like below.

Note: I assumed from the context that you need to match only the *child's* birthday, even though you said "all...

It seems you want to see a tester that has never performed a check on a given part id, not just for the first/last check.

If so, I think you could...

I would think it would be something like below.

Note: I assumed from the context that you need to match only the *child's* birthday, even though you said "all members". ...

You could also, of course, instead simply insert the values from the tvp into a properly clustered temp table, and then process using the temp table.

When I run the exact code I posted above, I get these results:

start_dateFuture1_Datefuture2_datefuture3_datefuture4_date

2016-01-012016-02-052016-03-032016-04-272016-05-16

2016-01-102016-02-142016-03-102016-05-042016-05-23

2016-02-202016-03-262016-04-212016-06-152016-07-04

2016-03-132016-04-172016-05-122016-07-062016-08-01

azawan (1/6/2016)

---

@scot-2

Thanks for your reply

After running your query i got below results

start_dateFuture1_Datefuture2_datefuture3_datefuture4_date

2016-01-012016-02-05 2016-02-05 2016-02-05 2016-02-05

2016-01-102016-02-14...