Now I see what's going on. Since you didn't post your sample data in a consumable way even if you've been around a long time, I'll just point you to...

Maybe something like this:

SELECT id

,knt

,dt

,name

...

I prefer to do it using CROSS APPLY and table constructors. Here's an article on that: http://www.sqlservercentral.com/articles/CROSS+APPLY+VALUES+UNPIVOT/91234/

IF OBJECT_ID('tempdb..#test') IS NOT NULL

DROP TABLE #test

CREATE TABLE #test (colx...

What have you tried? Where's the sample data and expected results?

I just wanted to include a test because people shouldn't just trust anything they read online. 😉

--=====...

PhilPacha (12/4/2015)

---

A CAST on the database column would likely preclude the use of an available index, while using the native values would allow index usage, if available. The >= and...

First of all, you need to reference the CTE through a SELECT statement. Something like this:

--Insert a reservation for a key during specific dates

WITH Dates AS (

SELECT

[Date] = CONVERT(date,'20151127')

UNION ALL...

Jeff Moden (12/4/2015)

---

Is anyone else not getting notifications from posts? I haven't gotten a 1 since Nov 29th. I sent an email to the webmaster but no response...

Actually, that's also prone to error. Even with a view, the error could appear.

I like...

I don't remember most of Doof's inventions, but my favorites are the Inator-inator and Norm. 😀

To always return a row, either with a value or a null. I might have done it different,...

Here's your sample data in a proper format so anyone can test a solution. Please post it this way next time.

CREATE TABLE TableA(

personid int,

...

A filtered index might do the trick, but only for the condition defined to filter the index. With that, you simply query sys.dm_db_partition_stats, something like this:

SELECT SUM (row_count)

FROM sys.dm_db_partition_stats s

JOIN...

Can you give some examples of your inputs and ouputs?

You added a lot of work when it's not needed. Your function can be reduced to a single statement.

Do you have...

It's not exactly about the users, but about how the data changes.

Ideally, you'll do it daily. However, you might not need to have index/statistics maintenance tasks daily and you can...