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...

azawan (1/5/2016)

---

Dear Scot

First thanks for your reply, i am getting following error message

Msg 8116, Level 16, State 1, Line 8

Argument data type date is invalid for argument 2 of dateadd...

azawan (1/5/2016)

---

Dear Scot

First thanks for your reply, i am getting following error message

Msg 8116, Level 16, State 1, Line 8

Argument data type date is invalid for argument 2 of dateadd...